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. To run these rulesets, go to the Rules card. For information about how to run the 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.
|
Form |
Aggregation Process in Action Menu |
Additional Rulesets from Rules Card |
|---|---|---|
|
Days in Month |
— |
NFS_BS Forecast Data |
|
Exchange Rates Forecast |
— |
NFS_All Accts Forecast Data Refresh |
|
Exchange Rates to Reporting Currency |
— |
NFS_All Accts Forecast Data Refresh |
|
Balance Sheet - Account Detail |
— |
— |
|
Balance Sheet - Monthly Movements Report |
BS Forecast Data Refresh |
NFS_All Accts Forecast Data Refresh |
|
Balance Sheet Report |
BS Forecast Data Refresh |
NFS_All Accts Forecast Data Refresh |
|
Balance Sheet Report - Group Consolidated |
BS Forecast Data Refresh |
NFS_All Accts Forecast Data Refresh |
|
Balance Sheet Movement Adj |
Aggregate to Balance Sheet |
NFS_All Accts Forecast Data Refresh |
|
Days Inventory Outstanding |
Aggregate to Balance Sheet |
NFS_All Accts Forecast Data Refresh |
|
Days Payable Outstanding |
Aggregate to Balance Sheet |
NFS_All Accts Forecast Data Refresh |
|
Days Sales Outstanding |
Aggregate to Balance Sheet |
NFS_All Accts Forecast Data Refresh |
|
Cash Flow |
All Accts Fcst Data Refresh |
— |
|
Cash Flow - Group Consolidated |
All Accts Fcst Data Refresh |
— |
|
Income Statement |
IS Forecast Data Refresh |
NFS_All Accts Forecast Data Refresh |
|
Income Statement - Account Details |
— |
— |
|
Income Statement Adj |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
Income Statement Subsidiary Consolidated |
IS Forecast Data Refresh |
NFS_All Accts Forecast Data Refresh |
|
Trial Balance |
All Accts Fcst Data Refresh |
NFS_IS Forecast Data Refresh NFS_BS Forecast Data Refresh |
|
OpEx by Dept |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
OpEx by Dept Account Details |
— |
NFS_All Accts Forecast Data Refresh |
|
OpEx Detail |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
OpEx Predictive and GridSpread |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
OpEx Top Level Adj |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
Gross Margin Pct |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
Revenue - New Customer by Account |
— |
NFS_All Accts Forecast Data Refresh |
|
Revenue Account Details |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
Revenue by Customer |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
Revenue by Item |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
Revenue Predictive and GridSpread |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |
|
Revenue Top Level Adjustment |
Aggregate to Income Statement |
NFS_All Accts Forecast Data Refresh |