Unable To Create Catalog And Purchase Orders Using Open Interface Table - Error: The RATE_TYPE, RATE_DATE, and RATE columns in the PO_HEADERS_INTERFACE (Doc ID 2147959.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When trying to create Blanket Purchase Agreement and Purchase Orders using open interface table an error is occurred in po_interface_errors table.


ERROR


Error: The RATE_TYPE, RATE_DATE, and RATE columns in the PO_HEADERS_INTERFACE table must be null because the purchasing document's currency is the same as your base (functional) currency. Therefore, exchange rate information is not needed. (COLUMN_NAME=RATE_DATE) (VALUE=DATE)


STEPS TO REPRODUCE:


The issue can be reproduced at will with the following steps:
1. Populate interface tables with information
2. Run "Import Price Catalogs"  or "Import Standard Purchase Orders" concurrent 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