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.

Note:

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.

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

General Notices