Intercompany Invoicing Failing With Status_Code Duplicate_Price_List (Doc ID 387644.1)

Last updated on OCTOBER 26, 2016

Applies to:

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


***Checked for relevance on10-JUN-2014***


Symptoms

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.

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


EXPECTED BEHAVIOR
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.

STEPS
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

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