DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, March 29, 2016



Planning Ods Load Errors: ORA-00920: invalid relational operator
=========================================


On : 12.1.3 version, ATP based on collected data

When attempting to run MSCPDCW module: Planning ODS Load Worker ,
the following error occurs.

ERROR
-----------------------
21-MAR 11:08:54 : Procedure MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND started.
21-MAR 11:08:54 : ORA-00920: invalid relational operator
21-MAR 11:08:54 : ORA-00920: invalid relational operator
21-MAR 11:08:54 : Sending message :-9999999 to monitor.
21-MAR 11:08:54 : Error_Stack...
21-MAR 11:08:54 : ORA-00920: invalid relational operator

21-MAR 11:08:54 : Error_Backtrace...
21-MAR 11:08:54 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3013
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3232



SOLUTION :
=======

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for VCP 12.1.3.6 Patch 12695646 or later

2. Ensure that you have taken a backup of your system before applying 
the recommended patch. 

3. Apply the patch in a test environment. 

4. Confirm the following file versions: 
msc patch/115/import/US/mscprg.ldt 120.86.12010000.61 or higher.

5. Retest the issue. 

6. Migrate the solution as appropriate to other environments.

No comments: