OM Command Center Data Load - Fails with ORA-00923 Error
(Doc ID 2780707.1)
Last updated on APRIL 04, 2022
Applies to:Oracle Enterprise Command Center Framework - Version 12.2.10 and later
Information in this document applies to any platform.
On : 12.2.10 version, ECC Order Management
When attempting to run the OM Command Center Data Load, the following error occurs. Using this functionality for the first time. Followed the steps in 2495053.1.
There is an error while trying to ingest data for this load rule OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ont-lines for job 23,537
java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
The issue can be reproduced at will with the following steps:
1. ECC developer
2. Data Load submission
3. Enter parameters and submit
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