POXPOIV Pay On Receipt Autoinvoice Does Not Create Invoices [ID 282001.1]

纵横四海

Applies to:
Oracle Inventory Management - Version: 11.5.1 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.
Executable:POXPOIV - Pay On Receipt AutoInvoice
***Checked for relevance on 02-May-2010***
Symptoms
The Pay On Receipt AutoInvoice program does not generate invoices.

Changes
Supplier Site information was updated after Purchase Order creation.

Cause
The Pay on Receipt set up at Supplier Site should be done prior to creating a PO. If the Pay on Receipt at Supplier is NULL then pay_on_code for the Supplier would be NULL and while creating receipts the records have a invoice_status_code of NULL in RCV_TRANSACTIONS.

The cursor that picks the eligible records has conditions:


SELECT ..................
WHERE RCV_TRANSACTIONS.INVOICE_STATUS_CODE IN ('PENDING','REJECTED') AND
PO_VENDOR_SITES.PAY_ON_CODE IN ('RECEIPT', 'RECEIPT_AND_USE') AND
PO_HEADERS.PAY_ON_CODE IN ('RECEIPT', 'RECEIPT_AND_USE')

Once a PO is created against a Supplier whose Pay on Receipt is not RECEIPT or RECEIPT_AND_USE, pay_on_code is populated as NULL. When the same Supplier Pay on Receipt setup is changed at a later time the pay_on_code on the PO is NOT UPDATED. Hence the above join condition would fail.

The setup would be effective only for future PO's against the Supplier.

The PO lines of the old Purchase Order will not be picked up for invoicing by the Pay on Receipt program.

Setup for the supplier site has to be done prior to creating a PO for these records to be available for invoicing through the Pay on Receipt concurrent program.
The product does not support this requirement. A data fix will not be provided for this issue because there is no data corruption and for any legacy POs, customer must create invoices manually.
This is explained in the following bug:

Bug 3656595 PAY ON RECEIPT AUTOINVOICE NOT GENERATED AFTER SETTING AT SUPPLIER SITE LEVEL  

Solution
Per  Oracle Payables User's Guide:
"Although you only need to define these options and defaults once, you can update them at any time. If you change an option and it is used as a default value elsewhere in the system, it will only be used as a default for subsequent transactions. For example, if you change the Payment Terms from Immediate to Net 30, Net 30 will be used as a default for any new suppliers you enter, but the change will not affect the Payment Terms of existing suppliers."

You have 2 options:

1.  Create a new Purchase Order for the supplier and create receipts for the PO. The Pay on Receipt program would then create an invoice.

2. Manually invoice against the Purchase Orders



该贴已经同步到 纵横四海的微博

houwanglong

路过……读了……