Import Catalogs with FBDI

You can use file-based import to import quantities of catalog and category data into your production tables.

To import catalog and category data into Product Hub tables:

1. For general guidance on this procedure, refer to the Oracle Fusion Cloud SCM: File-Based Data Import (FBDI) for SCM guide on the Oracle Help Center.

2. See that guide's topic about loading data into tables, and follow the generalized procedure for loading data into interface tables, as modified by these instructions.

3. For the file-based data import template to use, see that guide's reference section on the Catalog process, and download the XLSM template workbook named EgpCatalogImportTemplate.xlsm.

4. On each worksheet tab in the XLSM template workbook, prepare the data for each interface table. Refer to the text above each column header for instructions on preparing the data in that column, and for a description of the data and data type that the column requires. Catalogs are defined by a combination of CATALOG_NAME and CATALOG_CODE values, so provide values for both columns. The table following these steps maps each tab to the corresponding interface control file and interface table. A value for START_DATE is required when creating a new catalog.

   For proper processing of the imports, you must assign an ID number in the Batch_ID column, on each of the worksheet tabs, using a number that's not already in use for an item batch created on the Manage Item Batches page. Enter the same batch ID number on each of the worksheet tabs, which contain different types of catalog data.

   When finished, generate the CSV file for your input sheet, and put it into compressed (.zip) file format.

5. For the step using the File Import and Export tool, which imports the .zip file containing the CSV file to the Oracle WebCenter Content system repository, use the account scm/item/import, as specified on the reference page for Catalog.

6. When scheduling and submitting the Load Interface File for Import process, specify these parameters:

   • For Import Process, select Schedule Catalog Import Job, which will load the catalog data into the production tables when you later schedule this process.

   • For Data File, select the uploaded .zip file containing the CSV file that you created from the XLSM template workbook.

7. Wait for the Load Interface File for Import process to complete, then schedule and submit the Schedule Catalog Import Job process, specifying these parameters:

   • In the Batch ID field, enter the same batch ID number that you assigned in the worksheets of the XLSM template workbook.

   • Leave the Reprocess Error field empty.

   • Leave the Purge field empty.

8. When the Schedule Catalog Import Job process finishes, examine the log files for status and errors during the import.

The following table lists the types of catalog and category data that you can import, and maps each type to the worksheet tab that you use to enter the data, and the corresponding interface control file and interface table used by the import.

Worksheet Tab	Control File	Interface Table	Object
Catalogs	EgpCategorySetsInterface.ctl	EGP_CATEGORY_SETS_INT	Catalog header information and descriptive flexfields for the catalog.
Catalogs Translation	EgpCategorySetsTlInterface.ctl	EGP_CATEGORY_SETS_TL_INT	Translated content for the catalog.
Categories	EgpCategoriesInterface.ctl	EGP_CATEGORIES_INT	Categories in the catalog, the category hierarchy information, and descriptive flexfields for the categories.
Category Translations	EgpCategoriesTlInterface.ctl	EGP_CATEGORIES_TL_INT	Translated content for the categories in the catalog.
Attachments	EgpCatalogCatAttachInterface.ctl	EGP_CATALOG_CAT_ATTACH_INT	Attachments for the catalogs and categories.