E1: 45: Base Price Batch Update (R41830) Does Not Expire Old Price (Doc ID 1929106.1)

Last updated on NOVEMBER 29, 2021

Applies to:

Symptoms

When the Base Price Batch Update (R41830)  is run to create a new base price, it does create the new base price, but it leaves the original base price with the original expiration date and does not expire the original base price record.

The test below illustrates the issue:

1. Go into Work with Base Prices (P4106) in the QBE Line
   1. Enter Eff Date From > “01/01/2020”
   2. Enter Eff Date Thru > “12/02/2021
   3. There are 224 records returned
2. Setup a Version of Base Price Batch Update (R41830)
   1. Set Update Tab Option #1 (Update Base Price File) to 1 (Performs Update)
   2. Set Adjustments Tab Option #1 (Price Adjustment Type) to % (Adjust price by percentage)
   3. Set Adjustments Tab Option #2 to 5 (5%)
   4. Set Effective From Date to 11/24/2021 (Today’s Date)
   5. Set Effective Thru Date to 12/31/2030 
3. Run Base Price Batch Update (R41830) with data selection as follows:
   1. Eff Date From > “01/01/2020”
   2. Eff Date Thru > “12/02/2021
4. Report PDF shows prices were increased 5% and Expiration Dates set on new prices to 12/31/2030
   1. For example Item 2112 increased from 1,000.00 to 1,050.00.
5. Go into Work with Base Prices (P4106) and find Item 2112. There are two prices now:
   1. Original Price has the Effective Date Thru Date set as 12/31/2025 which was not changed
   2. Effective Date Thru for the original price should have been set to Today’s Date (Expired)

Changes

Cause

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