My Oracle Support Banner

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 later
Information in this document applies to any platform.


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:

  1. Log into Oracle Applications using a Payables responsibility
  2. Open the Invoice Workbench
    (N) Invoices > Entry > Invoices
  3. 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.
  4. 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.

  5. 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.



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

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