POXPOIV - Pay On Receipt Autoinvoice Does Not Create Invoices: Invoice_status_code = Pending (Doc ID 1325333.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
Executable:POXPOIV - Pay On Receipt AutoInvoice

Symptoms

Purchase orders are created for a supplier site for which Pay On field is set to Receipt. The invoice should be created automatically at the time of receipt. However, when a receipt is created against the purchase order and POXPOIV - Pay On Receipt AutoInvoice is being run, no invoices are created. It is observed that for these receipts invoice_status_code is set to Pending. This can be determined by executing the following query:

select poh.segment1 "PO_NUMBER",
poh.po_header_id "PO_HDR_ID",
poh.pay_on_code "PO_PAY_CODE",
pv.vendor_name "VENDOR_NAME",
pvs.address_line1 "VENDOR_SITE",
pvs.pay_on_code "VENDOR_PAY_CODE",
pvs.pay_on_receipt_summary_code "INVOICE_SUMMARY_LEVEL",
rsh.receipt_num "RECEIPT_NUM",
rcv.transaction_id "RCV_TXN_ID",
rcv.transaction_type "TXN_TYPE",
rcv.invoice_status_code "INVOICE_STATUS"
from po_headers_all poh,
po_vendors pv,
po_vendor_sites_all pvs,
rcv_transactions rcv,
rcv_shipment_headers rsh
where poh.po_header_id = rcv.po_header_id
and poh.vendor_id = pv.vendor_id
and poh.vendor_site_id = pvs.vendor_site_id
and rsh.shipment_header_id = rcv.shipment_header_id
and rcv.transaction_type ='RECEIVE'
and poh.segment1='&PO_NUM';


The receipts are available to be processed by POXPOIV - Pay On Receipt AutoInvoice, but the records are not picked up.

The issue can be reproduced at will with the following steps:
1. Navigate to Purchase orders > Purchase orders and create a purchase order against a supplier site for which Pay On field is set to 'Receipt'.
2. Navigate to Receiving > Receipts and create a receipt against the purchase order.
3. Launch Pay On Receipt AutoInvoice.
4. No invoice is created and the invoice status remains pending.

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