My Oracle Support Banner

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

Last updated on FEBRUARY 16, 2019

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

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
Symptoms
Cause
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.