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 default Product catalog is populated into the Product hierarchy.

If you haven't set up the default Product 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.

For information on setting up the default Product catalog, see the topic titled Guidelines for Setting Up Catalogs for Collections

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.