Getting JBO-27122: SQL error When Clicking Repair PO Update Icon After Patch 21812940 on 12c Database
(Doc ID 2112335.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Spares Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Spares Logistics and Database 12c
When attempting to use the Repair PO Summary screen’s Update icon to enter scrap/negative-adjustment transactions. The screen immediately errors after clicking on “Update” pencil icon.
Error display starts with...
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
This only happens with Database version 12c. It is working fine if the Database version is 11.
The issue can be reproduced at will with the following steps:
1. Log in Spares Management
2. Go to Repair PO summary, click Update icon to enter scrap/negative-adjustment transactions
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