My Oracle Support Banner

Bnesqlexception When Attempting To Select An Account Value (Doc ID 411941.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Web Applications Desktop Integrator - Version 11.5.10.0 to 11.5.10.6 [Release 11.5]
Information in this document applies to any platform.
11i.BNE.D with <> (WebADI 8.4.1.27)

Symptoms

When using a WebADI excel spreadsheet in German, entering data in the Accounting Flexfeld and clicking on the Value Set a support error occurs:
The following error has occurred
Exception Name: oracle.apps.bne.exception.BneSQLException - Cannot execute SQL Statement.
Cause: A low level API call failed.
Action: Please note this error to your support representative.
Statement: SELECT <custom>.FLEX_VALUE, T.DESCRIPTION FROM FND_FLEX_VALUES_TL T,
FND_FLEX_VALUES <custom> WHERE <custom>.FLEX_VALUE_SET_ID = ? AND
<custom>.ENABLED_FLAG = 'Y' AND <custom>.FLEX_VALUE_ID = T.FLEX_VALUE_ID AND
T.LANGUAGE = ? AND <custom>.SUMMARY_FLAG = 'N' AND SUBSTR(NVL
(<custom>.COMPILED_VALUE_ATTRIBUTES, 'YYY'),3,1) = 'Y' AND TO_DATE(?,'YYYY-MM-DD') >=
NVL(<custom>.START_DATE_ACTIVE,TO_DATE(?,'YYYY-MM-DD')) AND NVL
(<custom>.END_DATE_ACTIVE,TO_DATE(?,'YYYY-MM-DD')) >= TO_DATE(?,'YYYY-MM-DD')
ORDER BY 1


The error is only in the Account-values. All other Values can be selected.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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