Example of Standard Balances
You have loaded your Oracle E-Business Suite Release 12 balances into your new Oracle General Ledger standard balances cube. Now you want to query the results to verify that the data was loaded correctly.
Scenario
The tables show the amounts loaded into the balances cube from your R12 balances and the calculated balances for:
-
Ending balance
-
Year to date (YTD)
-
Quarter to date (QTD
The first table is the balance sheet-based balances and the second table is for income statement-based balances.
E-Business Suite R12 Balances
The following table shows the beginning balance sheet balances, activity, ending balances, and YTD and QTD amounts, for each month.
Month |
Beginning Balance Loaded to Cube |
Activity Loaded to Cube |
Ending Balance |
Calculated YTD |
QTD |
---|---|---|---|---|---|
Jan |
200 |
20 |
220 |
20 |
20 |
Feb |
220 |
30 |
250 |
50 |
50 |
Mar |
250 |
25 |
275 |
75 |
75 |
Apr |
275 |
50 |
325 |
125 |
50 |
May |
325 |
40 |
365 |
165 |
90 |
Jun |
365 |
45 |
410 |
210 |
135 |
Jul |
410 |
100 |
510 |
310 |
100 |
Aug |
510 |
200 |
710 |
510 |
300 |
Sep |
710 |
140 |
850 |
650 |
440 |
Oct |
850 |
150 |
1000 |
800 |
150 |
Nov |
1000 |
100 |
1100 |
900 |
250 |
Dec |
1100 |
400 |
1500 |
1300 |
650 |
The following table shows the beginning income statement balances, activity, ending balances, and YTD and QTD amounts, for each month.
Month |
Beginning Balance Loaded to Cube |
Activity Loaded to Cube |
Ending Balance |
Calculated YTD |
QTD |
---|---|---|---|---|---|
Jan |
0 |
70 |
70 |
70 |
70 |
Feb |
70 |
20 |
90 |
90 |
90 |
Mar |
90 |
30 |
120 |
120 |
120 |
Apr |
120 |
100 |
220 |
220 |
100 |
May |
220 |
200 |
420 |
420 |
300 |
Jun |
420 |
250 |
670 |
670 |
550 |
Jul |
670 |
50 |
720 |
720 |
50 |
Aug |
720 |
300 |
1020 |
1020 |
350 |
Sep |
1020 |
130 |
1150 |
1150 |
480 |
Oct |
1150 |
110 |
1260 |
1260 |
110 |
Nov |
1260 |
200 |
1460 |
1460 |
310 |
Dec |
1460 |
500 |
1960 |
1960 |
810 |
These two tables show the results available from General Ledger from your R12 loaded and aggregated balances in the balances cube.
General Ledger Balances
The following table shows the results for the balance sheet balances in the balances cube.
Accounting Period |
Balance Amount |
Amount Type |
Value |
Comments |
R12 Amount Type Equivalent |
---|---|---|---|---|---|
May |
Beginning Balance |
YTD |
200 |
Jan Beginning Balance |
Not Applicable |
May |
Period Activity |
YTD |
165 |
Jan to May Activity |
YTD-Actual as of May |
May |
Ending Balance |
YTD |
365 |
May Ending Balance |
YTD-Actual as of May |
May |
Beginning Balance |
QTD |
275 |
Apr Beginning Balance |
Not Applicable |
May |
Period Activity |
QTD |
90 |
Apr-May Activity |
QTD-Actual as of May |
May |
Ending Balance |
QTD |
365 |
May Ending Balance |
QTD-Actual as of May |
May |
Beginning Balance |
PTD |
325 |
May Beginning Balance |
Not Applicable |
May |
Period Activity |
PTD |
40 |
May Activity |
PTD-Actual as of May |
May |
Ending Balance |
PTD |
365 |
May Ending Balance |
PTD-Actual as of May |
May |
Beginning Balance |
Base |
325 |
May Beginning Balance |
Not Applicable |
May |
Period Activity |
Base |
40 |
May Activity |
PTD-Actual as of May |
May |
Ending Balance |
Base |
365 |
May Ending Balance |
YTD-Actual as of May |
Q2 |
Beginning Balance |
QTD |
275 |
April Beginning Balance |
Not Applicable |
Q2 |
Period Activity |
QTD |
135 |
Always Apr-Jun |
QTD-Actual as of Jun |
Q2 |
Ending Balance |
QTD |
410 |
Ending Balance always as of Jun |
QTD-Actual as of Jun |
Q2 |
Ending Balance |
YTD |
410 |
Ending Balance always as of Jun |
YTD-Actual as of Jun |
Q2 |
Beginning Balance |
Base |
275 |
Apr Beginning Balance |
Not Applicable |
Q2 |
Period Activity |
Base |
135 |
Always Apr-Jun |
QTD-Actual as of Jun |
Q2 |
Ending Balance |
Base |
410 |
Ending Balance always as of Jun |
YTD-Actual as of Jun |
Year |
Beginning Balance |
YTD |
200 |
Jan Beginning Balance |
Not Applicable |
Year |
Period Activity |
YTD |
1300 |
Jan-Dec Activity |
YTD-Actual as of Dec |
Year |
Ending Balance |
YTD |
1500 |
Ending Balance always as of Dec |
YTD-Actual as of Dec |
Year |
Beginning Balance |
Base |
200 |
Jan Beginning Balance |
Not Applicable |
Year |
Period Activity |
Base |
1300 |
Jan-Dec Activity |
YTD-Actual as of Dec |
Year |
Ending Balance |
Base |
1500 |
Ending Balance always as of Dec |
YTD-Actual as of Dec |
The following table shows the results for the income statement balances.
Accounting Period |
Balance Amount |
Amount Type |
Value |
Comments |
R12 Amount Type Equivalent |
---|---|---|---|---|---|
May |
Beginning Balance |
YTD |
0 |
Jan Beginning Balance |
Not Applicable |
May |
Period Activity |
YTD |
420 |
Jan to May Activity |
YTD-Actual as of May |
May |
Ending Balance |
YTD |
420 |
May Ending Balance |
YTD-Actual as of May |
May |
Beginning Balance |
QTD |
120 |
Apr Beginning Balance |
Not Applicable |
May |
Period Activity |
QTD |
300 |
Apr-May Activity |
QTD-Actual as of May |
May |
Ending Balance |
QTD |
420 |
May Ending Balance |
QTD-Actual as of May |
May |
Beginning Balance |
PTD |
220 |
May Beginning Balance |
Not Applicable |
May |
Period Activity |
PTD |
200 |
May Activity |
PTD-Actual as of May |
May |
Ending Balance |
PTD |
420 |
May Ending Balance |
PTD-Actual as of May |
May |
Beginning Balance |
Base |
220 |
May Beginning Balance |
Not Applicable |
May |
Period Activity |
Base |
200 |
May Activity |
PTD-Actual as of May |
May |
Ending Balance |
Base |
420 |
May Ending Balance |
YTD-Actual as of May |
Q2 |
Beginning Balance |
QTD |
120 |
Apr Beginning Balance |
Not Applicable |
Q2 |
Period Activity |
QTD |
550 |
Period Activity Always Apr-Jun |
QTD-Actual as of Jun |
Q2 |
Ending Balance |
QTD |
670 |
Ending Balance always as of Jun |
QTD-Actual as of Jun |
Q2 |
Ending Balance |
YTD |
670 |
Ending Balance always as of Jun |
YTD-Actual as of Jun |
Q2 |
Beginning Balance |
Base |
120 |
Apr Beginning Balance |
Not Applicable |
Q2 |
Period Activity |
Base |
550 |
Period Activity always Apr-Jun |
QTD-Actual as of Jun |
Q2 |
Ending Balance |
Base |
670 |
Ending Balance always as of Jun |
YTD-Actual as of Jun |
Year |
Beginning Balance |
YTD |
0 |
Jan Beginning Balance (always zero for Income Statement) |
Not Applicable |
Year |
Period Activity |
YTD |
1960 |
Jan-Dec Activity |
YTD-Actual as of Dec |
Year |
Ending Balance |
YTD |
1960 |
Ending Balance always as of Dec |
YTD-Actual as of Dec |
Year |
Beginning Balance |
Base |
0 |
Jan Beginning Balance (always zero for Income Statement) |
Not Applicable |
Year |
Period Activity |
Base |
1960 |
Jan-Dec Activity |
YTD-Actual as of Dec |
Year |
Ending Balance |
Base |
1960 |
Ending Balance always as of Dec |
YTD-Actual as of Dec |