R12.2 Unable To Match POs/Awards To Invoices: APP-SQLAP-10000: ORA-01403: .. ap_invoices_v (Doc ID 1952798.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

On : 12.2.3 version - RBDMS 12c

Unable to match POs/Awards to Invoices with Match button,

but possible to create PO matched Invoice using Line Level matching


ERROR

APP-SQLAP-10000: ORA-01403: no data found occurred in
&CALLING_SEQUENCE
with parameters (&PARAMETERS)
while performing the following operation:
select out variables from ap_invoices_v


STEPS:

1. Payables > Enter Invoice (Match action= Purchase Order)

2. Click on Match button and the error comes on the screen

3. If user clicks OK , then the LOV for Purchase Orders is empty

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