OEOIMP: Order Import does not spawn child request. (Doc ID 1322574.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
****Checked for relevance on 06-OCT-2014***

Symptoms

Find the Order Import request submitted for an Internal Requisition (IR) does not spawn the Child request.
Hence the IR does not get imported and Internal Sales Order cannot be created.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Purchasing responsibility -- Requisitions -- Create an IR
2. Run the Create Internal Orders request
3. From OM responsibility submit the Order Import request.


Parent Order Import request log shows


IMP SHIPMENTS PROFILE = YES
DERIVED CUSTOMER KEY PROFILE SETTING = N
AFTER SETTING DEBUG ON
BEFORE INITIALIZATION
BEFORE GETTING REQUEST ID
PERFORMANCE PARAMETER:Y
REQUEST ID: 29002406
BEFORE GETTING ORGANIZATION ID
INSIDE NUM INSTANCES LOOP
BEFORE SOURCES LOOP
SOURCE CURSOR VALUE = 10
SOURCE CURSOR VALUE = 10
ROW COUNT = 0
END OF ORDER IMPORT CONCURRENT PROGRAM


See Row Count is 0

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