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:

Symptoms

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.

Error
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.

Changes

Cause

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