Not Able To Create / Open Existing Offer ORACLE.JBO.SQL.StmtException: JBO-27122
(Doc ID 2810085.1)
Last updated on SEPTEMBER 27, 2021
Applies to:Oracle Trade Management - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Offers
When Users are clicking on existing Offers or trying to create new Offers in Trade Management, the below error is seen. Issue seen after adding a new Product Context flexfield that is associated to an Independent Valueset that was implemented. If table validate valueset is used, then no error.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. Statement: select flex_value FLEX_VALUE , flex_value FLEX_DISPLAY , description FLEX_DESCRIPTION from fnd_flex_values_vl where (fnd_flex_values_vl.flex_value_set_id = :1) and enabled_flag = 'Y' and nvl(fnd_date.canonical_to_date(:2), trunc(SysDate)) between nvl(trunc(start_date_active), nvl(fnd_date.canonical_to_date(:3), trunc(SysDate))) and nvl(trunc(end_date_active), nvl(fnd_date.canonical_to_date(:4), trunc(SysDate))) and (upper(flex_value ) like :L1 and (flex_value like :L2 or flex_value like :L3 or flex_value like :L4 or flex_value like :L5)) order by FLEX_DISPLAY
1. Navigate to Oracle Trade Management User responsibility
2. Select Trade Planning > Offers
3. Select an existing offer, receive error
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