WebADI Item Number ForTrade Management Creates Error 'oracle.apps.bne.exception.BneSQLException - Cannot execute SQL Statement' When Clicking LOV In Excel (Doc ID 1481289.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Trade Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance on 11-Apr-2014.

Symptoms

When cliking the Item Number field in WebADI for Trade Management the following error is displayed:
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 INVENTORY_ITEM_ID,CONCATENATED_SEGMENTS,DESCRIPTION FROM MTL_SYSTEM_ITEMS_VL WHERE ORGANIZATION_ID = ORDER BY 2
Bind values used in SQL statement

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