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.
When trying to create Blanket Purchase Agreement and Purchase Orders using open interface table an error is occurred in po_interface_errors table.
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.
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