Requisition Import Incorrectly Sets The Unit Price When Enabling Allow Override Price Within The BPA (Doc ID 1609269.1)

Last updated on MARCH 23, 2017

Applies to:

Oracle Fusion Self Service Procurement - Version 11.1.11.1.0 and later
Oracle Fusion Self Service Procurement Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When enabling the "Allow Override Price" checkbox within the BPA, the Requisition Line's price is shown incorrectly, due to the currency conversion happening unexpectedly during the Requisition Import process.

Steps To Reproduce:

1.Create a BPA with the "Allow Override Price" checkbox selected. In this case, the item price is set at 73.00 USD.

2.Create data within the POR_REQ_LINES_INTERFACE_ALL table as below. The SOURCE_HEADER_ID and SOURCE_LINE_ID should be set here as well:
  CURRENCY_UNIT_PRICE = 73.00
  CURRENCY_CODE = NULL

3.Run the Requisition Import process.

4.Check the Requisition Line Item Price within the UI. The Line Price will be incorrectly shown as 0.7410415186 USD.
   This is different from the data specified within the POR_REQ_LINES_INTERFACE_ALL table, due to the currency conversion that takes place.

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