Question

Unable to publish a custom field due to ORA-20150: COMPILE_ERROR2: Error during compilation of LU [ProjectProgram]

  • 30 November 2022
  • 2 replies
  • 371 views

Userlevel 4
Badge +7

 

Customer is on Apps10 UPD15 and is unable to publish custom field on ProjectProgram LU.

This works fine in our internal DEV environment, but not the customer’s environment.

I have a simple text attribute/persistent field and it results in the following error:

ORA-20150: COMPILE_ERROR2: Error during compilation of LU [ProjectProgram]

Don’t know if something is wrong or corrupt with the ProjectProgram LU or the customer’s ORACLE version is not parsing the code correctly. (or do we have a new framework bug?)

Any ideas what to look for?

 

 

Full text of error is as follows:

 

ORA-24344: success with compilation error

ORA-20150: COMPILE_ERROR2: Error during compilation of LU [ProjectProgram].

Error details: -24344 in \CUSTOM FIELD CODE\PROJECT_PROGRAM_CFP.API\PROJECT_PROGRAM_CFP
   Line 72:2: PLS-00103: Encountered the symbol ")" when expecting one of the following:

   <an identifier> <a double-quoted delimited-identifier>
   current delete exists prior


[0.10 (+0.00)]  __anonymous_block at line 8 CUSTOM_FIELDS_API.DEPLOY__ at line 4342 CUSTOM_FIELDS_API.DEPLOY__.CORE at line 4337 
CUSTOM_FIELDS_API.DEPLOY___ at line 4798 CUSTOM_FIELDS_API.DEPLOY___.CORE at line 4726 CUSTOM_OBJ_SYS.DEPLOY_CODE__ at line 8398
 CUSTOM_OBJ_SYS.DEPLOY_CODE_MSG_RECURSIVE___ at line 6958 CUSTOM_OBJ_SYS.DEPLOY_CODE_MSG_RECURSIVE___ at line 6958 
CUSTOM_OBJ_SYS.DEPLOY_CODE_MSG_RECURSIVE___ at line 6968 CUSTOM_OBJ_SYS.RUN_STATEMENT___ at line 5868 CUSTOM_OBJ_SYS.COMPILE_ERROR___ at line 6867
 ERROR_SYS.COMPILE_ERROR_ at line 1520 
ERROR_SYS.RAISE_APPLICATION_ERROR___ at line 129 ERROR_SYS.RAISE_APPLICATION_ERROR___.FORMAT_CALL_STACK___ at line 123 


2 replies

Userlevel 4
Badge +7

Update: Customer seems to be missing comments on PROJECT_PROGRAM view and also has a custom column called DESCRIPTION. Possibly the reason for the error.

Userlevel 1
Badge +5

Did you get any solution for this? @Roy Almeida 

Best Regards,
Timo

Reply