Scrolling Down In "Search and Select: Add Balancing Segment Value" Fails With Error: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FlexValues.FLEX_VALUE (Doc ID 2961281.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

After opening the “Search and Select: Add Balancing Segment Value” window from "Accounting Setup Manager", if the user does not specify a particular value in the "Search By" section and scrolls down, an error message is displayed in the application.

ERROR

You have encountered an unexpected error. Please contact your System Administrator for assistance.

Exception Details :
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FlexValues.FLEX_VALUE,
  FlexValues.DESCRIPTION
FND_FLEX_VALUES_VL FlexValues
WHERE FlexValues.FLEX_VALUE_SET_ID = :1
AND FlexValues.SUMMARY_FLAG = 'N'
AND NOT EXISTS (SELECT 'X'

[..]

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at
oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1937)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at ...

[..]

STEPS

1. Go to “General Ledger Responsibility -> Financials -> Accounting Setup Manager -> Accounting Setups” ;

2. In the “Accounting Setups” webpage, in the “Search by = Ledger” section, enter the name of your ledger, press “Go” and then press on “Update Accounting Options” button;

3. In the “Accounting Options” webpage, go to your Primary Ledger section and then move to “Balancing Segment Value Assignments” and press on “Update”;

4. In the “Update Ledger Balancing Segment Value Assignments” webpage, press on “Add Balancing Segment Values”;

5. In the new window opened, called “Search and Select: Add Balancing Segment Value”, press on “Go” button – without entering any values in the "Search By" section;

6. After pressing “Go”, scroll down with the mouse through the list of values and notice the error message.

Changes

 None

Cause

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