Set Up an Enterprise Calendar Using an Oracle EBS Source System

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
   
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. Use the following EBS Source query to identify possible values for this parameter:
     

     SELECT period_set_name || '~'|| period_type FROM gl_periods;
     

     This query returns a list of choices for the $$GBL_CALENDAR_ID parameter. To select the Enterprise Calendar, use one of the returned values as the value for $$GBL_CALENDAR_ID. Note that the format of the parameter $$GBL_CALENDAR_ID is a concatenation of the PERIOD_SET_NAME and PERIOD_TYPE.
     
   • $$GBL_DATASOURCE_NUM_ID: This parameter is the data_source_num_id with which you have loaded the EBS calendars.
     
   Note:

   The tasks that load the Enterprise calendar will run as part of the Execution Plan for your Subject Area. There are no separate Subject Areas for common dimensions; they are included in the core Subject Areas.