About Configuring Quarters for Fiscal Time Dimensions for EnterpriseOne
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.
file_lkp_fiscal_period_Qtr_Config_jde.csv
.
Note:
If you are deploying OTBI-Enterprise, then you must download the CSV files from Configuration Manager, as follows: 1. From the Tasks bar, click Define Business Intelligence Applications. 2. Click Actions, then Manage Source Configuration Data Files. 3. Click the Export Source Configuration Data Files option on the tool bar. 4. Move the required files to the right hand list, then click Export.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.