R12: AP: When Trying To Open Invoice The following Error Ocurrs Frm-40735 Post-query Trigger Raised Unhandled Exception Ora-01403

(Doc ID 2409619.1)

Last updated on JUNE 11, 2018

Applies to:

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

Symptoms

When querying a speciflic invoice the following error occurs:

 

FRM-40735 POST-QUERY trigger raised unhandled exception ORA-01403


THe FND log shows additional errors:

IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : Given payee context: payee party id 1978235, party site id 1948593, supplier site id , org i
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:Fatal: Exception when attempting to perform exact match for given payee context.6
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:SQL code: -14226
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:SQL err msg: ORA-01422: exact fetch returns more than requested number of rows6
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext: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

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