Semantic layer (RPD) metadata contains session variables to store the current fiscal year, fiscal quarter, and fiscal period and so on for the user. To support multiple fiscal calendars, you need to get the default fiscal calendar for a user based on the Ledger and/or Business Unit assigned to the user, and then get the current fiscal year, quarter and so on based on this default fiscal calendar.
In order to do this, appropriate initialization blocks need to be enabled depending on the deployed source system and all others have to be disabled. The initialization block names relevant to various source systems are given below. If more than one source system is deployed, then you must also enable the initialization blocks of those source systems.
There are two sets of init blocks related to this feature:
Ledger related Init Blocks:
Oracle Fusion Applications: Ledgers_MCAL Fusion
E-Business Suite 11i: Ledgers_MCAL EBS11
E-Business Suite R12: Ledgers_MCAL EBS12
Oracle PeopleSoft: Ledgers_MCAL PSFT
Operating Unit related Init Blocks:
Oracle Fusion Applications: Operating Unit Orgs Calendar Fusion
E-Business Suite (All versions): Operating Unit Orgs Calendar EBS
Oracle PeopleSoft: Operating Unit Orgs Calendar PSFT
To enable initialization blocks:
OracleBIAnalyticsApps.rpd
).