1. Scheduled Processes for SCM
  2. Create Hybrid Time Hierarchies

Create Hybrid Time Hierarchies

Run the Create Hybrid Time Hierarchies scheduled process to create hybrid time dimension hierarchies for your demand plan's selection of calendars.

In Supply Chain Planning, each calendar has a corresponding time dimension hierarchy with day as the common lowest level. The Create Hybrid Time Hierarchies process creates an additional time hierarchy for each of the selected calendars by introducing a new common lowest aggregate time level named “Hybrid time level.”

When to Use

Because non-hybrid aggregate time-level demand plans limit you to managing the plan data using only the plan’s planning-calendar time hierarchy, use this process to review and manage demand-plan data in both week and month aggregations in an aggregate hybrid time-level demand plan.

For example, if you've defined a demand plan at a week level using a manufacturing calendar, then you wouldn’t be able to view data in Gregorian or fiscal calendar month aggregations. With hybrid time hierarchies, you can manage data using manufacturing, Gregorian, and fiscal calendar time hierarchies in the same hybrid time-level demand plan.

Privileges Required

  • Edit Plans (MSC_EDIT_PLANS_PRIV)
  • Plan Management (ORA_MSC_PLAN_MANAGEMENT_DUTY)
  • Planning Administration (ORA_MSP_PLANNING_ADMINISTRATION_DUTY)
  • Run Plan with Snapshot (MSC_RUN_PLAN_WITH_SNAPSHOT_PRIV)

Specifications

Review these specifications before setting up this scheduled process:

Specification Description
Job Type Running it on a spontaneous basis is recommended, but it also can be scheduled as part of integrated job set.
Frequency Only one time as an initial setup. You don't need to rerun the scheduled process unless you change the start date or end date, or one or both of your selected calendars.
Time of Day It can be submitted any time, based on your requirements.
Duration Typically, less than 5 minutes.
Compatibility There should be only one instance of the job running for the selected calendars, and there’s no current functional need to run multiple instances of this process simultaneously. It’s not recommended to run this process while running the fiscal calendar or manufacturing calendar entity collection process or Build Gregorian Calendar process.

Parameters

Parameter Optional or Required Description Parameter Value Special Combinations Required Notes
Calendars Required Select the calendars for which to want to create hybrid time hierarchies. Select the check boxes for the calendars for which you want to create hybrid time hierarchies. These user interface validations are enforced for calendar selection:
  • You can select a maximum of three calendars of the fiscal, Gregorian, and manufacturing types.
  • One of the calendars you select must be of the manufacturing type.
  • You can’t select more than one calendar of a particular type.
 N/A

Troubleshooting Information

  • You can view the status of the Create Hybrid Time Hierarchies process on the Scheduled Processes UI.
  • Refer to the log file attached to the Create Hybrid Time Hierarchies process for details, including warning and error messages. The log file also provides the names of the hybrid time dimension hierarchies.
  • Hybrid time-dimension hierarchies are created only for the overlapping time periods between the selected calendars.

    For example, if you select a manufacturing calendar defined for the years 2015 to 2025 and a Gregorian calendar defined for the years 2005 to 2035, then the hybrid-time hierarchies will be created only for the years 2015 to 2025. The ESS log file for the Create Hybrid Time Hierarchies process provides the start and end date of the hybrid time dimension hierarchies.

Related Topics