My Oracle Support Banner

R12: APXINWKB Clicking All Distributions For Matched, Discarded, Rematched and then Validated Invoice Errors: ORA-01422 ORA-06512 AP_INVOICE_DISTRIBUTIONS_PKG (Doc ID 1138714.1)

Last updated on JULY 11, 2022

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
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.

Clicking on 'All Distributions' button after rematching to PO and validating throws the following error:

ORA-1422: exact fetch returns more than one requested number of rows ORA-6512: at "APPS.AP_INVOICE_DISTRIBUTIONS_PKG",line 6604

Due to this issue, users cannot see invoice distributions

-- Steps to Reproduce
Create new invoice, matched to PO, calculate the tax.
Requery the invoice, discard the matched item line, rematch to the PO again, update the tax code on the new matched item line, calculate the tax.
Validate the invoice
Requery Invoice, Click All Distributions.


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!

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