My Oracle Support Banner

Error In Extract Data For Oracle Supply Chain Planning Cloud After Patch 27082512 (Doc ID 2487942.1)

Last updated on FEBRUARY 12, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 to 12.1.3.9.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In a VCP 12.1.3.9.1 Instance:
Patch 27082512 Installed on 12.1.3 EBS to enable integration with Oracle VCP Cloud. - Extract Data for Oracle Supply Chain Planning Cloud concurrent program, we are getting error

Data extraction worker error out below error-
Return code from MSC_APCL_CUSTOM.ENTITY_PRE_PROCESS :0
Return Error from MSC_APCL_CUSTOM.ENTITY_PRE_PROCESS :

Drop Changed Snapshots error out with below error
ORA-00933: SQL command not properly ended
Need to delete Snapshots ending with brackets ().


Changes

Customer  had applied patch#27082512 on EBS instance to enable integration with Oracle VCP Cloud.
After applying the patch they have run the script(configuration.sql) to add the instance and sites mentioned in <Note 2339436.1>.

In instances form(Advanced Planning Administrator--> Admin--> Instances) they are not able to see the sites which they have added using configuration.sql script.

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