My Oracle Support Banner

User Created A New Personalized Saved Search For The Offer Product Line Tab And Now Get Error JBO-27122: SQL error during statement preparation (Doc ID 2967230.1)

Last updated on AUGUST 10, 2023

Applies to:

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


User created a personalized saved search for the Trade Management Offer lines product tab that was marked as default.  Now when accessing the Offer update screen, User is receiving error JBO-27122.  Page is not available to be accessed and unable to view offer update screen.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT.

The issue can be reproduced at will with the following steps:
1. Trade Management > Trade Planning > Offers
2. Select Accrual Offer and go to products tab.
3. Create a saved search
4. Due to issue with personalized saved search and selected as default, Error on page.




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

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