R12: AP:Invoice MGD-300 Receipt Data Missing For ERS Source Invoices
(Doc ID 3071610.1)
Last updated on FEBRUARY 14, 2025
Applies to:
Oracle Payables - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
Invoices created from the ERS (Evaluated Receipt Settlement), or Self-Billing Oracle Purchasing program are missing the Receipt number and Receipt line values that are expected to be seen in the invoice.
Note: For more information on ERS, please review: POXPOIV - How to Set Up and Troubleshoot Pay on Receipts Auto Invoice (Doc ID 382762.1)
What is Pay On Receipt?
POXPOIV, Pay on Receipt, also known as ERS (Evaluated Receipt Settlement), or Self-Billing, is an Oracle Purchasing concurrent program, which automatically creates invoices in Payables and matches them with Purchase Orders for the received amount.
How does Pay on Receipt Work?
When Pay on Receipt Autoinvoice (POXPOIV) program is ran, it in turn launches Payables Interface Import (APXIIMPT) program.
POXPOIV updates invoice_status_code of rcv_transactions to INVOICED, then populates records in ap_invoices_interface and ap_invoice_lines_interface. Then the interface data is committed and APXIIMPT is invoked to create the invoices.
If APXIIMPT program errors out for some reason during the validation of AP interface data then the records stay in interface tables with REJECTED status and the associated error information will be stored in AP_INTERAFACE_REJECTIONS table.
POXPOIV sets invoice_status_code of rcv_transactions, for transaction_type RECEIVE, to INVOICED for both successfully imported invoices and for invoices rejected by APXIIMPT.
If Pay on Receipt AutoInvoice is ran again later then it will pick only those records which have invoice_status_code as 'PENDING. It will not pick/process the records which have invoice_status_code = INVOICED.
For ERS source Payable invoices, when viewing the Receipt Number and Receipt Line information they have null (blank) values.
STEPS
-------
To view these fields the following navigation can be used:
1) Using a Payables Responsibility.
2) Navigate to the Invoice Workbench:
Invoices > Entry > Invoices.
3) Query an ERS invoice in question.
4) On the Workbench select the Lines tab and note that the Receipt Number and Receipt Line columns are null (blank).
When running the Payables Invoice Analyzer (EBS Master GDF Diagnostic Analyzer (Note 1360390.1)) for this invoice, the following is found:
MGD-300
Error: Receipt number does not show up on correction lines of invoices correcting price, quantity, or amount.
Impact Area(s): PO Matching
Findings and Recommendations:
Bug Number: 16234660
Note: Doc ID 2259809.1
Script Name: ap_rcpt_num_corr_inv_sel.sql
Root Cause patch and data fix provided from: Doc ID 2259809.1: R12: AP: For a Receipt Matched Invoice, the Receipt Number is Missing at Invoice Line Level on Invoice Workbench.
This datafix from this note is run and will correct the data.
The root cause code fix per this note is also applied, but does not resolve the root cause as newly generated invoices continue to have this issue.
As from note 2259809.1, the root cause patch provides fixed file versions, these are verified to be in place:
Patch 13845471:R12.AP.C Note: This is an Internal patch, please log a Service Request to request it from support.
It provides these files/versions:
12.2.x users patch/115/sql apamtrcb.pls-120.59.12020000.4
12.2.x users patch/115/sql aprcvmtb.pls-120.80.12020000.5
You can use commands like the following to verify that the corrected file versions are in place after patching:
Changes
No changes noted.
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 |
| Changes |
| Cause |
| Solution |
| References |