Error Message "Amount Is Mandatory for Lines with Value Basis = 'Fixed Price'" Occurs During Requisition Import When Using a Foreign Currency and Line Type is Fixed Price Value Basis

(Doc ID 2138526.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

WebADI (Web Application Desktop Integrator) is being used to populate the requisition interface table with values and launch the Requisition Import Program.

This issue could also occur if simply populating the Requisition interface by SQL statement or any other method.

When importing a foreign currency requisition with a fixed price line type the following error occurs:

ERROR
-----------------------
"52413 AMOUNT Amount is mandatory for lines with value basis = 'Fixed Price' "



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

 

  1. Populate the Requisition interface with any method available using a fixed price value basis and a foreign currency.  *
  2. Run the requisition import program



* Specifically the fields LINE_TYPE is populated with a line type that is "Fixed" and the fields CURRENCY_CODE, RATE_DATE & RATE_TYPE have foreign currency information populated.  (Code, Date and Rate Conversion Type)

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