Invoice Summary Level "Receipt" / POXPOIV APXIIMPT is Not Creating Invoice Number With Receipt Number But With Sysdate (Doc ID 1943330.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Symptoms

At Supplier Site the Invoice summary level is Receipt but the Pay on receipt program is not Generating the Invoice number with the Receipt Number.

It is expected for Pay on receipt program to Generate the Invoice number with the Receipt Number instead of generating it with System Date / Expect Invoice Numbering to be correct.

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

. Profile PO: ERS Invoice Number Prefix is set to ERS

. Payables / Suppliers / Purchasing
Supplier site has
Pay On = Receipt
Invoice Summary Level = Receipt

. Purchase Orders Form
Purchase order has in Terms / Conditions tab
Pay On = Receipt

. Receipt Number 500018 is entered

. Run Pay on receipt program  POXPOIV for Receipt 500018 on 05/11/2014

. Run the the APXIIMPT module: Payables Open Interface Import in Oracle Payables responsibility

. Invoice is generated but it is Generating System Date as invoice Number.
in ap_invoices_all
INVOICE_ID 34069
INVOICE_NUM 05/11/2014

INVOICE_NUM should include Receipt number 500018

Per <Note 731686.1> How To Diagnose Pay On Receipt Autoinvoice
The invoice number is of the following format:  <ERS>-<X>-<Seq#> where:
- ERS is the default prefix for Pay On Receipt invoices or any prefix you specify through the profile option PO: ERS Invoice Number Prefix.
- Seq# is a unique system generated number.
- X depends on the summary level:
if Invoice Summary Level is 'Receipt' then X = Receipt Number

More Information
-------
A) Output of diagnostic script from Note 731686.1 How To Diagnose Pay On Receipt Autoinvoice shows

 
10: ap_invoices_interface
3 lines including  
INVOICE_ID 8017
INVOICE_NUM
INVOICE_TYPE_LOOKUP_CODE STANDARD
INVOICE_DATE 05/11/2014 15:50
VENDOR_ID 1
VENDOR_SITE_ID 1
INVOICE_AMOUNT 150
DESCRIPTION Receipt Invoice automatically created on 05-NOV-14
CREATION_DATE 05/11/2014 15:51
STATUS PROCESSED
SOURCE ERS

11: rcv_shipment_headers
SHIPMENT_HEADER_ID 27067
RECEIPT_SOURCE_CODE VENDOR
RECEIPT_NUM 5000000018
SHIP_TO_ORG_ID 162

13: rcv_transactions
some transactions including
TRANSACTION_ID 32450
TRANSACTION_TYPE RECEIVE
TRANSACTION_DATE 05/11/2014 15:50
QUANTITY 10
UNIT_OF_MEASURE EACH
SHIPMENT_HEADER_ID 27067
SOURCE_DOCUMENT_CODE PO
DESTINATION_TYPE_CODE RECEIVING
PO_HEADER_ID 37043
PO_LINE_ID 36058
PO_LINE_LOCATION_ID 33063
PO_UNIT_PRICE 15
INVOICE_STATUS_CODE INVOICED
QUANTITY_BILLED 10
AMOUNT_BILLED 150

--It is expected that in  ap_invoices_all  INVOICE_NUM includes Receipt number 500018 instead of INVOICE_NUM 05/11/2014

C) Patch 19409660:R12.PO.B that provides POXIVRPB.pls version 120.26.12010000.23 from <Note 1920094.1> has been applied but issue is not resolved

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.