R12: FRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403 While Entering An Invoice For Certain Suppliers (Doc ID 1470685.1)

Last updated on JANUARY 17, 2017

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

Unable to enter invoice for certain suppliers due to FRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403 

Running an FND Log yields the following additional errors:

IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : Given payee context: payee party id 41624, party site id 25167, supplier site id 9100, org i
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : Payee id 11444 exactly matched given payee context.
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : EXIT
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : ENTER
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : Given payee context: payee party id 41624, party site id 25167, supplier site id , org id 83
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : Fatal: Exception when attempting to perform exact match for given payee context.
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : SQL code: -1422
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : SQL err msg: ORA-01422: exact fetch returns more than requested number of rows
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : EXIT
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : ERROR: Exception occured during call to API
IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attribute : SQLerr is :ORA-01422: exact fetch returns more than requested number of rows

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