My Oracle Support Banner

R12: Generic Data Fix (GDF): Duplicate Payee in IBY_EXTERNAL_PAYEES_ALL (Doc ID 1315812.1)

Last updated on JUNE 17, 2024

Applies to:

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

Symptoms

Unable to create invoice or payment for affected suppliers where duplicate payees exist

Multiple errors will be displayed on creating or querying an invoice, like the following:

FRM-40735 POST-QUERY trigger raised unhandled exception ORA-01403
FRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403 

FND Log shows the following additional errors:

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

Such duplicate records cause the below error in Payables Open Interface Import program and the invoices are not imported:

IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:Fatal: Exception when attempting to perform exact match for given payee context.
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:SQL code: -1422
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:SQL err msg: ORA-01422: exact fetch returns more than requested number of rows 

When there are duplicate payee records, the payment process fails with the following error:

APP-FND-01934: ORA-01422: exact fetch returns more than requested number of rows in Package IBY_DISBURSEMENT_COMP_PUB Procedure Get_Default_Payment_Attributes

 

Steps to reproduce:

  1. Log into Oracle applications using a Payables responsibility.
  2. Open the Invoice Workbench
    (N) Invoices > Entry > Invoice or (N) Invoices > inquiry > Invoice
  3. Enter Supplier name, it will show above errors

 

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
Symptoms
Cause
Solution
 DATA-FIX
 CODE-FIX
References

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