Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Document 1216527

    Uploaded by

    Huy Le
    The document describes an issue where latest and earliest ship dates were being calculated incorrectly on delivery lines in Oracle Shipping Execution. This caused incorrect dates to be sent to Oracle Transportation Management. The cause was identified as an incorrect date being passed as a parameter when calculating dates. A patch was provided as the solution to fix the issue.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Document 1216527

    Uploaded by

    Huy Le
    3 views2 pages
    The document describes an issue where latest and earliest ship dates were being calculated incorrectly on delivery lines in Oracle Shipping Execution. This caused incorrect dates to be sent to Oracle Transportation Management. The cause was identified as an incorrect date being passed as a parameter when calculating dates. A patch was provided as the solution to fix the issue.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes an issue where latest and earliest ship dates were being calculated incorrectly on delivery lines in Oracle Shipping Execution. This caused incorrect dates to be sent to Oracle Transportation Management. The cause was identified as an incorrect date being passed as a parameter when calculating dates. A patch was provided as the solution to fix the issue.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    3 views2 pages

    Document 1216527

    Uploaded by

    Huy Le
    The document describes an issue where latest and earliest ship dates were being calculated incorrectly on delivery lines in Oracle Shipping Execution. This caused incorrect dates to be sent to Oracle Transportation Management. The cause was identified as an incorrect date being passed as a parameter when calculating dates. A patch was provided as the solution to fix the issue.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    Document 1216527.1 https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-stat...

    Wrong Latest And Earliest Ship Date Calculation On Delivery Lines (Doc ID 1216527.1)

    In this Document

    Symptoms
    Cause
    Solution
    References

    APPLIES TO:

    Oracle Shipping Execution - Version 12.1.2 and later


    Information in this document applies to any platform.
    ***Checked for relevance on 03-DEC-2013***

    SYMPTOMS

    On : 12.1.2 version, Warehouse Shipping

    Latest and Earliest Ship date calculations on Delivery lines are calculated wrong and hence sending wrong date to OTM.

    STEPS
    -----------------------
    The issue can be reproduced at will with the following steps:
    1. Set the following Profiles
    OM: Sequence for TP Ship/Deliver Deadline - Promised Date/Schedule Ship Date
    OM: Source for TP Early Ship/Deliver Date - Same as Ship / Deliver date
    WSH: Populate Latest Ship / Delivery Date - YES
    FTE: Late Ship Offset Days - 0

    2. Delivery Calculation Method in Global Shipping Parameters - Schedule Ship date / Requested Date
    3. Go to Order Management > Sales Order
    4. Select Customer and go to Others Tab
    5. Enable "Order Date Type" Field. Select value "Arrival"
    -- Calculating Scheduled Arrival date based on Requested Date + Lead time
    6. Create 2 lines with item xxx which is ATP Enabled.
    -- Check the Schedule Ship date and Scheduled Arrival date .
    -- It is populated correctly
    7. Book the Sales order.
    8. Now go to Shipping Transaction screen. Check for Order
    9. Following Dates on Delivery detail line are incorrect - "01.01.2010 01:00:00"
    Latest Ship Date
    Early Ship Date

    10 . Now create Delivery without performing Pick Release to send this Delivery to OTM
    Now look at the same dates on Delivery and it's wrong as well
    Also check the same Delivery in OTM and it has wrong Latest Pickup Date and Earliest Pickup Date.

    BUSINESS IMPACT
    -----------------------
    The issue has the following business impact:
    Due to this issue, OTM is picking all the deliveries based on Earliest pick up date and Latest pick up date. If these dates are showing on the
    Delivery lines incorrectly, then OTM can not pick the correct deliveries.

    CAUSE

    1 of 2 5/17/2017 11:04 AM
    Document 1216527.1 https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-stat...

    In procedure WSH_TP_RELEASE.calculate_tp_dates the parameter


    'P_Demand_Satisfaction_Date' passed is based on
    OE_DELIVERY_LINES_V.earliest_ship_date.
    The field earliest_ship_date is always populated as
    FND_API.G_MISS_DATE in order lines and passed to API.
    The parameter value 'P_Demand_Satisfaction_Date' is used to calculate the
    Earliest/Latest Ship Date for an ATP items.

    Bug 10013948 - WRONG LATEST AND EARLIEST SHIP DATE CALCULATION ON DELIVERY LINES

    SOLUTION

    === ODM Solution /Action Plan ===

    To implement the solution, please execute the following steps:

    1. Download and review the readme and pre-requisites for Patch 10013948:R12.WSH.B

    2. Ensure that you have taken a backup of your system before applying the patch.

    3. Apply the patch in a test environment.

    4. Confirm the following file versions:


    patch/115/sql/WSHTPRLB.pls - version 120.11.12010000.3

    5. Retest the issue.

    6. Migrate the solution as appropriate to other environments.

    REFERENCES

    BUG:10013948 - WRONG LATEST AND EARLIEST SHIP DATE CALCULATION ON DELIVERY LINES
    Didn't find what you are looking for?

    2 of 2 5/17/2017 11:04 AM

    You might also like