E1: 42: Pick Date Wrong if Prep Days (16) Activated Without Delivery Date (09) Preference (Doc ID 2191756.1)

Last updated on SEPTEMBER 24, 2022

Applies to:

Symptoms

Sales Order Entry (P4210)

ACTUAL BEHAVIOR
When changing the Requested Date on a Sales Detail line with the Order Preparation Days (16) Preference Activated, but the Delivery Date Preference (09) not Activated in the Preference Selection (R40400) program, the Scheduled Pick Date and Promised Ship Date fields are cleared but the Promised Delivery Date is NOT cleared. When the line is edited, the line gets recalculated based on the original Promised Delivery Date on the Sales Detail line. If the Delivery Date Preference (09) IS Activated in the Preference Selection (R40400) the Promised Delivery Date is cleared and the line gets recalculated correctly based on the new Requested Date.

EXPECTED BEHAVIOR
The New Requested Date on the Order Detail Line should be used to recalculate the Scheduled Pick date based on the Order Preparation Days Preference.

The issue was reproduced with the following steps:

1. In Customer Master (P03013) create a new customer (40316) that will be used with the Order Preparation Days Preference.
2. In Order Preparation Days Preference (P40316) add a record for the customer and all items with 3 order preparation days.
3. In the Version of Sales Order Entry (P4210) set Preference Tab Option #1 = 1 (Activate preferences).
4. Make sure Defaults Tab Option #10 (Update Header to Detail) is set to 1 (activated).
5. On Preference Selection (R40400 Version ZJDE0001) Process Ctl 3 Tab Option #1 (Order Preparation Days) is set to 1 (Activated).
6. On Preference Selection (R40400 Version ZJDE0001) Process Ctl 2 Tab Option #1 (Delivery Date) is set to BLANK (Not Activated).
7. Today’s date is 10/10/2016. Create a Sales order Header First. Make the requested date 10/24/2016.
8. Enter 2 detail lines as follows:
   1.   Line 1 Requested Date is 10/17/2016, Scheduled Pick 10/14/2016.
   2.   Line 2 Requested Date is 10/21/2015, Scheduled Pick 10/17/2016.
9. Reinquire and Row Exit to SO Detail Revisions.
10. On the first line change the Requested Date from 10/17/16 to 10/28/16, click in the Scheduled Pick Date field and the system automatically clears all the Promised Ship Date but NOT the Promised Delivery Date fields.
11. Edit the line. The 3 order prep days are NOT subtracted and the scheduled pick date is calculated based on the original Promised Delivery Date.
12. Reenter the order and manually blank out the Pick Date, Ship Date and Delivery Date field.
13. Edit the line. The scheduled pick date is recalculated to 3 days earlier than the new requested date.

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.