Price Line Import Will Not Redline Existing Price Line Price Effective To Date While Adding New Price Line (Doc ID 2492045.1)

Last updated on DECEMBER 04, 2019

Applies to:

Goal

ACTUAL BEHAVIOR
How to use import to redline Published Price existing Price Line row while adding new rows?

For example, there is below Price Line that needs to be updated.

Expect to redline using import with the following :

The existing first row Price Effective To Date attribute will be redlined. 2nd new row will be added as redline.

Currently, when setting import preference : Multi Row Update Mode is set to Add/Update Only, existing row does not get updated.
When setting Multi Row Update Mode : Complete Replace, it will remove existing row.

STEPS

Test Case for Multi Row Update Mode: Add/Update Only

1. Login to Web Client and create new Price : PRICE00004

Item Number: P00113
Item Rev:
Supplier:testBroker01 (BROKER00001)
Price Type:Published Price
Number:PRICE00004
Description:
Lifecycle Phase:Preliminary
Allow Qty Breaks:Yes
Owner:okada, yuki (yukokada)
Customer:ALL
Program:ALL

2. Create PCO: PCO00002 for above Price to have Published Price with following Price Line

3. Release PCO: PCO00002

4. Tools and Settings > Import

Import File : PriceListTest.xlsx

Template Type : Standard Template

5. Import Preference > Business Rule

Multi Row Update Mode: Add/Update Only
Price Quantity Break Default: Yes

6. Specify File Content : Published Price Lines : check

7. Data Mapping

Use a saved mapping file : PriceMapFile.xml

Redline Options : Use the following Change for redlining
PCO00003

8. Import

9. Go to PCO00003 , Price Lines tab

Redlines for PRICE00004

Result : Row shown with red font are new row added with Redline.

Test Case for Multi Row Update Mode : Complete Replace

1. Tools and Settings > Import

Import File : PriceListTest.xlsx

Template Type : Standard Template

2. Import Preference > Business Rule

Multi Row Update Mode: Complete Replace
Price Quantity Break Default: Yes

3. Specify File Content : Published Price Lines : check

4. Data Mapping

Use a saved mapping file : PriceMapFile.xml

Redline Options : Use the following Change for redlining
PCO00003

5. Import

6. Go to PCO00003 , Price Lines tab

Redlines for PRICE00004

Result : 1st and 3rd row are added with Redline. 2nd row which is existing row, was removed with Redline.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.