Import an Item Structure

Importing structures of items is similar to importing regular items. When you intend to collect items in a structure and then import that structure, the regular items must first exist in the application.

If some or all items going into the structure don't exist already in the application, these items must be created or imported before you design and import the structure.

1. Download the Item Structure Import template file from the following guide: Oracle Fusion Cloud SCM File-Based Data Import (FBDI) for SCM.

   This guide contains information about the template.

2. Enter the item information on the EGP_STRUCTURES_INTERFACE tab:

   • Set the Transaction Type to SYNC.

   • Enter a Batch ID such as 200.

   • Enter the Structure Name such as Primary.

   • Enter an Organization Code such as 000.

   • Enter the Item Name.

   In the EGP_SYSTEM_ITEMS_INTERFACE tab, you need not enter the item version start date. The application calculates this value based on item effectivity date in the EGP_ITEM_REVISIONS_INTERFACE tab. In case of multiple item revisions (or effectivity dates), the earliest date is considered.

3. Enter the structure information on the EGP_COMPONENTS_INTERFACE tab:

   • Set the Transaction Type to SYNC.

   • Enter the same Batch ID as on the EGP_STRUCTURES_INTERFACE tab.

   • Enter the Structure Name as Primary.

   • Enter the same Organization Code as on the EGP_STRUCTURES_INTERFACE tab.

   • Enter a child item in Component Item Name.

   • Enter the parent item in the Structure Item Name.

   • Enter a number for the component item sequence which determines the order in which child items are listed. In the absence of a sequence number or in case of a duplicate sequence number, the application automatically generates the sequence number.

   • Enter a number for the quantity of each item.

4. Generate CSV files:

   • Select the Instructions and CSV Generation tab and click the Generate CSV File button.

   • Click Save each time the macro prompts to do so.

   • Locate the zip file that was generated by the macro.

5. Import the zip file:

   • From Navigator, open File Import and Export.

   • Click the Create New + icon.

   • Click the Browse button and locate the zip file that was generated by the macro.

   • In the Account field, select SCM / item / import.

   • Click Save and Close.

6. Load data to interface tables:

   • From Navigator, open Scheduled Processes.

   • Click the Schedule New Process button.

   • Search for and select Load Interface File for Import as the process name.

   • Click OK.

   • Select Item Import as the Import Process.

   • Select your zip file as the Data File.

   • Click Submit.

   • Note the process number.

   • Click the Refresh icon on the Scheduled Processes Overview page to watch for the process to complete.

7. While still in Scheduled Processes, click the Schedule New Process button.

   • Search for and select Item Import and click OK.

   • Enter the same Batch ID that you put in the spreadsheet.

   • Select the same organization that you put in the spreadsheet.

   • Set the other fields as required.

   • Click Submit.

   • Note the process number.

   • Click the Refresh icon on the Scheduled Processes Overview page to watch for the process to complete.