Considerations for Setting Up Dimension Catalogs

Oracle Fusion Cloud Supply Chain Planning provides predefined dimensions, and those dimensions have predefined hierarchies. The predefined hierarchies are included in the Default Catalog.

Hierarchy Selections for the Customer Dimension

The default Customer hierarchy has the Customer Site, Customer, and Customer Class levels. This default hierarchy is defined in the Oracle Fusion Trading Community Model, and you can modify it there.

Hierarchy Selections for the Exception Type Dimension

The default Exception Type hierarchy has the Exception Type level.

Hierarchy Selections for the Order Type Dimension

The default Order Type hierarchy has the Order Type and Order Group levels.

Hierarchy Selections for the Organization Dimension

The default Enterprise hierarchy has the Organization, Business Unit, and Legal Entity levels. This default hierarchy is defined in Oracle Fusion Cloud HCM, and you can modify it only there. Optionally, you can enable other Organization hierarchies (based on regions, one per country).

Hierarchy Selections for the Product Dimension

The default Product hierarchy has the Item, Category Level 1, and Category Level 2 levels. You can collect other catalogs for the Product dimension into Oracle Supply Chain Planning and select the resulting hierarchies.

For Oracle Sales and Operations Planning, the Lifecycle Phase attribute is also included in the default hierarchy.

The Planning catalog is populated into the Product hierarchy.

You must create the Planning catalog in the Product Information Management work area as follows:

In the Create Catalog dialog box, in the Functional Area field, select Planning.
In the Controlled At field, select Master Level.
Select the Assign items to leaf level categories only check box.
Don't select the Allow multiple item category assignments check box.
On the Edit Catalog page, on the Details tab, in the Default Category field, select a default category.

On the Edit Catalog page, on the Category Hierarchy tab, you won't be able to create a hierarchy of categories. Under the root level, you will be able to create only one level of categories.

If you're using the file-based data import (FBDI) template named Supply Chain Planning Catalogs (ScpCatalogImportTemplate.xlsm), do the following:

On the Catalogs_ tab, in the Control Level column, enter 1.
In the Default Indicator column, enter Yes.
On the CatalogCategoryAssociation_ tab, create a hierarchy of categories if this setup meets your requirements.
On the ItemCategories_ tab, ensure that items belong to only the lowest-level categories, and that items don't belong to multiple categories.

If you haven't set up the Planning catalog, the predefined Product hierarchy of the Product dimension is used. The predefined Product hierarchy has only one predefined item. In this situation, your items won't be available in the default Product hierarchy, and your items will be available through the other hierarchies that are created for collected catalogs.

Hierarchy Selections for the Resource Dimension

The default Resource hierarchy has the Resource, Work Center, Work Area, and Organization levels. This default hierarchy is defined in Oracle Manufacturing and you can't modify it.

Hierarchy Selections for the Source Dimension

The default Source hierarchy has the Source level.

Hierarchy Selections for the Supplier Dimension

The default Supplier hierarchy has the Supplier Site and Supplier levels.

Hierarchy Selections for the Time Dimension

The Gregorian Calendar hierarchy has the Day, Month, Quarter, and Year levels. You can collect other hierarchies for the Time dimension into Oracle Supply Chain Planning and select them. These hierarchies include workday calendars of inventory organizations collected from Oracle Fusion Cloud SCM and fiscal calendars collected from Oracle Fusion Cloud Financial Management.