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 APRIL 26, 2023

Applies to:

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

Changes

Cause

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