This chapter tells you how to use Cash Forecasting. It explains how to create cash forecast templates, generate cash forecasts from those templates, and make changes to those templates and forecasts.
This chapter covers the following topics:
Cash forecasting is a planning tool that helps you anticipate the flow of cash in and out of your business, allowing you to project your cash needs and evaluate your company's liquidity position.
Refer to the following sections in this chapter for details on how to accomplish various cash forecasting tasks:
Viewing Cash Forecast Results
Related Topics
A template contains cash forecast specifications. You can specify the number and type of rows and columns to create custom forecast templates. Templates determine the presentation of sources (rows) and forecast periods (columns) for your cash forecasts. Templates also include the following types of general information:
Name and description
Forecast period types, either GL periods or days
Each row contains a source type, such as Supplier Invoices, and selection criteria, for example:
Ledger
Pay group
Bank account
You can specify how to organize cash forecast information, including which sources supply forecast data (rows), and for which forecast periods (columns) you are generating data. For more information on source type specifications, refer to Forecast Template Rows Page Reference
Once a template definition is complete, you can submit a request to produce timely cash forecasts. This process gathers current source information from the selected Oracle Applications.
The External Cashflow Open Interface allows you to utilize external sources of cash inflow and outflow data for the Cash Forecasting feature, providing you an enterprise-wide cash forecasting solution on a distributed database environment.
You define your templates to include the Open Interface Inflow and Open Interface Outflow source types. You can then generate a cash forecast and Cash Management automatically retrieves information available from the external forecast sources you have defined.
Navigate to the Forecast Templates Search and Results page.
Click the Create Template button.
In the Header Details page, enter a unique name for your template.
Select a forecast period type of Days or GL Periods in the Forecast By field.
(Optional) Enter a description for your template.
Choose Include or Exclude in the Overdue Transactions field to determine whether to include or exclude open transactions that have a cash activity date before the forecast start date. Overdue transactions are collected into one forecast period, displayed as the Overdue column in the Cash Forecast Results page and the Cash Forecast Report.
If you chose to include overdue transactions, you must enter a value in the Cutoff Period field. The cutoff period determines how far back to include overdue transactions.
Note: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long and you are including many historical transactions, then the forecasts may take longer to generate.
Please ensure that the cutoff period does not exceed more than 18 periods.
Choose a transaction calendar in the Business Calendar field. If you do not choose a calendar in this field, then cash activity dates used in forecasting can be non-business days.
(Optional) To generate a forecast for a project, enter a starting and ending project number. Cash Management generates a forecast for each project in the range.
Click the Next button to navigate to the Row Details page.
To enter Rows, select the source type for the rows you want to add and click Go.
In the Create Forecast Template Row page, you must enter the following:
Enter a Row Number to specify the sequence of the source types. Values must be unique integers between 1 and 999. The Row Number indicates the sequence of the rows (source types) in the forecast.
Enter relevant selection criteria for the source type chosen in the Forecast Template Rows Detail page. See: Forecast Template Rows Page Reference, for information on the applicable and required fields for each source type.
To continue adding rows, select the source type for the rows you want to add and click Go.
Once you have finished adding rows, click Apply. The Row Details page appears, and the rows you have added are displayed.
Click the Next button to navigate to the Column Details page.
If you are setting up forecast columns by days, you can choose to set up the forecast columns manually or automatically.
If you choose to set up your columns manually, enter a Column Number to specify the sequence of the columns (forecast periods). Values must be integers between 1 and 999. The Column Number indicates the sequence of the columns in the forecast.
Note: You can define up to 80 columns in a forecast template.
Enter the From and To specifications as periods or days, depending on what you entered in the Forecast by Field in the Headers Details page. The values must be integers between 1 and 999. The From value must be less than or equal to the To value.
Note: These numbers define the forecast periods by indicating the specific date or period ranges for each column. If a template is defined by GL periods, each column represents one or more GL periods. When submitting a forecast, you specify a start period for a template defined by GL periods, and you specify a start date for templates defined by Days. See: Submission Parameters
To create forecast columns automatically, select the Automatic option and click Go. This option is not available for Forecast by GL Periods.
Enter a value in the Column Sequence field to indicate the order in which this column should be displayed in the cash forecast. Select a value in the Summary Level field from the options of Daily or Weekly to indicate the length of each forecast period. Enter a value in the Duration field. This value must be a positive integer. Select a value in the Duration Type field from the options of Days and Weeks. The combination of the values entered in the Duration field, along with the option selected in the Duration Type field, determines the length of your forecast horizon. For example, a column sequence of 10, summary level of Daily, Duration of 5, and Duration Type of Days will create 5 daily buckets in your forecast.
Related Topics
Forecast Template Rows Page Reference
Generating Cash Forecasts from Templates
External Cashflow Open Interface
Defining Transaction Calendars, Oracle General Ledger Implementation Guide
When Cash Management collects the source data for a forecast, it includes source transactions whose cash activity date falls within the days or period ranges you defined. Cash Management searches for a valid date in the sequence indicated, using the first date it finds. Cash Management adds the lead time to dates, except for GL Budgets and GL Encumbrances.
The following table explains which date is used as the expected cash activity date.
| Type | Expected Cash Activity Date or Time |
|---|---|
| Supplier Payments (Future) | 1. Value Date (Actual then Anticipated), 2. Maturity Date, or 3. Payment Date |
| Expense Reports | 1. Period Ending Date |
| Customer Receipts (Future) | 1. Value Date (Actual then Anticipated), 2. Maturity Date, or 3. Latest Receipt Transaction Date |
| Supplier Invoices | Discount Deadline if Discount field is Maximum or Minimum; or Due Date if Discount field is None |
| Supplier Payments (Historical) | Cleared Date or Value Date (your choice), rolled forward by amount specified on cash forecast template |
| Customer Invoices | Due Date or Invoice Date plus Average Payment Days |
| Customer Receipts (Historical) | Cleared Date or Value Date (your choice), rolled forward by amount specified on cash forecast template |
| GL Budgets | Forecast period type must be GL Period; corresponding periods included |
| GL Encumbrances | Forecast period type must be GL Period; corresponding periods included |
| Payroll Expenses (Historical) | Payment Date, rolled forward by amount specified on cash forecast template |
| Project Billing Events | Event Completion Date |
| Project Inflow Budgets | Calculated based on Start Date and End Date of budget period |
| Project Outflow Budgets | Calculated based on Start Date and End Date of budget period |
| Project Transactions | Expenditure Item Date |
| Purchase Orders | Releases: 1. Shipment Promised Date or Shipment Promised Date plus Payment Terms 2. Shipment Need By Date or Shipment Need By Date plus Payment Terms 3. Release Due Date or Release Due Date plus Payment Terms 4. Release Created Date or Release Created Date plus Payment Terms Standard POs: 1. Shipment Promised Date or Shipment Promised Date plus Payment Terms 2. Shipment Need By Date or Shipment Need By Date plus Payment Terms 3. Shipment Created Date or Shipment Created Date plus Payment Terms |
| Purchase Requisitions | 1. Requisition Line Need By Date, or 2. Requisition Line Created Date |
| Sales Opportunities | 1. Line Decision Date, 2. Header Decision Date |
| Sales Orders | Ordered Date, Requested Date, Ordered Date plus Payment Terms, or Requested Date plus Payment Terms (1. line level, 2. header level) |
| Treasury Inflow | Settlement Date |
| Treasury Outflow | Settlement Date |
You have the flexibility to include or exclude overdue transactions for all appropriate source transaction types in your cash forecasts. Including overdue transactions gives you an accurate representation of potential cash inflows and outflows. Overdue transactions are open transactions with a cash activity date before the forecast start date.
Overdue transactions are collected into one forecast period, displayed as the Overdue column in the Cash Forecast Results page and the Cash Forecast Report.
Overdue transactions apply to the source types described below. You can specify on each forecast template whether to include overdue transactions. If you choose to do so, you must also specify the Cutoff Period, which determines how far back in time to include overdue transactions.
The following table contains cash forecasting overdue transaction sources:
| Type | Definition |
|---|---|
| Supplier Payments (Future) | Payments scheduled to have been cleared before the forecast start date or period, but that are still uncleared. |
| Expense Reports | Uninvoiced expense reports with a cash activity date before the forecast start date or period. |
| Customer Receipts (Future) | Receipts scheduled to have been cleared before the forecast start date or period, but that are still uncleared. |
| Supplier Invoices | Invoices that were scheduled to be paid before the forecast start date or period, but are still unpaid. |
| Customer Invoices | Invoices that were scheduled to have been paid before the forecast start date or period, but are still not paid. |
| Purchase Orders | Uninvoiced purchase orders with a cash activity date before the forecast start date or period. |
| Purchase Requisitions | Unordered requisitions with a cash activity date before the forecast start date or period. |
| Sales Orders | Uninvoiced sales orders with a cash activity date before the forecast start date or period. |
| Open Interface | User-defined. |
| Sales Opportunities | Sales that have not yet been ordered with a cash activity date before the forecast start date or period. |
The following table contains the legend for the Cash Inflow Source Types table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| (blank) = Not applicable | API = Supplier Invoices | PAB = Project Billing Events |
| D = Display only | APP = Supplier Payments | PAI = Project Inflow Budgets |
| R = Required | APX = Expense Reports | PAO = Project Outflow Budgets |
| O = Optional | ARI = Customer Invoices | PAT = Project Transactions |
| H = Required if Method is Historical | ARR = Customer Receipts | PAY = Payroll Expenses |
| F = Required is Method is Future | ASF = Sales Opportunities | POP = Purchase Orders |
| N = Required if Use Average Payment Days is No | GLB = GL Budgets | POR = Purchase Requisitions |
| Y = Required if Use Average Payment Days is Yes | GLE = GL Encumbrances | XTRI = Treasury Inflow |
| OEO = Sales Orders | XTRO = Treasury Outflow | |
| UDI = User-defined Inflow | OII = Open Interface Inflow | |
| UDO = User-defined Outflow | OIO = Open Interface Outflow |
The following table displays characteristics, such as required or optional, of the applicable fields for each source type you can enter in the Forecast Template Rows page.
| ARI | ARR | ASF | GLB | OEO | PAB | PAI | XTRI | UDI | OII | |
|---|---|---|---|---|---|---|---|---|---|---|
| Row Number | R | R | R | R | R | R | R | R | R | R |
| Source Type | D | D | D | D | D | D | D | D | D | D |
| Description | O | O | O | O | O | O | O | O | O | O |
| Company | O | |||||||||
| Operating Unit | O | O | O | O | O | |||||
| Ledger | O | O | O | R | O | O | O | |||
| Date Type | H | R | ||||||||
| Bank Account | O | O | ||||||||
| Method | R | |||||||||
| Roll Forward Type | H | |||||||||
| Roll Forward Period | H | |||||||||
| Receipt Method | O | |||||||||
| Customer Profile Class | O | O | ||||||||
| Include Dispute? | R | |||||||||
| Budget Name | R | |||||||||
| GL Account | R | |||||||||
| Use Average Payment Days? | R | |||||||||
| Period | Y | |||||||||
| Lead Time | N | F | R | R | R | R | R | |||
| Use Payment Terms? | R | |||||||||
| Order Type | O | |||||||||
| Sales Stage | O | |||||||||
| Channel | O | |||||||||
| Win Probability | O | |||||||||
| Status | O | O | ||||||||
| Transaction Type | O | |||||||||
| Include Indicative Exposure | R | |||||||||
| Budget Type | R | |||||||||
| Budget Version | R | |||||||||
| External Source Type | R | |||||||||
| Forecast Selection Criteria Descriptive Flexfield | O | |||||||||
| Descriptive Flexfield | O | O | O | O | O | O | O | O | O | O |
The following table contains the legend for the Cash Outflow Source Types table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| (blank) = Not applicable | API = Supplier Invoices | PAB = Project Billing Events |
| D = Display only | APP = Supplier Payments | PAI = Project Inflow Budgets |
| R = Required | APX = Expense Reports | PAO = Project Outflow Budgets |
| O = Optional | ARI = Customer Invoices | PAT = Project Transactions |
| H = Required if Method is Historical | ARR = Customer Receipts | PAY = Payroll Expenses |
| F = Required if Method is Future | ASF = Sales Opportunities | POP = Purchase Orders |
| N = Required if Use Average Payment Days is No | GLB = GL Budgets | POR = Purchase Requisitions |
| Y = Required if Use Average Payment Days is Yes | GLE = GL Encumbrances | XTRI = Treasury Inflow |
| OEO = Sales Orders | XTRO = Treasury Outflow | |
| UDI = User-defined Inflow | OII = Open Interface Inflow | |
| UDO = User-defined Outflow | OIO = Open Interface Outflow |
The following table displays characteristics, such as required or optional, of the applicable fields for each source type you can enter in the Forecast Template Rows page.
| API | APP | APX | GLB | GLE | PAO | PAT | PAY | POP | POR | XTRO | UDO | OIO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Row Number | R | R | R | R | R | R | R | R | R | R | R | R | R |
| Source Type | D | D | D | D | D | D | D | D | D | D | D | D | D |
| Description | O | O | O | O | O | O | O | O | O | O | O | O | O |
| Company | O | ||||||||||||
| Business Group | O | ||||||||||||
| Operating Unit | O | O | O | O | O | O | |||||||
| Ledger | O | O | O | R | R | O | O | O | O | ||||
| Payroll Name | O | ||||||||||||
| Discount | R | ||||||||||||
| Pay Group | O | O | |||||||||||
| Payment Priority | O | O | |||||||||||
| Supplier Type | O | O | |||||||||||
| Payment Method | O | O | |||||||||||
| Bank Account | O | O | O | ||||||||||
| Method | R | R | |||||||||||
| Date Type | H | R | |||||||||||
| Use Payment Terms | R | R | |||||||||||
| Roll Forward Type | H | R | |||||||||||
| Roll Forward Period | H | R | |||||||||||
| Budget Name | R | ||||||||||||
| Include Transactions On Hold? | R | R | |||||||||||
| GL Account | R | R | |||||||||||
| Encumbrance Type | R | ||||||||||||
| Include Indicative Exposure? | R | ||||||||||||
| Lead Time | R | F | R | R | R | R | R | ||||||
| Status | O | O | |||||||||||
| Transaction Type | O | ||||||||||||
| Budget Type | R | ||||||||||||
| Budget Version | R | ||||||||||||
| Include Temporary Labor? | R | R | |||||||||||
| External Source Type | R | ||||||||||||
| Forecast Selection Criteria Descriptive Flexfield | O | ||||||||||||
| Descriptive Flexfield | O | O | O | O | O | O | O | O | O | O | O | O | O |
Use this section along with the Inflow Source Type and Outflow Source Type tables on the previous pages as references when you create forecast templates. You can create multiple forecast templates with a wide variety and combination of source types. The following fields allow you to control the search for data by entering source type information, or by leaving a field blank.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria. You can choose to display or hide this field in the Cash Forecast Results page when you are updating or viewing a cash forecast.
Business Group/Company/Operating Unit: (Optional) An organization that you want to forecast on for the chosen source type. You can have multiple instances of a source type in your forecast, each for a different organization, or one instance to represent all organizations. Leave this field blank to collect source data for all organizations.
When the source type is Payroll Expenses, the field is actually the Business Group, and the list of values displays appropriate Business Groups for Oracle Payroll. When the source type is Treasury Inflow or Treasury Outflow, the field is Company. For all other source types, this field is the Operating Unit.
Ledger: The name of the ledger is required for GL Budgets, and GL Encumbrances. If you selected an organization in the previous field, the list of values for the Ledger field is restricted to the ledger for that organization.
Note: If you are creating a forecast by GL periods across multiple organizations or ledgers, all organizations' ledgers must use the same accounting calendar. You select the accounting calendar when you submit a forecast by GL Period.
Payroll Name: (Optional) Indicates the name of the payroll to include in the cash forecast. Leave this field blank to forecast cash flow from all payrolls.
Discount: Indicates whether to include discounts, and how to calculate the expected cash activity date for Supplier Invoices. Choose from the following:
Maximum: Always take the maximum discount available, subtract the discount from the gross invoice amount, and use the discount deadline as the expected cash activity date.
Minimum: Always take the minimum discount available, subtract the discount from the gross invoice amount, and use the discount deadline as the expected cash activity date.
None: Pay the entire invoice amount by the due date, and use the due date as the expected cash activity date.
Pay Group: (Optional) A user-defined Payables lookup that allows grouping of suppliers for payment. You can limit Supplier Invoices and Purchase Orders to those belonging to a certain pay group.
Payment Priority: (Optional) A number, between 1 (high) and 99 (low). Only supplier invoices or purchase orders with a payment priority the same as or smaller than the number you enter in this field are included in the cash forecast. For example, if you enter 15, Cash Management includes all invoices or purchase orders with a payment priority between 1 and 15.
Supplier Type: (Optional) A user-defined Payables lookup that allows supplier classification for Supplier Invoices and Purchase Orders.
Payment Method: (Optional) The method of payment for the source type. The list of values depends on the source type:
For Supplier Payments: The payment methods predefined in Oracle Payables for how suppliers' invoices can be paid. Choices include: Check, Electronic, Wire, Future Dated, Manual Future Dated, and Clearing.
For Payroll Name: The predefined and user-defined payment methods in Oracle Payroll for how employees' payroll can be paid. Predefined choices include: Cash, Check, and NACHA (National Automated Clearing House Association).
For Customer Receipts: The user-defined Receivables choice to account for receipt entries and applications.
Bank Account: (Optional) The bank account whose transactions you want to include in the cash forecast. The list of values is controlled by CE: Bank Account Security profile option. See: Profile Options in Cash Management.
Method: Specifies cashflow transactions as forward- or backward looking for Supplier Payments, Customer Receipts, and Payroll Expenses. For Payroll Expenses, this field defaults to Historical as Payroll Expenses forecasts are based solely on historical payments.
Future: Include uncleared transactions.
Historical: Include cleared transactions based on the cleared date or value date. You choose either Cleared Date or Value Date from the Date Type column on the Forecast Template Rows window.
Roll Forward Type: and Roll Forward Period: (Required only when you choose Historical in the Method field) The combination of these fields determines the number of days, months, or accounting periods to roll forward to calculate the expected cash activity date for Supplier Payments, Customer Receipts, and Payroll Expenses. Roll Forward Type choices include: Day, Month, and Period.
For example, the Roll Forward Type of Month with the Roll Forward Period of 2 rolls forward all past transactions for 2 months. So, the transaction date of July 19, 1997 yields an expected cash activity date of September 19, 1997.
Profile Class: (Optional) The Order Management and Receivables customer category based on credit information, payment terms, currency limits, and correspondence types. You can use it as forecast selection criteria for Customer Invoices and Sales Orders.
Include Dispute? : (Optional) A check box to indicate inclusion of disputed amounts for Customer Invoices. Items or amounts may be marked as 'in dispute' when a customer disagrees about the outstanding balance for an item.
Budget Name: The name of a budget for GL Budgets. A budget represents a collection of estimated amounts for a range of accounting periods.
GL Account: The appropriate General Ledger account for GL Budgets and GL Encumbrances.
Encumbrance Type: An encumbrance category, for GL Encumbrances, allowing you to track anticipated expenditures according to your purchase approval process and to more accurately control planned expenditures.
Include Transactions On Hold? : (Optional) Indicates if you want to include transactions (invoices, expense reports, etc.) that are on hold.
Use Average Payment Days? : (Optional) Indicates whether you want to forecast Customer Invoices based on the customer's payment pattern. If you select this option, the expected cash activity date is the invoice date plus the average number of days the customer takes to pay their bills according to the customer's payment history.
Period: (Optional) The period on which you want to base your Average Payment Days calculation. The period is in months and the default is twelve months. You can enter a value in this field only if you choose the Use Average Payment Days option.
Lead Time: The number of days that need to be added to the transaction date to calculate the projected cash activity date. The value must be a positive whole number, or zero. For Customer Invoices, this parameter is optional if you choose the Use Average Payment Days option.
Use Payment Terms? : (Optional) Indicates whether you want to use payment terms to calculate the expected cash activity date for Sales Orders and Purchase Orders. If you select this option, the cash activity date for Purchase Orders is the promised date or need by date plus the due days specified in the payment terms. The cash activity date for Sales Orders is the ordered date or requested date plus the due days specified in the payment terms. However, if the payment terms contain a fixed due date, the due date is used as the cash activity date.
Order Type: (Optional) A classification for Sales Orders. In Order Management, this controls an order's workflow activity, order number sequence, credit check point, and transaction type.
Channel Code: The lead channel code for Sales Opportunities.
Win Probability: The win probability, as a percentage, for Sales Opportunities. For example, if you enter 10, you select all sales opportunities with 10% or more of win probabilities.
Authorization Status: (Optional) Indicates the status of transactions to include in the cash forecast.
Sales Order Date: The expected cash activity date to use when calculating forecast amounts.
Include Indicative Exposures: For Treasury Inflow and Outflow, if you select Yes, you can include transactions in the forecast as follows:
Yes: Indicative. Include all transactions including those that may or may not occur.
No: Firm: Include only transactions that definitely have occurred or will occur.
Budget Type: Required for Project Inflow Budgets and Project Outflow Budgets.
Budget Version: The version of the budget type that you selected. You can have many versions of the same budget for a project and budget type, but Cash Management only considers baselined budgets that are identified as the current budget or original budget.
Include Temporary Labor? : Indicate whether to include the line type of temporary labor for the Purchase Order and Purchase Requisition sources.
External Source Type: Indicates the user-defined external forecast source type for Open Interface Inflow or Open Interface Outflow. The list of values is from the Context field of the Forecast Selection Criteria Descriptive Flexfield you created during setup of the External Cashflow Open Interface.
Forecast Selection Criteria: The descriptive flexfield that indicates the external forecast selection criteria based on the External Source Type you entered in the previous field for Open Interface Inflow or Open Interface Outflow sources. The list of values is from the segments you defined for the Forecast Selection Criteria Descriptive Flexfield.
Related Topics
Discounts, Oracle Payables User Guide
Payment Information of the Suppliers and Supplier Sites Window, Oracle Payables User Guide
Receipt Methods, Oracle Receivables Implementation Guide
Defining Customer Profile Classes, Oracle Receivables Implementation Guide
Placing an Item in Dispute, Oracle Receivables User Guide
Defining Accounts, Oracle General Ledger Implementation Guide
Defining Budgets, Oracle General Ledger User's Guide
Defining Encumbrance Types, Oracle General Ledger User's Guide
Defining a Payroll, Oracle HRMS Payroll Processing Management Guide
Payment Methods for Your Enterprise, Oracle HRMS Payroll Processing Management Guide
External Cashflow Open Interface
You can define reusable cash forecast templates for use in generating cash forecasts. A cash forecast template is a matrix, similar to a spreadsheet, with each row defining the source of the cashflow, and each column defining the forecast period in GL periods or in days. When you submit a forecast, you generate exactly the forecast that you need by entering submission parameters, such as start date and forecast currency.
When you submit a cash forecast, Cash Management collects the necessary source data and summarizes the information as cash forecast amounts, based on the forecast period specifications. The forecast data is then available for update, inquiry or reporting purposes, or for export to any spreadsheet application.
Cash Management determines projected cash activity dates based on your specifications. For example, if the source type is Supplier Invoices, the expected cash activity date is based on either the discount date or the due date depending on your selection in the template. Refer to the Cash Forecasting Source Transaction Dates table.
If you have created a forecast template that includes a user-defined source type, Cash Management creates a row that contains zeroes when you generate a cash forecast. If you want to enter amounts manually in the forecast amount cells for user-defined source types, click on the zero in the forecast cell and add transactions in the Source Transactions Details page.
You might generate a new cash forecast because you have created a new template, or because you want to recalculate a forecast with different submission parameters.
You can generate forecasts in the following ways:
Generate a new cash forecast from a template, with forecast amounts calculated automatically.
Query the template in the Forecast Templates Search and Results page, and select the Run Forecast icon
Query a previously run forecast in the Forecast Search and Results page, and select the Run Forecast icon
Using the Submit Request window
Quickly create a manually entered cash forecast, with the rows and columns defined by a template.
You can generate a forecast for a specific project or for a range of projects. If you generate a forecast for a range of projects, Cash Management produces a separate forecast for each project.
To specify projects for your forecast that are different from those on the template, you must complete the starting and ending project numbers on the Submit Forecast window.
If you submit a forecast for a project based on a template that includes some sources types that are related to Projects and others that are not related to Projects, Cash Management produces a forecast that reflects information from only the source types related to Projects.
The External Cashflow Open Interface allows you to utilize external sources of data as cash inflow and outflow data for the Cash Forecasting feature, providing you an enterprise-wide cash forecasting solution on a distributed database environment.
You can generate a cash forecast and the External Cashflow Open Interface automatically retrieves information available from the external forecast sources you have defined.
Set up the External Cashflow Open Interface if you plan to include external sources in your cash forecasts.
Define at least one cash forecast template.
Navigate to the Forecast Templates Search and Results page.
Query an existing forecast template and select the Run Forecast icon that corresponds to the template.
Enter the appropriate parameters and click Submit to generate a new cash forecast.
When you click Submit, you receive a confirmation message in the Forecast Templates Search and Results page. You can then select the View Forecast icon that corresponds to the template to navigate to the Forecast Search and Results page where you can monitor the status of your request.
Navigate to the Forecast Search and Results page.
Query an existing forecast from the Forecast Search and Results page and select the Run Forecast icon.
Enter the appropriate parameters and click Submit to generate a new cash forecast.
When you click Submit, you receive a confirmation message in the Forecast Search and Results page. You can then click the Refresh Processing Status button to monitor the status of your request.
Submit a request for Cash Forecasting by Days or Cash Forecasting by GL Periods in the Submit Request window.
Select any print or run options prior to submission.
Tip: Consider using report sets if you routinely generate a given set of cash forecasts.
Important: If you are generating a cash forecast for a project, you can generate a forecast for a specific project or for a range of projects by entering a starting and ending project number.
Cash Management automatically generates the Cash Forecast Execution Report, which indicates if the Submit Forecast program produced any errors. You can also print this report later using the Submit Request window. Cash Management also generates the Cash Forecast report if the Submit Forecast program produced no errors.
Related Topics
Generating a Cash Forecast with Amounts Generated Automatically
Creating a Manually Entered Cash Forecast
External Cash Flow Open Interface
Enter values for the following parameters when you generate forecasts using either the Submit Request window, the Run Forecast icon in the Forecast Templates Search and Results page, or the Run Forecast icon in the Forecasts Search and Results page.
Forecast By: The forecast period type used to run the cash forecast. The values for this field automatically default based on the forecast template you select and is not updatable.
GL Periods: Run a forecast with GL Periods as the forecast period type.
Days: Run a forecast with Days as the forecast period type.
Note: When you define a forecast template, you specify the forecast period type as GL Periods or Days.
Template Name: The forecast template used to create a new forecast.
Forecast Name: The unique forecast name for this cash forecast. If you do not enter a forecast name, Cash Management automatically generates a unique name for you by attaching the system date and time to the template name.
Factor: Indicates the way amounts are displayed in the forecast.
Calendar Name: The name of the GL accounting calendar, used when submitting a forecast by GL Period. In addition, if you submit a forecast by Days, and you select the GL Cash Position or the Both Bank Account and GL Cash Position option in the View Opening Balance By field, then you need to enter a Calendar Name.
Important: All GL sources for a forecast by GL periods must use ledgers with the same accounting calendar. If you are creating a forecast across multiple organizations, all organizations' ledgers must use the same accounting calendar.
Start Period and Start Date: The accounting period to begin the forecast, or the day to begin the forecast. Cash Management restricts you to using Start Period when submitting a forecast by GL Period, and Start Date when submitting a forecast by Days.
Note: The Start Date or Period should be as of today or in the future. If you enter a start date in the past, or a start period in the past (or that is in progress), the forecast only includes transactions as of today. For example, if an invoice is paid today, but you enter a forecast start date of two days ago to try to include it as an open invoice, Cash Management still considers it paid and therefore does not include the invoice (as open) in the forecast.
Start Project Number: The beginning number for the range of projects that you want to include in the forecast. Cash Management creates a forecast for every project number in the range that you specify. The default is the project number defined in the template.
End Project Number: The ending number for the range of projects that you want to include in the forecast. Cash Management creates a forecast for every project number in the range that you specify. The default is the project number defined in the template.
Forecast Currency: The currency in which the forecast amounts are to be displayed.
Source Currency Type: The currency type for the sources in the cash forecast. The options are::
All: Include all source transactions, regardless of currency, and translate them to the Forecast Currency.
Entered: Include only source transactions with the same Source Currency as the transaction currency.
Ledger: Include only source transactions with the Source Currency as the ledger currency. (This choice is useful for multiple ledgers environments.)
Source Currency: The currency for the source transactions. The transactions included in your forecast calculations are determined by the combination of your entries for this field and the Source Currency Type field, as explained in the following table. If the Source Currency Type is All, you do not enter a Source Currency.
Note: For any document without a source currency (such as a requisition or purchase order), Cash Management assumes that the ledger currency is the currency of the transaction.
The following table contains the transactions included for each Source Currency Type:
| Source Currency Type | Which Transactions Are Included |
|---|---|
| All | All transactions, all ledgers, all operating units |
| Entered | All transactions entered in the Source Currency for all ledgers |
| Ledger | Selects all ledgers where the ledger currency for that ledger equals the Source Currency specified, and then includes all transactions of all currencies from those ledgers |
Exchange Date and Exchange Type: The exchange rate date, and the exchange rate type, which is defined in Oracle General Ledger. These fields are required if the Forecast Currency and the Source Currency are not the same.
Important: Cash Management automatically converts transaction currency amounts to the forecast currency according to the daily rates for the specified exchange rate type and date.
However, if daily rate information for the exchange date and type does not exist in the Oracle General Ledger daily rates table, the forecast will be inaccurate because Cash Management ignores transactions amounts that it cannot convert to the forecast currency.
Exchange Rate: The user-defined currency exchange rate when the Exchange Rate Type is User. The User rate only applies when the Source Currency Type is Entered, as no one rate will apply to converting various currencies to the forecast currency. This field is required if the Forecast Currency and the Source Currency are not the same.
Amount Threshold: The minimum value of individual transactions to be included in the forecast, allowing you to omit insignificant transaction amounts from the forecast calculations. Cash Management compares this amount to transaction amounts if the Source Currency Type is Entered, and ledger amounts of transaction if the Source Currency Type is Ledger. The program then only selects transactions that are greater than this amount threshold.
If you leave this field blank, then the program selects all valid transactions that meet the selection criteria. This field is not applicable when the Source Currency Type is All.
Row Number From/To: A list of values provides you with a choice to run a partial forecast for sequential rows of the template you entered.
Request by Row: Select Yes to submit a separate concurrent request for each row, so that the rows for the forecast are generated concurrently. (This method is useful for testing or for very large forecasts, that is, forecasts with a large amount of data.)
The parameters in this section refer to the opening balance that you can choose to display in your cash forecast.
View Opening Balance By: Select how to view the opening balance for your cash forecast from the following options:
None: Do not display an opening balance.
GL Cash Position: Display opening balances by GL cash accounts.
Bank Account: Display opening balances by bank accounts.
Both Bank Account and GL Cash Position: Display opening balances by bank accounts and GL cash accounts.
Bank Account Balance Type: If you choose either the Bank Account or Both Bank Account and GL Cash Position option in the View Opening Balance By field, you must choose what type of bank account balance should be used. The options include: Available, Value Dated, and Ledger Balance.
Float Type: If you choose either the Bank Account or Both Bank Account and GL Cash Position option in the View Opening Balance By field, then you must select a value in this field to adjust your opening bank account balance. Options include: Add One Day Float, Add Two Day Float, None, Subtract One Day Float, and Subtract Two Day Float.
Include Subsidiary's Bank Account Balance: If you choose either the Bank Account or the Both Bank Account and GL Cash Position option in the View Opening Balance By field, and you have subsidiary bank accounts set up in Oracle Treasury, you can choose to include the bank account balances of the subsidiary bank accounts in your cash forecast.
You can create a new cash forecast using an existing template without running the forecast program, with no values calculated. You can then manually fill in forecast amounts in the new forecast.
Navigate to the Forecast Search and Results page by selecting Cash Forecasting from the menu.
Select either Days or GL Periods in the Forecast By field, and click Create Forecast Manually.
In the Create Forecast Manually page, enter the Template Name, Forecast Currency, and Factor. If the forecast is by Days, you must enter a Start Date and if it is by GL Period, you must enter a Start Period. Optionally enter a Forecast Name. Click Continue.
In the Create Forecast page, you can:
Enter forecast amounts in the cells and click the Recalculate Summary Cash flows button to update summary cash flows.
Manually add rows and columns to the existing forecast template by clicking on the Add Row or Column button
Exclude rows from summary calculations by disabling the Include checkbox in front of the row and clicking the Recalculate Summary Cash Flows button
Export the forecast to an external application by selecting the Export button.
Important: When you add columns and rows on a forecast template, the changes affect manually created forecasts based on that template as well as those automatically generated.
Forecast Name: The unique forecast name for this cash forecast.
Template Name: The forecast template used to create the forecast.
Forecast Currency: The currency in which the forecast amounts are displayed.
Factor: Indicates the way amounts are displayed:
Units Displays amounts as calculated.
1 Displays amounts as multiples of one.
10 Displays amounts as multiple of ten.
100 Displays amounts as multiples of a hundred.
1000 Displays forecast amounts as multiples of a thousand.
10,000 Displays forecast amounts as multiples of ten thousand.
100,000 Displays forecast amounts as multiples of a hundred thousand.
1,000,000 Displays forecast amounts as multiples of a million.
10,000,000 Displays forecast amounts as multiples of ten million.
100,000,000 Displays forecast amounts as multiples of a hundred million.
1,000,000,000 Displays forecast amounts as multiples of a billion.
Display: You have the option to view the Source and Description, Description Only and Source Only.
View By: You have the option of viewing forecast results by transaction source, by bank account or GL cash position bank account, depending on selection made when submitting the forecast.
You can view your cash forecast results by transaction source, bank account or GL cash position. When you select the forecast name in the Results table, the Forecast Results by Transaction Source page appears. In the View By option, you choose how you want to view the results and click the Go button.
This page displays the forecast results by transaction source. The table below the results displays the summary amounts for the cash inflow, the cash outflow and the net cashflow for each forecast period. For transaction sources associated with bank accounts, the forecast results displayed on this page represent only those transactions that are associated with bank accounts to which the current user has Bank Account Access security enabled. See: Bank Account Access Security within the UMX wizard.
In the Forecast Results by Transaction Source page you can do the following:
Manually add rows and columns to the existing forecast and forecast template by clicking the Add Row or Column button.
Export the forecast results to an external application by selecting the Export button.
View the forecast results in Oracle Discoverer by clicking on the View in Discoverer button.
Exclude rows from summary calculations by disabling the Include checkbox in front of the row and selecting the Recalculate Summary Cashflows button
View a printer friendly format of the forecast results by selecting the Printable Page button
Click on the forecast amount in the cells to see the details of the source transactions. The Source Transaction Details page appears where all the transactions that make up the forecast amount are displayed. You can do the following in this page:
Query for specific transactions by Cash Activity Date or Transaction Amount.
Sort transactions in the Results table by various parameters.
Exclude transactions from the forecast results and update the summary amounts.
Add transactions manually and update the summary amounts.
This page displays the forecast results by bank account. If your forecast contains projected cashflows such as invoices, sales orders, purchase orders, sales opportunities, etc. and you choose the View By Bank Account option, Cash Management groups these sources together and displays them in the Others row If you have not modified your External Cashflow Open Interface view to include Bank Account ID. Cash Management also displays the open interface transactions in the Others row.
In the Forecast Results by Bank Account page you can do the following:
Click the bank account name in the table to see the forecast details of individual bank accounts. From the Details page, you can click on the forecast amounts to view the source transaction details.
Select Printable Page to get a printer friendly version of the forecast results by bank account.
See: Calculation of Opening and Closing Bank Account Balances and GL Cash Position in Cash Forecasting
This page displays the forecast results by GL cash accounts. If your forecast contains projected cashflows such as invoices, sales, orders, purchase orders, sales opportunities, etc., and you choose the View by GL Cash Position option, Cash Management groups these sources together and displays them in the Others row. Cash Management also includes open interface transactions in the Others row if you have not modified your external cashflow open interface view to include Bank Account ID.
In the Forecast Results by GL Cash Position page, you can do the following:
Click the GL Cash Account in the table to see the forecast details of individual GL cash accounts. From the Details page, you can click on the forecast amounts to view the source transaction details.
Select Printable Page to get a printer friendly version of the forecast results by bank account or GL cash position.
The opening bank account balance displayed in the cash forecast results is the closing bank account balance of the day prior to the first day or period of the cash forecast for that bank account.
The balance type and the float type to be used in calculating the opening balance is determined by the selections made while submitting the cash forecast.
If the previous day's closing balance is not available, then the latest available bank account balances are displayed instead. In this case, the cash forecast results by bank account also display a prior day cashflows column that includes transactions between the latest available balance date and the first day/period of the cash forecast so that the closing balance can be projected accurately. The closing balance for bank accounts is calculated as Opening Balance + Prior Day Cash Flows + Net Cash Flow.
Warning: If you choose to include overdue transactions in your cash forecast and your bank account balances are not up to date, transactions that are included as Overdue could overlap with transactions that are included as Prior Day Cashflow causing potential double-counting of transactions in the forecast results.
The opening balance for GL cash accounts for a forecast by days is calculated as the sum of the balance available for the forecast start period within which the forecast start date lies and the net of GL accounting journal entries between period start date and the forecast start date. The opening balance for GL cash accounts for a forecast by GL periods is the balance available for the first day of the forecast start period.
The following table contains the legend for the Cash Inflow Source Transaction Details table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| (blank) = Not applicable | ARI = Customer Invoices | PAI = Project Inflow Budgets |
| S = Summary Section | ARR = Customer Receipts | XTRI = Treasury Inflow |
| D = Detail Section | ASF = Sales Forecasts | UDI = User-Defined Inflow |
| GLB = GL Budgets | OII = Open Interface Inflow | |
| OEO = Sales Orders | ||
| PAB = Project Billing Events |
The following table lists the fields that are displayed in the Summary and Detail section for each cash inflow source type in the Source Transaction Details page.
| ARI | ARR | ASF | GLB | OEO | PAB | PAI | XTRI | UDI | OII | |
|---|---|---|---|---|---|---|---|---|---|---|
| Cash Activity Date | S | S | S | S | S | S | S | S | S | |
| Forecast Amount | S | S | S | S | S | S | S | S | S | S |
| Transaction Currency | S | S | S | S | S | S | S | |||
| Transaction Amount | S | S | S | S | S | S | S | |||
| Transaction Number | S | |||||||||
| Profile Class | D | D | ||||||||
| Dispute Amount | D | |||||||||
| Organization | D | D | D | D | D | D | ||||
| Receipt Number | S | |||||||||
| Bank Account Currency | S | S | ||||||||
| Bank Account Amount | S | S | ||||||||
| Status | D | D | D | |||||||
| Receipt Method | D | |||||||||
| Bank Account Name | D | D | ||||||||
| Bank Account Number | D | D | ||||||||
| Lead Number | S | |||||||||
| Channel | D | |||||||||
| Win Probability | D | |||||||||
| Balance Currency | S | |||||||||
| Ledger | D | |||||||||
| Sales Order Number | S | |||||||||
| Line Number | D | D | ||||||||
| Order Type | D | |||||||||
| Deal Number | S | |||||||||
| Deal Type | S | |||||||||
| Counterparty | S | |||||||||
| Amount Type | S | |||||||||
| Deal Subtype | D | |||||||||
| Transaction Number | D | D | ||||||||
| Company | D | |||||||||
| Resource Name | S | |||||||||
| Period Name | S | |||||||||
| Period Start Date | S | |||||||||
| Period End Date | S | |||||||||
| Project Currency | S | |||||||||
| Revenue | S | |||||||||
| Task Name | D | |||||||||
| Event Number | S | |||||||||
| Invoice Line Type | D | |||||||||
| Billed Flag | D |
The following table contains the legend for the Cash Outflow Source Transaction Details table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| (blank) = Not applicable | APX = Expense Reports | POP = Purchase Orders |
| S = Summary Section | GLB = GL Budgets | POR = Purchase Requisitions |
| D = Detail Section | GLE = GL Encumbrances | XTRO = Treasury Outflow |
| PAO = Project Outflow Budgets | UDO = User-Defined Outflow | |
| API = Supplier Invoices | PAT = Project Transactions | OIO = Open Interface Outflow |
| APP = Supplier Payments | PAY = Payroll Expenses |
The following table lists the fields that are displayed in the Summary and Detail section for each source type in the Source Transaction Details page.
| API | APP | APX | GLB | GLE | PAO | PAT | PAY | POP | POR | XTRO | UDO | OIO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash Activity Date | S | S | S | S | S | S | S | S | S | S | S | S | |
| Forecast Amount | S | S | S | S | S | S | S | S | S | S | S | S | S |
| Transaction Currency | S | S | S | S | S | S | S | S | S | S | S | S | |
| Transaction Amount | S | S | S | S | S | S | S | S | S | ||||
| Invoice Number | S | S | |||||||||||
| Payment Priority | D | D | D | ||||||||||
| Supplier Type | D | D | D | ||||||||||
| Pay Group | D | D | D | ||||||||||
| On Hold? | D | D | |||||||||||
| Organization | D | D | D | D | D | D | D | ||||||
| Payment Number | S | ||||||||||||
| Bank Account Currency | S | S | S | ||||||||||
| Bank Account Amount | S | S | S | ||||||||||
| Status | D | D | D | ||||||||||
| Payment Method | D | D | |||||||||||
| Bank Account Name | D | D | D | ||||||||||
| Bank Account Number | D | D | D | ||||||||||
| Balance Currency | S | S | |||||||||||
| Source | D | ||||||||||||
| Payroll Name | S | ||||||||||||
| Business Group | D | ||||||||||||
| Purchase Order Number | S | ||||||||||||
| Line Number | D | D | |||||||||||
| Requistion Number | S | ||||||||||||
| Deal Number | S | ||||||||||||
| Deal Type | S | ||||||||||||
| Counterparty | S | ||||||||||||
| Amount Type | S | ||||||||||||
| Deal Subtype | D | ||||||||||||
| Transaction Number | D | ||||||||||||
| Company | D | ||||||||||||
| Resource Name | S | ||||||||||||
| Period Name | S | ||||||||||||
| Period Start Date | S | ||||||||||||
| Period End Date | S | ||||||||||||
| Assignment Start Date | D | D | |||||||||||
| Assignment End Date | D | D | |||||||||||
| Project Currency | S | ||||||||||||
| Cost | S | ||||||||||||
| Burdened Cost | D | ||||||||||||
| Task Name | D | ||||||||||||
| Expenditure Status | |||||||||||||
| Expenditure Type | D | ||||||||||||
| Expenditure Item Date | D | ||||||||||||
| Quantity | D |
You can modify cash forecast templates and forecasts, with some limitations. The following table addresses what you can change on cash forecast templates and cash forecasts and when:
| Change Descriptive Information | Add Rows and Columns | Delete Rows and Columns | Change Forecast Amounts | |
|---|---|---|---|---|
| New Templates | Yes | Yes | Yes | N/A |
| Templates Used to Generate Forecasts | No | No | No | N/A |
| Forecasts | No | Yes, with an option to modify original template and all existing forecasts based on that template; or to create new template. | No | Yes, modify values directly in fields by drilling down to the Source Transaction Details page and either adding a new transaction or excluding existing transactions. Forecast summary amounts cannot be modified, but are automatically updated to reflect forecast amount changes. |
Navigate to the Forecast Templates Search and Results page.
(Optional) Enter a partial or full Template Name.
(Optional) Select a forecast period type in the Forecast By field.
Click Go. Cash Management displays all cash forecast templates that match your search criteria.
Click on the Template Name in the Forecast Template Results table to view template details.
Query an existing cash forecast template (see above).
If no cash forecasts exist based on the template, you can modify any of the information for the cash forecast template by selecting the Update icon corresponding to your template.
Navigate to the Cash Forecasts Search and Results page.
(Optional) Enter a partial or full Template Name, or a partial or full Forecast Name. Optionally enter a forecast period type in the Forecast By field.
Click Go and Cash Management displays all cash forecasts that match your search criteria.
In the Forecast Results table, you can view the following information: Forecast Name, Template Name, Forecast By, Start Date/Start Period, Processing Status, and Date Run.
Note: Click on the Template Name to view the details of the template used to generate this forecast.
Click on the Forecast Name to review the forecast results.
Query an existing cash forecast (see above).
Click on the Forecast Name. The Cash Forecast Results page appears.
Click on the amount in the forecast cell that you want to modify. The Source Transaction Details page appears.
You can choose to exclude transactions by disabling the Include checkbox that corresponds to the transaction. Or, you can add a new transaction by entering the transaction details in the Transaction section and clicking the Add button.
Click the Apply button to save the changes and return to the Forecast Results page.
Query an existing cash forecast.
Click on the Forecast Name. The Cash Forecast Results page appears
Choose the Add Row or Column button. The Add Rows and Columns page appears.
Enter a unique Column Number and GL Period From and To/Days From and To values.
Values must be integers between 1 and 999. The Column Number indicates the sequence of the columns in the forecast.
Enable the Create a New Template option if you do not want the new columns to be added to all existing forecasts that are based on the original template for the forecast. Enabling the Create a New Template option creates a new template with the same rows and columns as this forecast, including the columns you are adding. Cash Management updates the summary amounts in the cash forecast to reflect your changes.
If you enabled the Create a New Template option in the previous step, enter a Template Name for a new template. Alternatively enable the Update Existing Template option to update the existing Forecast template.
Click the Apply button to save the column information and the modified template.
Note: If you have created a new forecast template, further changes that you make from this point are made on the new template. You can make further changes to the new template now, or query it later.
Query an existing cash forecast.
Click on the Forecast Name. The Cash Forecast Results page appears
Choose the Add Row or Column button. The Add Rows and Columns page appears.
Enter a Row Number. Values must be integers between 1 and 999. The Row Number indicates the sequence of the rows in the forecast.
Choose a Source of either User-defined Inflow or User-defined Outflow. This creates a new row, filled with zeros, in the forecast for you to manually enter a definition and forecast amounts.
Note: If you want to add standard sources that are not yet a part of your template, use the Forecast Templates window. See: Modifying Cash Forecast Templates and Cash Forecasts
Check the Create New Forecast Template check box if you do not want your new rows to be added to all forecasts using the original template for your forecast. Checking this box creates a new template with the same rows and columns as this forecast, plus the rows you are adding.
If you checked Create a New Template in the previous step, enter a Template Name for a new template.
Choose Add to save the row and the new or modified template.
Note: If you have created a new forecast template, further changes that you make from this point are made on the new template. You can make further changes to the new template now, or query it later.
Important: You can add rows and columns in a template, but your action will affect all cash forecasts previously generated using that template. Adding rows and columns to a previously-defined template generates forecast amounts of zero for the new cells in existing forecasts.
Row Number: Indicates the sequence of rows in the forecast. Enter a unique integer between 1 and 999 for the row you are adding.
Source: Indicates if the source is User-Defined Inflow or User-Defined Outflow. Cash Management creates a new row that contains zeros so you can manually enter forecast amounts.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Column Number: Indicates the sequence of columns in the forecast. Enter a unique integer between 1 and 999 for the column you are adding.
GL Periods / Days From: Use this field, along with the GL Periods/Days To field, to indicate the time range for this forecasting period.
GL Periods / Days To: Use this field, along with the GL Periods/Days From field, to indicate the time range for this forecasting period.
Create A New Template: Select this option to create a new template that contains the same rows and columns as this forecast, plus the row or column you are adding.
Update Existing Forecast Template: Select this option to add the new row or column to the existing template and all the forecasts based on this template.
Template Name: Enter the name of the new forecast template.
You can purge previously generated cash forecasts when you submit the Purge Cash Forecasts program using the Submit Request window. Cash Management automatically generates the Purge Cash Forecasts report when you submit the Purge Cash Forecasts program. The Purge Cash Forecasts report lists the forecasts that have been purged.
Purge Option: Choose forecasts by days, GL periods, or both.
Forecast Template: Optionally choose the forecast template associated with the forecasts you want to purge.
Forecast Date From/Forecast Date To: Optionally choose a value for each of these parameters. All forecasts within this date range will be purged.
You can transfer cash forecast results to your spreadsheet application. Excel can be very useful to manipulate information for analysis and graphical representation.
Use the Export button in the Cash Forecast Results page to export cash forecasts from Cash Management to Microsoft Excel.
Note: This option is available only on the Windows platform, and only if Microsoft Excel is installed.
Navigate to the Forecast Search and Results page.
Query the cash forecast you want to export.
Click on the Forecast Name. The Forecast Results page appears.
Click the Export button. The Export Forecast Results page appears.
You can choose to export the Cashflow Detail and/or the Cashflow Summary by clicking on the corresponding buttons.
The Save dialogue box appears.
Enter the file name and select the file type to export the results.
Note: Saving in your spreadsheet application does not save an updated spreadsheet in your Oracle database. You can make any modifications to your cash forecast results in your spreadsheet application.
Related Topics
You can view cash forecast results in a Discoverer Workbook. Discoverer enables you to manipulate information for analysis and graphical representation.
To view cash forecast results in a Discoverer Workbook, click the View in Discoverer button in the Cash Forecast Results page. This option is only available if you have Oracle Discoverer installed.
Cash Management provides one predefined workbook, which contains the following worksheets:
This worksheet displays the forecast amounts grouped by transaction source type in the forecast currency.
This worksheet displays the cash forecast amounts grouped by transaction source type in the forecast currency and the transaction currency.
This worksheet displays cash forecast results grouped by transaction source type and bank account for a particular currency.
This worksheet displays the bank account opening and closing balances, net cash flows, and subsidiary bank account opening balances for different bank accounts grouped by legal entity.
This worksheet displays details of supplier invoices that pertain to a particular forecast.
This worksheet displays details of supplier payments that pertain to a particular forecast.
This worksheet displays details of expense reports that pertain to a particular forecast.
This worksheet displays details of customer invoices that pertain to a particular forecast.
This worksheet displays details of customer receipts that pertain to a particular forecast.
This worksheet displays details of sales forecasts that pertain to a particular forecast.
This worksheet displays details of GL budgets that pertain to a particular forecast.
This worksheet displays details of GL Encumbrances that pertain to a particular forecast.
This worksheet displays details of sales orders that pertain to a particular forecast.
This worksheet displays details of open interface source transactions that pertain to a particular forecast.
This worksheet displays details of project billing events that pertain to a particular forecast.
This worksheet displays details of project budgets that pertain to a particular forecast.
This worksheet displays details of project transactions that pertain to a particular forecast.
This worksheet displays details of payroll expenses that pertain to a particular forecast.
This worksheet displays details of purchase orders that pertain to a particular forecast.
This worksheet displays details of purchase requisitions that pertain to a particular forecast.
This worksheet displays details of treasury transactions that pertain to a particular forecast.
Oracle Cash Management imposes Oracle Treasury's Legal Entity security for Treasury users to secure forecast templates and forecast results. Only Oracle Treasury users have access to the sources of Treasury Inflow and Treasury Outflow for inclusion in a forecast. Similarly, only Oracle Treasury users have the option to include the subsidiary bank account balances when submitting a cash forecast. In the cash forecast results, Oracle Cash Management displays only the transactions that belong to legal entities that the treasury user has access to. Non-Treasury users will not have access to any Treasury transactions although they can still generate and view forecast results across all organizations.