My Oracle Support Banner

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 AUGUST 04, 2020

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

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
Symptoms
Cause
Solution
References


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