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 APRIL 19, 2024

Applies to:

Oracle Shipping Execution - Version 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.

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.