Extract To Cloud - MSC_APCL_OP_ATP_ASSIGNMENTS_V Will Extract Excess ATP Assignment Data
(Doc ID 3048206.1)
Last updated on SEPTEMBER 17, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6 and laterOracle Supply Planning Cloud Service - Version 11.13.17.05.0 and later
Information in this document applies to any platform.
Symptoms
ATP rules are assigned to items and are collected for Cloud via view - MSC_APCL_OP_ATP_ASSIGNMENTS_V into file --> ATPRuleAssignments.csv
Some organizations have not been enabled for Cloud collections, but their data is extracted and causes errors when loading the data to Cloud
To reproduce, go to /View /Requests /Submit a new Request - launch request - Extract data for Oracle Supply Chain Planning Cloud with parameters ATP Rules - Yes and Items - Yes
The Load Entity process started for entity OP_ATP_ASSIGNMENTS with refresh number 11002.
ATP_RULE_NAME ITEM_NAME ORGANIZATION_CODE CATEGORY_NAME ASSIGNMENT_TYPE ERROR CODE ERROR TEXT
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------
[CUSTOMER SPECIFIC DATA for 5 Columns]
COLUMN ERROR CODE = ERROR_REC
COLUMN ERROR_TEXT - You must provide a valid value for the ITEM_NAME attribute.You must provide a valid value - for the ORGANIZATION_CODE attribute.
... continues for 1000 lines ... then prints ...
Only 1000 errors were reported in the log file but there were additional errors which have not been logged due to performance issues.
The number of records considered by the Load Entity process: 235197. The number of valid, error, and deleted records: 1195, 234002, and 0.
Gathering Table stats for MSC_ATP_ASSIGNMENTS
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 |