11i: APXINWKB - Creating PO Default Invoice Errors with ORA-01422 Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 946578.1)

Last updated on FEBRUARY 24, 2011

Applies to:

Oracle Payables - Version: 11.5.10.2 to 11.5.10.2 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
APXINWKB - Invoice Workbench

Symptoms

Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

-- Problem Description
Unable to create PO Default type invoice due to error:

ORA-1422 exact fetch returns more than requested number of rows

This occurs after tabbing out of the supplier site field

-- Steps to Reproduce
Payables > Invoices > Entry
Invoice Type PO Default
Enter PO Num and tab
Error appears

-- Business Impact
Unable to create PO Default invoices

Changes

Run the following to confirm the issue:

execute dbms_application_info.set_client_info(‘<ORG_ID>’);

select vendor_site_id , count(*)
from PO_VENDOR_SITES_PAY_AP_V
group by vendor_site_id having count(*) >1;

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