Aggregation Processes in Planning and Budgeting Financials
After you update any forecast data on a data entry form, you should aggregate your application. Aggregating lets you see the how your changes affect the financial statements at the upper levels of all dimensions.
Each form has different aggregation processes, and each process runs specific rulesets and business rules. To run an aggregation from a form, right-click in the form's data grid, and then select the aggregation process that you want from the menu.
The aggregation processes in the action menu only apply your data changes to the financial statements in input currency. They don't apply your changes to reporting currencies.
There are additional rulesets that you can't run from your forms that you should 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 them, go to the Rules card. For details, see the help topic Launching Business Rules in the Oracle Help Center.
Forms that update Income Statement accounts or the Gross Margin Pct account affect the Income Statement, the Balance Sheet, and the Statement of Cash Flows. Forms that update Balance Sheet accounts don't affect the Income Statement, but they do affect the Balance Sheet and the Statement of Cash Flows.
The following table summarizes the aggregation processes that you can use in each form and the rulesets that you should run 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 |