Considerations for Setting Up Dimension Catalogs

Oracle Fusion Cloud Supply Chain Planning provides predefined planning dimensions and each of those dimensions have predefined hierarchies. The predefined hierarchies are included in the default dimension catalog and are available in all plans.

Hierarchy Selections for the Product Dimension

A predefined product hierarchy is included in the default dimension. The default product hierarchy has three fixed levels: Item, Category 1, and Category 2. Other product hierarchies (other item catalogs in Oracle Product Model that are collected into Supply Chain Planning work areas) can be optionally enabled as user-defined product hierarchies.

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

By default, Product Model's planning functional area catalog is collected into the product hierarchy. For the collection to run successfully, you must create the planning functional area catalog in Product Model with the following attributes:

• Controlled at = Master-Level (not Org-Level)

• Allow hierarchy of categories = No

• Default category must be selected

• Allow multiple item category assignments = Not selected

• Catalog Content = Items at Leaf Level

If this catalog is not set up with these attributes, the planning functional area catalog is not collected and the Product hierarchy will not be populated. This will result in the forecasting engine not being able to use the product aggregation and some of the predefined tables and graphs will not work correctly.

Hierarchy Selections for the Organization Dimension

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

Hierarchy Selections for the Customer Dimension

The default Customer hierarchy has three fixed levels: Customer site, Customer, and Customer Class. This default customer hierarchy is defined in the trading community model and you can only modify it there.

Hierarchy Selections for the Resource Dimension

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

Hierarchy Selections for the Supplier Dimension

The default Supplier hierarchy has two fixed levels: Supplier Site and Supplier.

Hierarchy Selections for the Exception Type, Order Type, and Source Dimensions

Predefined Exception Type, Order Type, and Source dimensions are included in the Default dimension catalog. Each has only a single hierarchy with a single level.

Hierarchy Selections for the Time Dimension

In the Time dimension, Gregorian calendar is the only predefined hierarchy. All other hierarchies can be optionally included as user-defined hierarchies. These include workday calendars of inventory organizations collected from Oracle Fusion Cloud Supply Chain & Manufacturing and fiscal calendars from Oracle Fusion Cloud Financial Management.