My Oracle Support Banner

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 11.5.10.2 and later
Information in this document applies to any platform.

Goal

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.

NOTE:  This also applies in cases where a previous period was closed before unprocessed shipping transactions were resolved.  The script hidden in this document can also be used to move the transactions into the current period which is still open



How can this be accomplished?

The following query can be used to identify the problematic records:

select wdd.source_header_number "Order Number",
ol.flow_status_code,
wdd.source_line_id "line id",
wdd.delivery_detail_id "del det id",
wnd.delivery_id,
wdd.released_status RelStat,
wdd.oe_interfaced_flag OEintf,
wdd.inv_interfaced_flag INVintf,
wdd.creation_date,
wts.stop_id,
wts.pending_interface_flag PendIntf
from wsh_new_deliveries wnd,
wsh_delivery_assignments wda,
wsh_delivery_details wdd,
wsh_delivery_legs wdl,
wsh_trip_stops wts,
oe_order_lines_all ol,
oe_order_headers_all oh
where wnd.delivery_id=wda.delivery_id
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;

 

 

Solution

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
Goal
Solution
References


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