My Oracle Support Banner

ORA-00936: Missing Expression Error Occurs While Running PO ECC Strategic Sourcing Data Load Request (Doc ID 2676830.1)

Last updated on JUNE 13, 2020

Applies to:

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

Symptoms

After ECC upgrade from V3 to V4, the PO ECC Strategic Sourcing Data Load returns an error as below

ERROR

1.o.e.i.u.s.i.DataLoadControllerServiceImpl - 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 14,130
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

STEPS

The issue can be reproduced at will with the following steps:

1. Login to the E-Business Suite and choose the Purchasing Module.
2. Run ECC Strategic Sourcing Data Load
3. Errors are seen in log

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


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