INCIAR Create Intercompany AR Invoice is Failing in Multi Currency Conversion for Conversion Type 'Corporate' (Doc ID 2175682.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

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

Symptoms

When attempting to run create Intercompany AR Invoices INCIAR, the program ends with the following warning:

ERROR
-----------------------
calling QP API...
returned from QP API...
QP API returnStatus=E

Return Warning from inarcil.

Warning: Cannot create invoice line

 

dbg file created indicates:

 

multi-currency TRUE - calling QP_MULTI_CURRENCY_PVT.CURRENCY_CONVERSION_API
Currency_Conversion_API - Enter
Currency_Conversion_API - p_user_conversion_rate
Currency_Conversion_API - p_user_conversion_type
Currency_Conversion_API - p_function_currency
Currency_Conversion_API - p_rounding_flagY
Currency_Conversion_API - record count = 1
Currency_Conversion_API - conversion_type = Corporate
Currency_Conversion_API - operand_value = 129.93
Currency_Conversion_API - l_conversion_rate =   -----------------------------<<< null , indicating conversion rate is not available
Currency_Conversion_API - result_operand_value =
Currency_Conversion_API - markup_value =
Currency_Conversion_API - markup_formula_id =
Currency_Conversion_API - markup_operator =
Currency_Conversion_API - p_rounding_flag = Y
BEGIN round_price
p_operand =
p_rounding_factor = -2
p_use_multi_currency = Y
p_price_list_id =
p_currency_code =
p_pricing_effective_date =
p_operand_type = S
LEAVING OE_MSG_PUB.ADD
round_price - EXPECTED exception
Currency_Conversion_API - round_price fails

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Responsibility: Inventory Super User
2. Navigate: Reports > Intercompany Invoicing >
3. Run INCIAR > Parameters:
    Name = Create Intercompany AR Invoices
    Shipping/Procuring Operating Unit = enter OU
    Line Description = <>
    Submit > Receive warning in log file



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