R12: AP: While Attempting to Match a Purchase Order Receipt to An Invoice, User Gets Error "APP-SQLAP-1000: ORA-06508: PL/SQL could not find program unit being call occured in Insert_Invoice_Distributions."
(Doc ID 2970185.1)
Last updated on AUGUST 25, 2023
Applies to:
Oracle Payables - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
While Attempting to match a purchase order (PO) receipt to a Payables invoice, the user gets the following popup error message:
APP-SOLAP-10000 ORA-06508 PUSQL could not find program unit being called occurred in Insert_Invoice_Distributions
<-AP_MATCHING_PKG.base_credit_po_match with parameters (Batch_Id = 499999293, Invoice_id = 4999994144,
Invoice Line Number = 1, Dist_num = 1, Allow_PA_Override =
Y, Transfer_Desc_Flag = Y)
while performing the following operation:
Call the AP_EXTENDED_MATCH to populate global attributes
Steps to Reproduce:
- Log into Oracle Applications using a Payables responsibility
- Open the Invoice Workbench
(N) Invoices > Entry > Invoices - Start a creating a new invoice. Enter all mandatory fields and select "Match Option" = Receipt and click on the [Match] button.
The "Find Receipts for Matching" pops up. - Enter Purchase Order Number and other fields to find the receipt to match.
The "Match to Receipts" window pops up with all records that match the search criteria. - In the "Match to Receipts" window, check the "Match" option for the receipt record found, and click on the [Match] button.
The Error message pops up.
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 |
| References |