R12: Error On RATE_TYPE When Importing Blanket In Foreign Currency Via 'Import Price Catalogs' (POXPDOI) with New User Rate Type (Doc ID 735354.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

How to resolve  errors about a recent rate type created in GL which occurs when importing new Blanket in foreign currency ?

Example :

In GL_DAILY_CONVERSION_TYPES table for this new type, can see:
CONVERSION_TYPE                            1082
USER_CONVERSION_TYPE                X_test

CASE#1
When PO_HEADERS_INTERFACE table is filled with the following currency values :
CURRENCY_CODE   EUR
RATE_TYPE               1022
RATE_DATE               02-SEP-2008
RATE                          1.5
Can see the below error in PO_INTERFACE_ERRORS after running POXPDOI : 
Error: Derivation Error: RATE_TYPE (VALUE= 1082) specified is invalid. for COLUMN_NAME = RATE_TYPE_CODE

CASE#2
When PO_HEADERS_INTERFACE table is filled with these following currency values :
CURRENCY_CODE  EUR
RATE_TYPE               X_test
RATE_DATE               02-SEP-2008
RATE                           1.5
Can see the two below errors :
Error: The rate value(VALUE=1013.8208) specified is invalid. for COLUMN_NAME =RATE
Error: Rate Type (VALUE =AVG M) specified is invalid. for COLUMN_NAME =RATE_TYPE

Solution

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