Creation Issue For Korea Using WEBADI Upload (Doc ID 2053458.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Price Protection - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :12.1.3 Oracle Price Protection, Production

When a user tries to upload a new Price Protection transaction using WEBADI, the upload is failing and the error says "Prior Price cannot be Zero or Negative".

The details of the transaction where issue is happening is as follows:

OU: ABC
Currency : USD
Supplier: NXP

The field 'LIST_PRICE_PER_UNIT' is also having some amount at both V01, PIVO level in MTL_SYSTEM_ITEMS_B table. The prior price can be derived from this field as well. The ledger currency is KRW while the Price Protection currency is USD.

The supplier currency in STP is set as USD. If the user changes the Price Protection currency as KRW instead of USD, then Price Protection is getting uploaded.

But if it is USD, then it gives the prior price error.

ERROR
-----------------------

The upload process has completed with errors. Press close to return to the document and fix the errors

* No rows uploaded
* 0 rows were invalid
* An error has occurred while running an API import. The transaction with the supplier name NXP SEMICONDUCTORS NETHERLANDS B.V (Supplier ID 4186) and Document Ref Number NXPQ414BILLDOWNKR failed. Prior Price cannot be zero or negative

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upload a new Price Protection transaction using WEBADI,

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, business cannot upload price protection transactions

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