10 Oracle Balance Sheet Planning Process

This module describes the steps that you need to follow to define and execute the end-to-end Balance Sheet Planning Process.

Oracle Balance Sheet Planning is based on the Oracle Financial Services Analytical Applications Infrastructure (OFSAAI). OFSAAI is the central, integrated data source and Administration layer on which Oracle Financial Services Analytical Applications (OFSAA) are built. This description of the Oracle Balance Sheet Planning Process assumes that your system administrator has set up the OFSAAI data repository and has populated it with your enterprise-wide business data.

This chapter covers the following topics:

• Overview of the Process
• Reconciling the Data
• Cleansing the Data by performing Cash Flow Edits
• Setting Application Preferences
• Activating Currencies and Loading Exchange Rates
• (Mandatory) Deciding on historical rate information and managing by creating Interest Rate Codes
• Capturing Instrument Behavior for non-standard instruments
• (Mandatory) Defining Time Buckets
• (Mandatory) Defining Product Characteristics
• (Mandatory - Deterministic) Defining Forecast Rate Scenarios
• Defining Prepayments
• Prepayment Model Method
• Defining Forecast Assumptions
• Defining Transfer Pricing Rules
• Transfer Pricing Methodologies and Rules
• Defining Transfer Pricing Methodologies Using Node Level Assumptions
• (Mandatory) Defining and Running the Balance Sheet Planning Process
• Reviewing Processing Errors
• Accessing Balance Sheet Planning, Detail Cash Flow Results for Audit Purposes
• Analyzing Results
• Reprocessing Erroneous Accounts