Limitations When Using ScpCatalogImportTemplate.xlsm To Load Item Catalogs and Item Categories

(Doc ID 2410935.1)

Last updated on JUNE 26, 2018

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Goal


The CatalogCategoryAssociation.csv file that was generated using ScpCatalogImportTemplate.xlsm contains 73 records.
Some of the Category records have PARENT_CATEGORY_NAME populated with a value and some of the records are left blank for PARENT_CATEGORY_NAME.

After running the Flat File collection the Load Entity log file for the CATSET_CATEGORY_ASSIGNMENT shows the following:
The number of records considered by the Load Entity process: 73. The number of valid, error, and deleted records: 14, 0, and 0.

All 73 records made it into the staging tables yet only the 14 made it to the ODS tables and no errors are seen in the staging tables.

What could be causing this issue?
 

Solution

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