Fusion PIM: Unable to Load Item Child Lines With Item Import Program Using File Based Data Import and Automatic Item Numbering (Doc ID 2038909.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Fusion Product Model - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Import Items

Unable to load item child lines with Item import program using file based data import (FBDI) and spreadsheet “ItemImportTemplate” which was uploaded from Oracle Enterprise Repository website.
The process ends with error: ITEM_NUMBER - Item does not exist in the master organization.

 

STEPS
-----------------------
FBDI File contain 3 lines : one for master organisation and 2 lines for child organisation and automatic item numbering is activated for the item class which is used 

1- Imported the zip file through the menu “File import and export”, 
2- Through the menu “Schedule process” run the program “Load Interface File for Import” with import process = « Item Import » and .zip data file which ended with status = succeeded
3- Then run the program “Item Import” : program finishes in error . Item is created for only the master org, the 2 lines concerning child org are rejected with this error : ITEM_NUMBER - Item does not exist in the master organization.

If a second load performed only for the 2 child item lines and infill the field Item number with value generated automatically through the first load, child lines are correctly loaded.

The system should load all lines of item in one time/load.


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