Concurrent Program Serial Number Generation Is Failing With Error ORA-00900 - invalid SQL statement
(Doc ID 2619203.1)
Last updated on JUNE 15, 2022
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Concurrent program "Serial number generation" (INCTSN_SRS) is failing with the following error as seen in the log file"
[30-SEP-19 14:11:09] INV_TRX_MGR: in getSerialNumber- itemId 123456789 SernumXYZ12345
[30-SEP-19 14:11:09] INV_TRX_MGR: **Ex in generateSerial:oracle.jdbc.driver.OracleSQLException: ORA-00900: invalid SQL statement
A trace shows the following (note that the entire parsed SQL statement is "C_ATTR ...") which indicates some sort of corruption:
Patch was applied.
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