My Oracle Support Banner

PO ECC Strategic Sourcing Data Load Error - ORA-00936: missing expression (Doc ID 2859307.1)

Last updated on JUNE 14, 2023

Applies to:

Oracle Sourcing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When attempting to run PO ECC Strategic Sourcing Data Load the following error occurs.

ERROR
-------------------

There is an error while trying to ingest data for this load rule PON_PCC_NEGOTIATIONS_UTIL_PVT.get_ecc_data_load_info with dataset pon-pcc-neg for job java.sql.SQLSyntaxErrorException: ORA-00936: missing expression




STEPS
-------------------
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Navigate to Reports -> Run and run the "PO ECC Strategic Sourcing Data Load"
3. Concurrent request errors out and does not complete

 


 

Changes

 

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
Changes
Cause
Solution
References


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