My Oracle Support Banner

Intercompany Invoicing Failing With Status_Code Duplicate_Price_List (Doc ID 387644.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.


On 11.5.10 in Production:
Using Advanced Pricing to calculate Transfer Price of Internal Orders. However, some shipments
are not being successfully processed by the Create Intercompany AR Invoice program. An error is
being returned from the Pricing Engine call in some cases. Some internal orders do process fine
without any problem.

calling QP API...
returned from QP API...
QP API returnStatus=E
Return Warning from inarcil.
Warning: Cannot create invoice line

Expect all internal orders to be successfully processed and invoiced by the Create Intercompany AR
Invoice program, and to have been priced successfully from the designated transfer price list.

The issue can be reproduced with the following steps:
1) Profile options
    INV:Advanced Pricing for Intercompany Invoice = 1 (yes) Site
    INV:Intercompany Invoice for Internal Orders = 1 (yes) Site
    QP: Pricing Transaction Entity = INTCOM  (Application level) 
    QP: Source System Code = INV (Application level) 
2) Ensure the price list to be used for Intercompany invoicing was created under source system
    code 'INV' and Pricing Transaction Entity 'INTCOM'
3) Create a Internal Requisition
4) Create Internal Order for the Internal Req
5) Ship the Internal Order
6) Run Create Intercompany AR Invoices program


This issue occurs not only for Create Intercompany AR Invoices program but also Interface Trip Stop to derive Transfer Price for Intercompany Invoicing.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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