POXPOIV Pay On Receipt Autoinvoice Generated 1 ERS Invoice For Many Different Purchase Orders (Doc ID 2056105.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Pay on Receipt Autoinvoice request POXPOIV process creates one invoice for many different Purchase Orders.

Steps:

The issue can be reproduced at will with the following steps:

1) Enter PO / Enter Receipt for supplier with Pay on Receipt setup.

2) Run POXPOIV Pay on Receipt Process.

3) Run Payables Open Interface program

4) Payables Open Interface Import Report shows invoices have been generated.
  
5) Navigate to Invoice Workbench form
See INVOICE: ERS-408-4775-1

5.1) General tab
See one invoice with
Trading Partner = SUPPLIER A S.L
Supplier Num = 4775
Supplier Site = SITE1
Invoice Num = ERS-408-4775-1
Invoice Date = 30-JUN-2015

5.2) Lines tab
Multiples Purchase Order / Lines listed / Multiple Receipt Numbers
PO Number    Receipt Number       Quantity Invoiced
4080123       Receipt 22985          2
4080124       Receipt 22986          6 

It is expected that ONE PO = One INVOICE

6) Receiving Data Collection output shows for instance for PO 4080123

PO_HEADERS_ALL
Po_Header_Id 1918107
Segment1 4080123
Vendor_Id 5718
Vendor_Site_Id 190563
Org_Id 551
Pay_On_Code RECEIPT

PO_LINE_LOCATIONS_ALL
Line_Location_Id 5338580
Po_Header_Id 1918107
Quantity 2
Quantity_Received 2
Quantity_Billed 2
Ship_To_Organization_Id 656
Match_Option R

AP_INVOICE_LINES_ALL
Invoice_Id 3092577
Line_Number 1
Line_Type_Lookup_Code ITEM
Item_Description JUEGOS
Match_Type ITEM_TO_RECEIPT
Amount 52.7
Quantity_Invoiced 2
Unit_Price 26.35
Po_Header_Id 1918107
Po_Line_Location_Id 5338580
Rcv_Transaction_Id 8181705

AP_INVOICES_ALL
Invoice_Id 3092577
Vendor_Id 5718
Invoice_Num ERS-408-4775-1
Invoice_Amount 35735.69
Vendor_Site_Id 190563
Invoice_Date 06-30-2015 00:00
Source ERS
Description Receipt Invoice automatically created on 30-JUN-15
Org_Id 551

AP_INVOICE_LINES_INTERFACE
Invoice_Id 2275402
Invoice_Line_Id 14644246
Line_Number 1
Line_Type_Lookup_Code ITEM
Amount 52.7
Po_Header_Id 1918107
Po_Line_Location_Id 5338580
Quantity_Invoiced 2
Unit_Price 26.35
Receipt_Number 22985
Rcv_Transaction_Id 8181705

AP_INVOICES_INTERFACE
Invoice_Id 2275402
Invoice_Num ERS-408-4775-1
Invoice_Type_Lookup_Code STANDARD
Vendor_Id 5718
Vendor_Site_Id 190564
Invoice_Amount 29533.63
Invoice_Currency_Code EUR
Description Receipt Invoice automatically created on 30-JUN-15
Creation_Date 07-15-2015 09:55
Status PROCESSED
Source ERS
Org_Id 551

RCV_SHIPMENT_HEADERS
Shipment_Header_Id 1241721
Receipt_Source_Code VENDOR
Vendor_Id 5718
Vendor_Site_Id 190563
Receipt_Num 22985
Ship_To_Org_Id 656

RCV_TRANSACTIONS
Receive transaction has
Transaction_Id 8181705
Transaction_Type RECEIVE
Transaction_Date 06-30-2015 16:25
Quantity 2
Shipment_Header_Id 1241721
Source_Document_Code PO
Po_Header_Id 1918107
Po_Line_Location_Id 5338580
Po_Unit_Price 26.35
Vendor_Id 5718
Vendor_Site_Id 190563
Organization_Id 656
Invoice_Status_Code INVOICED
Quantity_Billed 2
Amount_Billed 52.7

Cause

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 hundreds of Community platforms