MSCPDP Fails with ORA-06553: PLS-103: Encountered The Symbol "IN" (Doc ID 434729.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.8 and later
Information in this document applies to any platform.
EXECUTABLE:MSCPDP - Planning Data Pull

Symptoms

When attempting to run ASCP data collections for the first time the following error occurs:

 MSCPDP module: Planning Data Pull

ORA-06553: PLS-103: Encountered the symbol "IN" when expecting one of the following:

<an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier>" was substituted for "IN" to continue.

Steps:
Responsibility : Advanced Supply Chain planner
Navigation - Collections - standard
1. run standard collections


Note : This issue can also appear for other symbols.

examples :

PLS-103: Encountered the symbol "AT" when expecting one of the following:
PLS-103: Encountered the symbol "OR" when expecting one of the following:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms