E1: 45: "Skip To" Not Working Correctly on MIN Adjustment (Doc ID 2553112.1)

Last updated on MARCH 23, 2020

Applies to:

Symptoms

Sales Order Entry (P4210)

When the Skip To on the first adjustment in the schedule is set to go to the third adjustment, but the adjustment is not applied, the system still skips the second adjustment and goes to the third. The client is upgrading from 9.0 to 9.2. This did not happen in the 9.0 environment.

1. Create a Line Level Sales Price Adjustment Definition (P4071) named MIN59. On Additional Options Tab select the Min Adjustment radio button and set the Min/Max Rule to 1
2. Create a second and third line level adjustment (SEC59 and THIRD59).
3. Create an Adjustment Schedule (SKIPSCH) as follows
   1. Seq No. 10 MIN59 Skip To 30
   2. Seq No. 20 SEC59
   3. Seq No. 30 THIRD59
4. Create a Price Adjustment Detail (P4072) record for All Customers/All Items for MIN59.
5. Set From Level to Blank, Threshold UM to EA, Basis Code to 5, and Factor Value to 0.0001.
6. Create a Price Adjustment Detail (P4072) record for All Customers/All Items for SEC59.
7. Set From Level to 1, Threshold UM to EA, Basis Code to 1 (% of Base Price), and Factor Value to -40.
8. Create a Price Adjustment Detail (P4072) record for All Customers/All Items for THIRD59.
9. Use From Quantity 1, Threshold UM EA, Basis Code 5, Factor Value 0.
10. Create a Sales Order for any Customer and Branch and populate the Adjustment Schedule in the Order Header.
11. Enter an item that you know has a Base Price Setup.
12. Go to Price History (P4074). The third adjustment was applied. The system skipped over the second adjustment even though the first adjustment was not applied because a base price exists.
    
    
    

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.