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 DECEMBER 31, 2020

Applies to:

Oracle Shipping Execution - Version to 12.2.8 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Reviewed for currency 28-April-2019


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:



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

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