Business date setup

---

Context

Runbook to set the current business date in AIF DATA. The table W_RTL_CURR_MCAL_G tracks the day of the fiscal calendar that all processing is relative to. Its key value is MCAL_NUM on the row where MCAL_TYPE = 'DT' — a YYYYMMDD date that every job in the AIF DATA batch schedule (POM) references whenever it needs a date.

During the initial dimension load you move this date back into the past, to the point where your historical data starts. That past date must fall within the range of the loaded calendar (see Calendar initialization using MFCS integration).

This date drives the whole schedule

MCAL_NUM (on MCAL_TYPE = 'DT') is referenced by every dated job in the AIF DATA batch schedule, so it impacts many implementation activities. Set it deliberately and confirm it with the verification in the last step.

Set the business date via POM

1. Accessing POM click on the top left menu

2. Select the sub menu “Tasks” and then “Batch monitoring”

3. Select the AIF DATA scheduler, and the Standalone chain

4. Using the filters type LOAD_CURRENT_BUSINESS_DATE_ADHOC and select the job called ETL_BUSINESS_DATE_JOB

5. Then click on the button called “Actions” then “Edit Parameters”

6. Set the desired business date using the format YYYY-MM-DD If you are starting an implementation, set the date 6–12 months before your historical data starts, for example: if your historical data starts on 2024-01-01, set the parameter to 2023-01-01.

7. After executing the process, check that the MCAL_NUM column on the row where MCAL_TYPE = 'DT' has the same value as the parameter you set, and that MCAL_NEXT_NUM points to the next day correctly.

   select * from W_RTL_CURR_MCAL_G

   If you hit any issues, run the process again.

---

Related

• Calendar initialization using MFCS integration

Reference

• Oracle RAP — Manage system data (business date)
• Local mirror: AI Foundation Operations Guide — 2 AI Foundation Data Standalone Processes