Pay On Receipt Autoinvoice - Multiple Invoices For One Receipt Rather Then Single Invoice

(Doc ID 1920094.1)

Last updated on AUGUST 21, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR  
---------------

Invoice Summary Level is set to 'RECEIPT'.
Despite this setting, the Pay On Receipt Autoinvoice program (POXPOIV) creates multiple invoices
against receipt lines that have the same receipt number and transaction date.

EXPECTED BEHAVIOR
----------------
When the Invoice Summary Level is set to 'RECEIPT', the Pay On Receipt Autoinvoice program
should create a single invoice against receipt lines with the same receipt number and transaction date.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
. Enter receipt number 327 with 2 lines for PO number 12345 of Supplier SA_VENDOR
. Run POXPOIV
. Payables Open Interface shows
for Supplier 2 invoices have been created for same receipt on same Accounting Date

Note: The issue may also occur with Invoice Summary Level set to "Packing Slip" or "Pay Site"


More Information
--------------
. Output of diagnostic sql from <Note 731686.1> shows 2 records with
PO_NUMBER 12345
PO_PAY_CODE RECEIPT
VENDOR_NAME SA_VENDOR
VENDOR_SITE SA1
VENDOR_PAY_CODE RECEIPT
INVOICE_SUMMARY_LEVEL RECEIPT
VENDOR_SITE_ID 4535
VENDOR_ID 5559
ORG_ID 1981
PAY_ON_CODE RECEIPT
PAY_ON_RECEIPT_SUMMARY_CODE RECEIPT
RECEIPT_NUM 327
RCV_TXN_ID 5579  and 5581
TXN_TYPE RECEIVE
INVOICE_STATUS INVOICED

. Rcv11i output (<Note 402245.1>) shows

. RCV_TRANSACTIONS
2 receive transactions
TRANSACTION_ID 5579 and 5581
TRANSACTION_TYPE RECEIVE
TRANSACTION_DATE 30/10/2015 11:37
QUANTITY 1
SHIPMENT_HEADER_ID 9007
PO_HEADER_ID 12080
VENDOR_ID 5559
VENDOR_SITE_ID 4535
INVOICE_STATUS_CODE INVOICED
QUANTITY_BILLED 1

. ap_invoices_all
2 invoices
INVOICE_ID 78049 and 78055
VENDOR_ID 5559
INVOICE_NUM ERS-327-510 and ERS-327-516
VENDOR_SITE_ID 4535
INVOICE_DATE 21/10/2015 00:00  
SOURCE ERS

. ap_invoice_lines_interface
2 records
INVOICE_ID  LINE_TYPE_LOOKUP_CODE  AMOUNT    PO_HEADER_ID QUANTITY_INVOICED RECEIPT_NUMBER RCV_TRANSACTION_ID
53594       ITEM                   82542.18  12080        1                 327            5581
53600       ITEM                    8527.97   12080        1                 327            5579

10: ap_invoices_interface
2 records
INVOICE_ID 53594 and  53600
INVOICE_NUM ERS-327-510 and ERS-327-516
INVOICE_DATE 30/10/2015 11:37
DESCRIPTION Receipt Invoice automatically created on 30-OCT-15
SOURCE ERS


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