How to Move Pending Shipping Transactions into the Next Period to Allow Close of the Current Period (Doc ID 1197057.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance 11-April-2014

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.

How can this be accomplished?

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

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms