Orders getting stuck in Order corrections form without any error during import of Sales Order (Doc ID 2306051.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Transaction Entry

ACTUAL BEHAVIOR
---------------

One or Two Orders are getting stuck in order import interface tables,  without any errors during import of 250 to 300 sales orders. However , upon re-importing through corrections form, they are imported successfully.

EXPECTED BEHAVIOR
-----------------------

No order should get stuck in interface without any error and should get imported immediately.

STEPS
-----------------------
The issue cannot be reproduced at will . However the issue can be seen in test instance with the following steps:

1. Populate the interface tables in test instance (Orig_Sys_Document_Ref = 529142-98347257)
2. Run the Order Import program
3. Open the corrections form and find that the orders are stuck without any errors.
4. Import the stuck records manually through corrections form

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Order creation,invoice creation is not happening for drop ship functionality.
Every month end is severely affecting as these records are getting stuck.

Cause

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