Order Import Leaves Orphaned Lines In OE_LINES_IFACE_ALL
Last updated on MAY 21, 2017
Applies to:Oracle Order Management - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
*** Checked for relevance on 02-Dec-2014 ***
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.
Expect the order import corrections form will reset the flag at the order lines
when the flag at header is set.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms