My Oracle Support Banner

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 later
Information in this document applies to any platform.


On : 12.2.9 version, MICC Transfer to TSC

When attempting to load the data for procurement,
the following error occurs.


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( oracle.jdbc.driver.T4CTTIoer11.processError( oracle.jdbc.driver.T4C8Oall.processError( oracle.jdbc.driver.T4CTTIfun.receive(

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.


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

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