My Oracle Support Banner

After HZ.N Upgrade, Unexpected and JBO-27122: SQL Error When Open Enrichment Screen in Trading Community Manager (Doc ID 729681.1)

Last updated on MAY 31, 2019

Applies to:

Oracle Trading Community - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

After HZ.N upgrade, Enrichment menu was not available under Trading Community Manager -Administration.

Checked the Menu 'TCA Administration Tab for the Home Page (to be used in forms)'
In this Prompt 'Enrichment' was missing against submenu 'Enrichment Setup (to be used by forms)'.  This submenu exists.

After adding the Prompt 'Enrichment' against this submenu 'Enrichment Setup' and tried to access Enrichment screen, it failed with an error.  The error is received when click on ‘Other Entities’ under Enrichment menu in Trading Community Manager:

"Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details."

Exception Details:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT hz_utility_v2pub.Get_LookupMeaning(
'AR_LOOKUPS', 'ENTITY_NAME', e.entity_name) GROUP_MEANING,
(select max(u1.LAST_UPDATE_DATE) from hz_user_overwrite_rules u1
where u1.rule_id = :1 and u1.entity_attr_id = e.entity_attr_id group by u1.entity_attr_id)
as LAST_UPDATE_DATE, 'N' as select_flag, e.entity_attr_id ENTITY_ATTR_ID,
HZ_MIXNM_UTILITY.getUserOverwrite(e.entity_attr_id, :2) user_overwrite,
e.ENTITY_NAME as attribute_group_name
FROM hz_entity_attributes e
WHERE e.entity_name NOT IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')) QRSLT ORDER BY
GROUP_MEANING
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at
oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:7
49)
.......
.......

'Enrichment' subtab is available under 'Administration' tab of Oracle Customer Online Super user responsibility before Hz.N upgrade.

Steps to Reproduce:

1) Add the Prompt 'Enrichment' for this submenu 'Enrichment Setup (to be used by forms)'
     -System Administrator, N: Application > Menu
     -Query for Menu: HZ_ADMINISTRATION_F_TAB
     -For Seq 4, enter 'Enrichment' for Prompt.
     -Save. Ensure the menu compiles successfully.

2) Try to access the page
    -Trading Community Manager, N: Trading Community > Administration > Enrichment > Thrid Party Data Rules > Other Entities
    -The following error is received: 
"Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details."

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.