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 21, 2023

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

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

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

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)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!