Enterprise Command Center (ECC) Procurement Full Load Error On Po-pcc-orders ORA-06502: PL/SQL: Numeric or Value Error: (Doc ID 2718919.1)

Last updated on JUNE 14, 2023

Applies to:

Symptoms

Using Purchasing, Version 12.2, Enterprise Command Center Version 5

Actual:
Enterprise Command Center (ECC) Load is failing with error.

Expected:
Enterprise Command Center (ECC) Load should not fail with errors.

Error:
Failed as one of the load rules failed which is [id = 9,058, po_pcc_orders_util_pvt.get_ecc_data_load_info]. Please check the load rule audit entry

There is SQLException while applying load rule for dataset po-pcc-orders for job 11,608. Exception details ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.FND_NUMBER", line 20 oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)

===============================================================

Also seeing the following error in different testcase:
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 30,628
java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Conduct the ECC load.
2. Find the concurrent requests in question are having errors and have failed to load.


Other:
po_dist.po_distribution_id (+) = gt.num4 AND po_dist.rowid = dfv3."'PO_ORD_D_ROW_ID'" (+) AND po_dist.task_id = pa_task.task_id (+) AND pa_task.project_id = pa_project.project_id (+) AND deliverable.deliverable_id (+) = gt.num5 ) PIVOT (max(po_ou_name) as po_ou_name, max(po_status) as po_status, max(po_sub_status) as po_sub_status, max(po_reservation_status) as po_reservation_status, max(po_group_status) as po_group_status, max(po_line_type) as po_line_type, max(po_line_status) as po_line_status, max(PO_EXPENDITURE_ORG) as PO_EXPENDITURE_ORG, max(po_dist_destination_type) as po_dist_destination_type, max(deliverable_status) as deliverable_status, max(okc_deliverable_type) as okc_deliverable_type, max(okc_business_document_type) okc_business_document_type for LANGUAGE in ('US' "US"))
Status Message
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 11,608 ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.FND_NUMBER", line 20 oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)

Cause

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