My Oracle Support Banner

Limitations When Using ScpCatalogImportTemplate.xlsm To Load Item Catalogs and Item Categories (Doc ID 2410935.1)

Last updated on AUGUST 24, 2020

Applies to:

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


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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.