Physical Inventory Integrator “oracle.apps.bne.exception.BneInvalidException”

Initial run of Fixed Assets physical inventory integrator results in this error:

Your document is being created. Do not close this window until processing completes.

Fatal error: Please have your system administrator view the bne.log file. oracle.apps.bne.exception.BneInvalidException: The value $PARAM$.LOCATION_FLEXNUM for OA_FLEX_NUM in the flexfield definition is invalid or empty for the interface column identified by Integrator code: 140:FA_PHY_INV, Interface Code 140:FA_INV_INTERFACE and sequence number 10 Please contact your support representative.


To validate the issue, run SQL: 

select *
from FA_INVENTORY;

( zero row in YGC-UAT instance )

The results may show inventory rows, but check to see if any of them are currently active (not end dated).
There must be a minimum of one valid inventory available and not end dated for the integrator to be opened.

Solution

Under the Fixed Asset Manager responsibility navigate to the Physical Inventory form and enter a new name for a new physical inventory, with no end date. Once this is saved, attempt to use the integrator via WebADI again.

DocId=1132913.1

Advertisements

About this entry