TEMPORARY DATAFIX ONLY: Move Pending Shipping Transactions into the Next Period to Allow Close of the Current Period
(Doc ID 1197057.1)
Last updated on MAY 01, 2018
Applies to:Oracle Shipping Execution - Version 126.96.36.199 and later
Information in this document applies to any platform.
When performing period closing activities, you may encounter unprocessed shipping transactions on a few orders which prevent completing the period close. You may not be able to wait to receive a datafix script from Development before closing the period. Therefore, you may decide to move the stuck transactions to the following period (for example, February) in order to close the current period (January) Then the orders can be reviewed by development and a datafix provided later.
How can this be accomplished?
The following query can be used to identify the problematic records:
wdd.source_line_id "line id",
wdd.delivery_detail_id "del det id",
from wsh_new_deliveries wnd,
and wda.delivery_detail_id = wdd. delivery_detail_id
and wdd.source_header_id = oh.header_id
and ol.line_id = wdd.source_line_id
and wnd.delivery_id = wdl.delivery_id
and wdl.pick_up_stop_id = wts.stop_id
and wdd.source_code = 'OE'
and wdd.released_status = 'C'
and (wdd.oe_interfaced_flag ='N' or wdd.inv_interfaced_flag in ('P','N'))
and nvl(wts.actual_departure_date, wdd.creation_date) > sysdate - 60;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document