Getting JBO-27122: SQL error When Clicking Repair PO Update Icon After Patch 21812940 on 12c Database
Last updated on MARCH 08, 2017
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.
the following error occurs.
Error display starts with...
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
This only happens with DB 12c. It is working fine if the BD 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms