GBL_CALENDAR_ID Parameter

This parameter specifies the Enterprise Calendar. For non-generated calendars, its value should be in the following format:

MCAL_CAL_NAME~MCAL_PERIOD_TYPE

For example:

Accounting~41

where:

  • MCAL_CAL_NAME corresponds to PERIOD_SET_NAME in the GL_PERIODS table.

  • MCAL_PERIOD_TYPE corresponds to PERIOD_TYPE in the GL_PERIODS table.

To view the valid MCAL_CAL_NAME~MCAL_PERIOD_TYPE combinations, run the following query against the Oracle E-Business Suite OLTP database:

SELECT DISTINCT PERIOD_SET_NAME || '~' || PERIOD_TYPE FROM GL_PERIODS;