Procurement - PO-ECC Full Load Program Failing With Errors ORA-06502 (Doc ID 2716443.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

When attempting to run PO PCC ECC Data Load, the following errors have been seen to occur:

Error:
Program ECC Program failing for following datasets:

po-pcc-orders - There is an error while trying to ingest data for this load rule po_pcc_orders_util_pvt.get_ecc_data_load_info with dataset po-pcc-orders for job 23,449
po-pcc-agreements - There is an error while trying to ingest data for this load rule po_pcc_agreements_util_pvt.get_ecc_data_load_info with dataset po-pcc-agreements for job 23,453
po-pcc-requisitions - There is an error while trying to ingest data for this load rule PO_PCC_REQUISITIONS_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset po-pcc-requisitions for job 23,457
PO_PCC_REQUISITIONS_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset po-pcc-requisitions for job 23,457

load rule po_pcc_orders_util_pvt.get_ecc_data_load_info with dataset po-pcc-orders
for job 19,334 ORA-06502:

load rule po_pcc_agreements_util_pvt.get_ecc_data_load_info with dataset po-pcc-agreements
for job 19,334 ORA-06502

Replication Steps:
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Run ECC po-pcc dataload
3. Program errors out

Cause

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