E1: 45: Order Reprice (R42750) Does Not Include Closed Lines in Recalulation of Order Level Adjustment (Doc ID 2946150.1)

Last updated on JULY 12, 2023

Applies to:

Symptoms

Order and Basket Level Pricing (R42750) does not include closed lines from partial shipments when recalculating an order level adjustment. The client has created an order level adjustment of $30.00 to charge an Order Handling Fee for orders less than or equal to $300.00, but Order Handling Fee is zero if the order exceeds $300.00. If the order has multiple lines totaling more than $300.00 and a partial shipment is made and the lines processed by Sales Update (R42800) which cause the Open Order Amount to be less than $300.00 the Order and Basket Level Pricing (R42750) recalculates the Order Handling Fee as 30.00.

Steps to Duplicate:

1. In Line Type Constants (P40205) Create a FH Line Type for Small Order Handling Fee.
2. Create Order Activity Rules (P40204) for SO Order Type and FH Line Type.
3. Setup a Price Adjustment Definition (P4071) as follows:
   1. Order Level Adjustment
   2. Adjustment Control Code 3 (Add to Sales Detail File)
   3. Line Type FH
   4. Amount Level Break
4. Setup an Adjustment Schedule (P4070) with the one adjustment on it.
5. Add the schedule to Customer Billing Instructions (P03013)
6. Adjustment Detail (P4072) has the following setup.
   1. From Level -30.00 to +300.00 has Basis Code 5 Add-On Amount of $30.0
   2. From Level 300.01 has Basis Code 5 Add-On Amount of $0.00.
7. Create a version of SO Entry (P4210) as follows:
   1. Set Process Tab Option #4 (Auto Order Repricing) = 1 (Use auto order repricing).
8. Use SO Entry (P4210) to create a two-line sales order where both items qualify for the order level adjustment.
   1. Line 1 is 230.00
   2. Line 2 is 250.00
   3. Save the order
9. Work with Submitted Jobs shows Order and Basket Level Pricing (R42750) was launched from SO Entry (P4210)
10. Customer Service Inquiry (P4210) shows a third line added for a Small Order Handling Fee of Zero because the order was more than 300.00.
11. Order Header Inquiry (P4210) shows Open Order Total (F4201.OTOT) is 480.00.
12. Process Line 2 all the way through Sales Update (R42800) leaving only line 1.000 open. Order Total still shows 480.00.
13. Go into Sales Order Detail Revisions. Notice that Line 2.000 is no longer in the Open Sales Order file (F4211). Change the requested and promised dates on line 1.000 and save the changes.
14. After Changing the order dates, Work with Submitted Jobs shows Order and Basket Level Pricing (R42750) was launched again from SO Entry (P4210).
15. Returning to Customer Service Inquiry (P4210), the previous order level adjustment line was canceled, and a new small adjustment fee was added for the $30.00 amount. The Order Total on the Customer Service screen is 510.00 (30.00 higher). Since the order is over 300.00 the client does not want the $30.00 small order fee assigned. 
16. The Sales Header now shows the Open Order Total (F4201.OTOT) as 510.00 with the 30.00 fee assessed.

Small Handling Fee of $30 Not Added after Order Entry (CORRECT) 

Small Handling Fee of $30 is Added after Partial Shipment/Sales Update (INCORRECT)

Cause

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