Unable To Define Expense Account Rules Due To Exception JBO-27122 (Doc ID 1508927.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Cannot create 'Expense Account Rules' due to following exception captured in 'exception detail' page.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT ffv.FLEX_VALUE, ffv.DESCRIPTION, ffs.ID_FLEX_NUM, ffs.SEGMENT_NUM,
ffs.APPLICATION_COLUMN_NAME
FROM FND_FLEX_VALUES_VL ffv, FND_ID_FLEX_SEGMENTS_VL ffs
where ffv.FLEX_VALUE_SET_ID = ffs.FLEX_VALUE_SET_ID
  AND FFS.APPLICATION_ID = 101
  AND FFS.ID_FLEX_CODE = 'GL#') QRSLT WHERE (ID_FLEX_NUM = 101 AND UPPER(APPLICATION_COLUMN_NAME) LIKE 'SEGMENT2') ORDER BY flex_value
...

## Detail 0 ##
java.sql.SQLException: Invalid column index


Reproducible Steps
Responsibility: Purchasing, Vision Operation (USA)
Navigation: Setup > Financials > Accounting > Expense Account Rules >
On 'Create Expense Account Rule: Vision Operations' page
Enter value for field
- Account Rule Type
- Account Rule Value
- Segment Name
- Segment Value
APPLY
RESULT > Error Page "You have encountered and unexpected error. Please contact the System Administrator for assistance."

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms