My Oracle Support Banner

Unable To Open Offers. Receive Error Oracle.jbo.SQLStmtException: JBO-27122 (Doc ID 2813793.1)

Last updated on OCTOBER 14, 2021

Applies to:

Oracle Trade Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Offers

Unable to Open Offers. Receive error oracle.jbo.SQLStmtException: JBO-27122: SQL error during statem


ERROR
-----------------------
Getting Below error while trying to open the offer details
  oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. 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





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (R) OracleTrade Management User -->(N)Trade Planning-->Offers



Changes

 

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
Changes
Cause
Solution
References


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