Getting JBO-27122: SQL error When Clicking Repair PO Update Icon After Patch 21812940 on 12c Database

(Doc ID 2112335.1)

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