Set up an enterprise calendar using an Oracle EBS source system

To set up an enterprise calendar using an Oracle EBS source system:

1.    In the DAC, display the Design tab, and select an appropriate adapter.

2.    Display the Source System Parameters tab.

3. Set the value of $$GBL_CALENDAR_ID and $$GBL_DATSOURCE_NUM_ID as

follows:

■ GBL_CALENDAR_ID:

This parameter is used to select the Enterprise Calendar.

It should be the MCAL_CAL_NAME~MCAL_PERIOD_TYPE for Non-Generated Calendars. For example GBL_CALENDAR_ID will be 'Accounting~41', if the Enterprise Calendar id='Accounting' and the calendar  period_type='41'.

■ GBL_DATASOURCE_NUM_ID:

If Enterprise Calendar is not a Generated Calendar: Should be the DATASOURCE_NUM_ID of the source system from where the Calendar definition is taken.

(Example: If we have two Data source as PeopleSoft and Oracle, and our Global Calendar is from Oracle source, then parameter value should be of Oracle source.)

Note: The tasks that load the Enterprise calendar will run as part of the execution plan for your subject area. Please note that is no separate subject areas for common dimensions. They are included in the core subject areas.