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.

Symptoms

On :  12.1.3 version, Catalog items

ACTUAL BEHAVIOR  
---------------
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.

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

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

Workaround
-----------------------
Bounce middle-tier

Changes

 None

Cause

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