Order Import Leaves Orphaned Lines In OE_LINES_IFACE_ALL (Doc ID 372750.1)

Last updated on MAY 21, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
*** Checked for relevance on 02-Dec-2014 ***

Symptoms

On 11.5.10 in Production:
When there is an error during order import, going to Order Import Corrections, reset the flag at Header level, it does not reset the flag at lines level. The flag at order lines has to be manually set to have the order lines being processed.

It was working fine in 11.5.9, before upgrade to 11.5.10.

EXPECTED BEHAVIOR
Expect the order import corrections form will reset the flag at the order lines
when the flag at header is set.

STEPS
The issue can be reproduced at will with the following steps:
1. Orders come in via e-Commerce Gateway; some import successfully, some don't.
2. Those that don't, go to the OM Corrections table.
3. Open Order Import Corrections form, select Import button,
it only imports the header, not the lines.

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