ORA-00904: WADIVXX WADIVXX FLEX_VALUE Exception When Retrieving Code Combination Values From LOV (Doc ID 950663.1)

Last updated on JULY 12, 2013

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

You are uploading Journal Spreadsheet. While adding account code combinations to spreadsheet, you click on LOV of any segment in all accounting segments window. This following error occurs. From BNE log file:

8/20/09 11:45 AM ERROR BneBaseSQL.executeBneQuery: Query:
.
SELECT WADIVXX.FLEX_VALUE, T.DESCRIPTION
FROM FND_FLEX_VALUES_TL T, FND_FLEX_VALUES WADIVXX
WHERE WADIVXX.FLEX_VALUE_SET_ID = ?
AND WADIVXX.ENABLED_FLAG = 'Y'
AND WADIVXX.FLEX_VALUE_ID = T.FLEX_VALUE_ID
AND T.LANGUAGE = ? AND WADIVXX.SUMMARY_FLAG = 'N'
AND SUBSTR(NVL(WADIVXX.COMPILED_VALUE_ATTRIBUTES, 'YYY'),3,1) = 'Y'
AND UPPER(WADIVXX.FLEX_VALUE) LIKE UPPER( ? )AND TO_DATE(?,'YYYY-MM-DD') >= NVL(WADIVXX.START_DATE_ACTIVE,TO_DATE(?,'YYYY-MM-DD'))
AND NVL(WADIVXX.END_DATE_ACTIVE,TO_DATE(?,'YYYY-MM-DD')) >= TO_DATE(?,'YYYY-MM-DD')
AND (NOT EXISTS (SELECT M.ERROR_MESSAGE FROM FND_FLEX_VALUE_RULE_USAGES U,
FND_FLEX_VALUE_RULES_VL M
WHERE U.FLEX_VALUE_RULE_ID = M.FLEX_VALUE_RULE_ID AND U.APPLICATION_ID = ? AND U.RESPONSIBILITY_ID = ? AND U.FLEX_VALUE_SET_ID = ? AND (EXISTS (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L WHERE (WADIVXX.WADIVXX.FLEX_VALUE BETWEEN
NVL(L.FLEX_VALUE_LOW, ?) AND NVL(L.FLEX_VALUE_HIGH, ?)) AND L.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND L.INCLUDE_EXCLUDE_INDICATOR = 'E') OR NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L WHERE (WADIVXX.WADIVXX.FLEX_VALUE BETWEEN NVL(L.FLEX_VALUE_LOW, ?) AND NVL(L.FLEX_VALUE_HIGH, ?)) AND L.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND L.INCLUDE_EXCLUDE_INDICATOR = 'I')))) ORDER BY 1
.
8/20/09 11:45 AM ERROR BneBaseSQL.executeBneQuery: Args : 1007704,
US, 422240%, 2009-07-30, 2009-07-30, 2009-07-30, 2009-07-30, 101, 50655,
1007704, 422240%, 422240%, 422240%, 422240%
8/20/09 11:45 AM ERROR BneBaseSQL.executeBneQuery: Stack trace:
java.sql.SQLException: ORA-00904: "WADIVXX"."WADIVXX"."FLEX_VALUE": invalid identifier

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