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