Oracle's JD Edwards EnterpriseOne does not have a concept of defining the quarters for a fiscal pattern or a fiscal year. Therefore, a configurable flat file is provided to populate quarter information. This configuration file enables you to feed quarter information such as Quarter Number for each period, Quarter Start Date, and Quarter End Date.
For information about how to configure this flat file, see Configuring the file_lkp_fiscal_period_Qtr_Config_jde.csv. Each fiscal pattern can have a varying number of periods as supported by the OLTP. Therefore, the quarter configuration is required for each fiscal year and for each fiscal pattern. The table shows example values specified in file_lkp_fiscal_period_Qtr_Config_jde.csv.
| Fiscal Pattern | Year | Period | QuarterNo | QuarterStart | QuarterEnd |
|---|---|---|---|---|---|
|
F |
4 |
1 |
1 |
6/1/2004 |
8/30/2004 |
|
F |
4 |
2 |
1 |
6/1/2004 |
8/30/2004 |
|
F |
4 |
3 |
1 |
6/1/2004 |
8/30/2004 |
|
F |
4 |
4 |
2 |
9/1/2004 |
11/30/2004 |
|
F |
4 |
5 |
2 |
9/1/2004 |
11/30/2004 |
|
F |
4 |
6 |
2 |
9/1/2004 |
11/30/2004 |
|
F |
4 |
7 |
3 |
12/1/2004 |
2/28/2005 |
|
F |
4 |
8 |
3 |
12/1/2004 |
2/28/2005 |
|
F |
4 |
9 |
3 |
12/1/2004 |
2/28/2005 |
|
F |
4 |
10 |
4 |
3/1/2005 |
3/31/2005 |
|
F |
4 |
11 |
4 |
3/1/2005 |
3/31/2005 |
|
F |
4 |
12 |
4 |
3/1/2005 |
3/31/2005 |
|
F |
4 |
13 |
4 |
3/1/2005 |
3/31/2005 |
|
F |
4 |
14 |
4 |
3/1/2005 |
3/31/2005 |
For each fiscal year in the F0008 table, you must define the quarters for each fiscal period. The quarter information is used in the calculation of aggregates by quarter. The W_MCAL_CONTEXT_G table in the Oracle Business Analytics Warehouse stores calendars associated with the ORG ID, Ledger ID, and Operating Unit columns.
In Oracle's JD Edwards EnterpriseOne, the fiscal date patterns are associated with the company which forms the ORG_ID and LEDGER_ID.
The W_MCAL_CAL_D table stores the calendar information. Every distinct Fiscal Date Pattern stored in the Fiscal Date Pattern table (F0008) has an entry in this table. The grain of this dimension is the Date Pattern Type, which identifies the Calendar in the Oracle Business Analytics Warehouse. This dimension does not have an association with the Fiscal year for that pattern. The MCAL_CAL_WID column is a four digit number that is reset to 1000 each time the ETL is run and incremented by one for each date pattern type stored in W_MCAL_CAL_D.