My Oracle Support Banner

JBO-27122 Error Closed Connection When Trying to Add or Update Associations (Doc ID 2290250.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.


On :  12.1.3 version, Catalog items

Users are unable to create or view item cross references on the Associations tab in PIM.

For new items that do no already contain cross references the error occurs when the users clicks the "Select Organization" checkbox when attempting to add a new cross reference.
For items with existing cross references an error is received when the associations tab is selected.

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

The issue can be reproduced at will with the following steps:
1.  View Item Cross References

Bounce middle-tier




To view full details, 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 a vibrant support community of peers and Oracle experts.