Resource Creation Gives Error: Ora-00918, Jbo-27122 (Doc ID 1286797.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Learning Management - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked For Relevance on 10-FEB-2013***

Symptoms



On : 12.1.1 version, Resources Definition & Booking

When trying to create a new venue, the following error occurs:

ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */
OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID
, FLEX_T0_0.MEANING FLEX_DISPLAY0
, FLEX_T1_0.MEANING FLEX_DISPLAY1
, FLEX_T2_0.MEANING FLEX_DISPLAY2
, fnd_flex_server.get_concatenated_value(
:SEGMENT_DELIMITER
, :SEGMENT_COUNT
, FLEX_T0_0.MEANING
, FLEX_T1_0.MEANING
, FLEX_T2_0.MEANING
) FLEX_CONCATENATED_DISPLAY
FROM OTA_RESOURCE_DEFINITIONS
, FND_LOOKUP_VALUES FLEX_T0_0
, FND_LOOKUP_VALUES FLEX_T1_0
, HR_LOOKUPS FLEX_T2_0
WHERE (OTA_RESOURCE_DEFINITIONS.enabled_flag = 'Y'
and nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))
between nvl(trunc(OTA_RESOURCE_DEFINITIONS.start_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate)))
and nvl(trunc(OTA_RESOURCE_DEFINITIONS.end_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate)))
and OTA_RESOURCE_DEFINITIONS.ID_FLEX_NUM = :STRUCTURE
and 1 = 1
and OTA_RESOURCE_DEFINITIONS.SEGMENT1 = FLEX_T0_0.LOOKUP_CODE
and ( LOOKUP_TYPE = 'BAA_OLM_RSC_RFR_CATS' AND ENABLED_FLAG = 'Y')
and 1 = 1
and OTA_RESOURCE_DEFINITIONS.SEGMENT2 = FLEX_T1_0.LOOKUP_CODE(+)
and ( LOOKUP_TYPE = 'BAA_OLM_RSC_RFR_TYPES' AND ENABLED_FLAG = 'Y')
and 1 = 1
and OTA_RESOURCE_DEFINITIONS.SEGMENT3 = FLEX_T2_0.LOOKUP_CODE(+)
and ( LOOKUP_TYPE = 'YES_NO')
and FLEX_T0_0.MEANING like :FLEX_QUERY_VALUE0
and FLEX_T1_0.MEANING like :FLEX_QUERY_VALUE1
and FLEX_T2_0.MEANING like :FLEX_QUERY_VALUE2) ORDER BY FLEX_DISPLAY0
, FLEX_DISPLAY1
, FLEX_DISPLAY2

##DETAIL##
## Detail 0 ## java.sql.SQLException: ORA-00918: column ambiguously defined at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code)) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at ...

Error produces with custom and seeded value sets for VENUE.

NO HIDDEN COLUMNS.

There should not be a limitation on how many segments on VENUE
No consistency on how many segments are used.
Create combination is failing---------
VENUE originally had 8 segments



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Under responsibility Learning Administrator > Learning Administration > Resources:

1. Click the Create Refresh button.
2. Select Resource Type of Venue, then select the Search button next to Resource Name
3. Click the Create button.  This is when the error appears.


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