Skip to main content

 

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 aProjectProgram].

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


p0.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 

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.


Did you get any solution for this? @Roy Almeida 

Best Regards,
Timo


Reply