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 JANUARY 27, 2023
Applies to:
Oracle Purchasing - Version 12.1.3 and laterInformation 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)
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 |