My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.