My Oracle Support Banner

R12: 請求書を入力する際にFRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403が発生する (Doc ID 1618024.1)

Last updated on MARCH 12, 2021

適用範囲:

Oracle Payables - バージョン 12.0.1 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

特定の仕入先に対して請求書を作成しようとすると、FRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403 が発生します。

FND デバッグLog には、以下のエラーが表示されています:

IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : Given payee context: payee party id XXXXX, party site id XXXXX, supplier site id XXXX, org i
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromConte : Payee id XXXXX 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 XXXXX, party site id XXXXX, supplier site id , org id XX
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

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.