Aggregation Processes in Planning and Budgeting Financials
After you update any forecast data on a data entry form, you should aggregate your application. Aggregate the application to see the impacts of your changes on the financial statements at the upper levels of all dimensions.
There are different aggregation processes that you can access in each form, and each aggregation process corresponds to specific rulesets and business rules. To run an aggregation from a data entry form, right-click in the form's data grid, and then select the desired aggregation process from the menu.
The aggregation processes in the action menu only apply your data changes to the financial statements in input currency. They do not apply your changes to reporting currencies.
Furthermore, there are additional rulesets not available in your data entry forms that you should also run to refresh the data in your financial statements. The subsequent table lists these rulesets in the Additional Rulesets to Update Financial Statements column. To run these rulesets, go to the Rules card. For information about how to run these rulesets, see the help topic Launching Business Rules in the Oracle Help Center.
Forms that update Income Statement accounts or the Gross Margin Pct account impact the Income Statement, the Balance Sheet, and the Statement of Cash Flows. Forms that update Balance Sheet accounts do not impact the Income Statement but do impact the Balance Sheet and the Statement of Cash Flows.
The following table summarizes the aggregation processes that are accessible in each form and the rulesets that you should execute from the Rules card.
|
Folder |
Form |
Aggregation Process in Action Menu (Label in Planning and Budgeting) |
Ruleset and Rules in Action Menu |
Additional Rulesets from Rules Card |
|---|---|---|---|---|
|
Admin |
NFS_Days in Month |
— |
Rule: NFS_Form_DiM |
NFS_BS Forecast Data |
|
NFS_Exchange Rates Forecast |
— |
— |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Exchange Rates to Reporting Currency |
— |
— |
NFS_All Accts Forecast Data Refresh |
|
|
Planning -Financials -Balance Sheet |
NFS_Balance Sheet -Account Detail |
— |
— |
— |
|
NFS_Balance Sheet -Monthly Movements Report |
NFS_BS_Forecast_Data Refresh (BS Forecast Data Refresh) |
Ruleset: NFS_BS Forecast Data Refresh Rules:
|
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Balance Sheet Report |
NFS_BS_Forecast_Data Refresh (BS Forecast Data Refresh) |
Ruleset: NFS_BS Forecast Data Refresh Rules:
|
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Balance Sheet Report -Group Consolidated |
NFS_BS_Forecast_Data Refresh (BS Forecast Data Refresh) |
Ruleset: NFS_BS Forecast Data Refresh Rules:
|
NFS_All Accts Forecast Data Refresh |
|
|
Planning -Financials -Balance Sheet Trending |
NFS_Balance Sheet Monthly Movement Adj |
NFS_Agg to Balance Sheet (Aggregate to Balance Sheet) |
Rule: NFS_AGG -BalSht -Forecast |
NFS_All Accts Forecast Data Refresh |
|
NFS_Days Inventory Outstanding |
NFS_Agg to Balance Sheet (Aggregate to Balance Sheet) |
Rule: NFS_AGG -BalSht -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Days Payable Outstanding |
NFS_Agg to Balance Sheet (Aggregate to Balance Sheet) |
Rule: NFS_AGG -BalSht -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Days Sales Outstanding |
NFS_Agg to Balance Sheet (Aggregate to Balance Sheet) |
Rule: NFS_AGG -BalSht -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
Planning -Financials -Cash Flow |
NFS_Cash Flow |
NFS_All Accts Bud Data Refrsh (All Accts Bud Data Refresh) |
Ruleset: NFS_All Accts Forecast Data Refresh Rules:
|
— |
|
NFS_Cash Flow -Group Consolidated |
NFS_All Accts Bud Data Refrsh (All Accts Bud Data Refresh) |
Ruleset: NFS_All Accts Forecast Data Refresh Rules:
|
— |
|
|
Planning -Financials -Income Statement |
NFS_Income Statement |
NFS_IS Forecast Data Refresh (IS Forecast Data Refresh) |
Ruleset: NFS_IS Forecast Data Refresh Rules:
|
NFS_BS Forecast Data Refresh NFS_All Accts Forecast Data Refresh |
|
NFS_Income Statement -Account Details |
— |
— |
— |
|
|
NFS_Income Statement Adj |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Income Statement Subsidiary Consolidated |
NFS_IS Forecast Data Refresh (IS Forecast Data Refresh) |
Ruleset: NFS_IS Forecast Data Refresh Rules:
|
NFS_All Accts Forecast Data Refresh |
|
|
Planning -Financials -Trial Balance |
NFS_Trial Balance |
NFS_All Accts Bud Data Refrsh (All Accts Bud Data Refresh) |
Ruleset: NFS_All Accts Forecast Data Refresh Rules:
|
NFS_IS Forecast Data Refresh NFS_BS Forecast Data Refresh |
|
Planning -OpEx |
NFS_OpEx by Dept |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
NFS_OpEx by Dept Account Details |
— |
— |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_OpEx Detail |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_OpEx Predictive and GridSpread |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_OpEx Top Level Adj |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
Planning -Revenue & Gross Margin |
NFS_Gross Margin Pct |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
NFS_Revenue -New Customer by Account |
— |
— |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Revenue Account Details |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Revenue by Customer |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Revenue by Item |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Revenue Predictive and GridSpread |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |
|
|
NFS_Revenue Top Level Adjustment |
NFS_Agg to Income Stmt (Aggregate to Income Statement) |
Rule: NFS_AGG -IncStmt -Forecast |
NFS_All Accts Forecast Data Refresh |