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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!