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
Last updated on OCTOBER 05, 2017
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.
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