Webadi Dependent LOV Search
I have a dependent LOV field which is dependent on two fields. When I double click it opens the LOV screen and was able to list down the values. But if I search a value it is erroring out.
Any help will be appreciated.
Error in Webadi:
The following error has occurredException Name: oracle.apps.bne.exception.BneFatalException -
oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement.Log File Bookmark: 475797
Java LOV:
BEGIN
BNE_INTEGRATOR_UTILS.CREATE_JAVA_LOV (
P_APPLICATION_ID => 50002,
P_INTERFACE_CODE => 'XXD_MOU_XINTG_INTF1', --BNE_INTERFACE_COLS_B.INTERFACE_CODE
P_INTERFACE_COL_NAME => 'P_INVENTORY_ITEM', --BNE_INTERFACE_COLS_B.INTERFACE_COL_NAME