Fusion PIM: Unable to Load Item Child Lines With Item Import Program Using File Based Data Import and Automatic Item Numbering
Last updated on JULY 07, 2017
Applies to:Oracle Fusion Product Model - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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.
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.
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