Enterprise Command Center: Data Load Indirect Procurement (po-pcc-ind-proc) Ends in Error
(Doc ID 2613857.1)
Last updated on MARCH 15, 2022
Applies to:
Oracle Purchasing - Version 12.2.9 and laterInformation in this document applies to any platform.
PO_PCC_IND_PROC_UTIL_PVT.plb
Symptoms
On : 12.2.9 version, MICC Transfer to TSC
When attempting to load the data for procurement,
the following error occurs.
ERROR
The status message for Audit Data Set ID:
Failed as one of the load rules failed which is [id = xx,xxx, PO_PCC_IND_PROC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO].
Please check the load rule audit entry for more details. Trace file generated with suffix xxxxx.
The status message for Data Set Details:
There is SQLException while applying load rule for dataset po-pcc-ind-proc for job xx,xxx. Exception details ORA-01427: single-row subquery returns more than one row oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
Steps to reproduce:
1. Responsibility: ECC Developer
2. Navigate to: Data Load Submission for Procurement
3. Data set "Indirect Procurement (po-pcc-ind-proc)",
Load type = Full Load.
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 |