Invoice Summary Level "Receipt" / POXPOIV APXIIMPT is Not Creating Invoice Number With Receipt Number But With Sysdate
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.
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.
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.
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
A) Output of diagnostic script from Note 731686.1 How To Diagnose Pay On Receipt Autoinvoice shows
3 lines including
INVOICE_DATE 05/11/2014 15:50
DESCRIPTION Receipt Invoice automatically created on 05-NOV-14
CREATION_DATE 05/11/2014 15:51
some transactions including
TRANSACTION_DATE 05/11/2014 15:50
--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
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