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.
On : 12.2.6 version, Offers
Unable to Open Offers. Receive error oracle.jbo.SQLStmtException: JBO-27122: SQL error during statem
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
The issue can be reproduced at will with the following steps:
1. (R) OracleTrade Management User -->(N)Trade Planning-->Offers
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