Skip Headers

Oracle Financial Services Reference Guide
Release 12.1
Part Number E13528-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Preface

Intended Audience

Welcome to Release 12.1 of the Oracle Financial Services Reference Guide.

This guide assumes you have a working knowledge of the following:

If you have never used Oracle Applications, we suggest you attend one or more of the Oracle Applications training classes available through Oracle University.

See Related Information Sources for more Oracle E-Business Suite product information.

Deaf/Hard of Hearing Access to Oracle Support Services

To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone numbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Structure

1  Transfer Pricing Concept

This chapter describes the transfer pricing concept and the traditional and matched rate approaches to transfer pricing. A description of how matched rate transfer pricing overcomes the shortcomings of the traditional approaches is also provided. The chapter ends with a description of the role of matched rate transfer pricing in the evaluation of interest rate risk.


2  Transfer Pricing Option Costs

This chapter describes how Oracle Transfer Pricing goes about calculating option costs. The chapter begins with an introduction to option costs and subsequently describes option cost theory and the calculation architecture.


3  The Ledger Migration Process

This chapter discusses the process for generating credits or charges, for funds provided or used, and their migration to the Management Ledger table. The chapter provides a detailed description of how the information required for generating these credits or charges originates through transfer rates and option cost processing from the Customer Account tables and how the results are inserted into the Management Ledger table.


4  Rate Conversion

This chapter describes how Oracle Transfer Pricing translates interest rates from their initial formats into formats that can be used by the application.


5  Cash Flow Edit Logic

This chapter describes the set of logical validations that are performed, and the order in which they should be performed, on the Account table data during a Cash Flow Edits rule run.


6  Cash Flow Calculations

This chapter discusses cash flow calculation concepts and processes.


7  Cash Flow Dictionary

This chapter lists and describes the account table columns that store cash flow data and are accessed by Oracle Transfer Pricing during cash flow processing and edits.

The chapter also provides detailed information on how to correctly populate account table columns with instrument data, including column descriptions, usage, and recommended default values for the cash flow processing columns.


Related Information Sources

This document is included on the Oracle Applications Document Library, which is supplied in the Release 12 DVD Pack. You can download soft-copy documentation as PDF files from the Oracle Technology Network at http://otn.oracle.com/documentation, or you can purchase hard-copy documentation from the Oracle Store at http://oraclestore.oracle.com. The Oracle E-Business Suite Documentation Library Release 12 contains the latest information, including any documents that have changed significantly between releases. If substantial changes to this book are necessary, a revised version will be made available on the online documentation CD on My Oracle Support.

If this guide refers you to other Oracle Applications documentation, use only the Release 12 versions of those guides.

For a full list of documentation resources for Oracle Applications Release 12, see Oracle Applications Documentation Resources, Release 12, Document 394692.1 on My Oracle Support.

Online Documentation

All Oracle Applications documentation is available online (HTML or PDF).

Related Guides

You should have the following related books on hand. Depending on the requirements of your particular installation, you may also need additional manuals or guides.

Oracle Alert User's Guide:

This guide explains how to define periodic and event alerts to monitor the status of your Oracle Applications data.

Oracle Application Framework Developer's Guide:

This guide contains the coding standards followed by the Oracle Applications development staff to produce applications built with Oracle Application Framework. This guide is available in PDF format on My Oracle Support and as online documentation in JDeveloper 10g with Oracle Application Extension.

Oracle Application Framework Personalization Guide:

This guide covers the design-time and run-time aspects of personalizing applications built with Oracle Application Framework.

Oracle Application Server Adapter for Oracle Applications User's Guide:

This guide covers the use of OracleAS Adapter in developing integrations between Oracle applications and trading partners.

Please note that this guide is in the Oracle Application Server 10g Documentation Library.

Oracle E-Business Suite Concepts:

This book is intended for all those planning to deploy Oracle E-Business Suite Release 12, or contemplating significant changes to a configuration. After describing the Oracle Applications architecture and technology stack, it focuses on strategic topics, giving a broad outline of the actions needed to achieve a particular goal, plus the installation and configuration choices that may be available.

Oracle E-Business Suite Developer's Guide:

This guide contains the coding standards followed by the Oracle Applications development staff. It describes the Oracle Application Object Library components needed to implement the Oracle Applications user interface described in the Oracle E-Business Suite User Interface Standards for Forms-Based Products. It provides information to help you build your custom Oracle Forms Developer forms so that they integrate with Oracle Applications. In addition, this guide has information for customizations in features such as concurrent programs, flexfields, messages, and logging.

Oracle E-Business Suite Diagnostics User's Guide:

This manual contains information on implementing, administering, and developing diagnostics tests in the Oracle E-Business Suite Diagnostics framework.

Oracle E-Business Suite Flexfields Guide:

This guide provides flexfields planning, setup, and reference information for the Oracle Applications implementation team, as well as for users responsible for the ongoing maintenance of Oracle Applications product data. This guide also provides information on creating custom reports on flexfields data.

Oracle E-Business Suite Installation Guide: Using Rapid Install:

This guide provides information about using the Rapid Install utility to install Oracle Applications Release 12, or as a part of an upgrade from Release 11i to Release 12. Discusses Standard and Express installations, fresh or Vision Demo database installations, as well as techstack and product upgrades.

Oracle E-Business Suite Integrated SOA Gateway User's Guide:

This guide describes the high level service enablement process, explaining how users can browse and view the integration interface definitions and services residing in Oracle pi.

Oracle E-Business Suite Integrated SOA Gateway Implementation Guide:

This guide explains how integration repository administrators can manage and administer the service enablement process (based on the service-oriented architecture) for both native packaged public integration interfaces and composite services (BPEL type). It also describes how to invoke Web services from Oracle E-Business Suite by employing the Oracle Workflow Business Event System; how to manage Web service security; and how to monitor SOAP messages.

Oracle E-Business Suite Integrated SOA Gateway Developer's Guide:

This guide describes how system integration developers can perform end-to-end service integration activities. These include orchestrating discrete Web services into meaningful end-to-end business processes using business process execution language (BPEL), and deploying BPEL processes at run time.

It also explains in detail how to invoke Web services using the Service Invocation Framework. This includes defining Web service invocation metadata, invoking Web services, managing errors, and testing the Web service invocation.

Oracle E-Business Suite Maintenance Procedures:

This guide describes how to use AD maintenance utilities to complete tasks such as compiling invalid objects, managing parallel processing jobs, and maintaining snapshot information. Part of Maintaining Oracle Applications, a 3-book set that also includes Oracle E-Business Suite Patching Procedures and Oracle E-Business Suite Maintenance Utilities.

Oracle E-Business Suite Maintenance Utilities:

This guide describes how to run utilities, such as AD Administration and AD Controller, used to maintain the Oracle Applications file system and database. Outlines the actions performed by these utilities, such as monitoring parallel processes, generating Applications files, and maintaining Applications database entities. Part of Maintaining Oracle Applications, a 3-book set that also includes Oracle E-Business Suite Patching Procedures and Oracle E-Business Suite Maintenance Procedures.

Oracle E-Business Suite Patching Procedures:

This guide describes how to patch the Oracle Applications file system and database using AutoPatch, and how to use other patching-related tools like AD Merge Patch, OAM Patch Wizard, and OAM Registered Flagged Files. Describes patch types and structure, and outlines some of the most commonly used patching procedures. Part of Maintaining Oracle Applications, a 3-book set that also includes Oracle E-Business Suite Maintenance Utilities and Oracle E-Business Suite Maintenance Procedures.

Oracle E-Business Suite Upgrade Guide: Release 11i to Release 12.1.1:

This guide provides information for DBAs and Applications Specialists who are responsible for upgrading a Release 11i Oracle Applications system (techstack and products) to Release 12.1.1. In addition to information about applying the upgrade driver, it outlines pre-upgrade steps and post-upgrade steps, and provides descriptions of product-specific functional changes and suggestions for verifying the upgrade and reducing downtime.

Oracle E-Business Suite System Administrator's Guide Documentation Set:

This documentation set provides planning and reference information for the Oracle Applications System Administrator. Oracle E-Business Suite System Administrator's Guide - Configuration contains information on system configuration steps, including defining concurrent programs and managers, enabling Oracle Applications Manager features, and setting up printers and online help. Oracle E-Business Suite System Administrator's Guide - Maintenance provides information for frequent tasks such as monitoring your system with Oracle Applications Manager, administering Oracle E-Business Suite Secure Enterprise Search, managing concurrent managers and reports, using diagnostic utilities including logging, managing profile options, and using alerts. Oracle E-Business Suite System Administrator's Guide - Security describes User Management, data security, function security, auditing, and security configurations.

Oracle E-Business Suite User's Guide:

This guide explains how to navigate, enter data, query, and run reports using the user interface (UI) of Oracle Applications. This guide also includes information on setting user profiles, as well as running and reviewing concurrent requests.

Oracle Web Applications Desktop Integrator Implementation and Administration Guide:

Oracle Web ADI brings Oracle E-Business Suite functionality to a spreadsheet where familiar data entry and modeling techniques can be used to complete Oracle E-Business Suite tasks. You can create formatted spreadsheets on your desktop that allow you to download, view, edit, and create Oracle E-Business Suite data that you can then upload. Use this guide to implement Oracle Web ADI and for information on defining mappings, layouts, style sheets, and other setup options.

Oracle Workflow Administrator's Guide:

This guide explains how to complete the setup steps necessary for any product that includes workflow-enabled processes. It also describes how to manage workflow processes and business events using Oracle Applications Manager, how to monitor the progress of runtime workflow processes, and how to administer notifications sent to workflow users.

Oracle Workflow API Reference:

This guide describes the APIs provided for developers and administrators to access Oracle Workflow.

Oracle Workflow Client Installation Guide

This guide describes how to install the Oracle Workflow Builder and Oracle XML Gateway Message Designer client components for Oracle E-Business Suite.

Oracle Workflow Developer's Guide:

This guide explains how to define new workflow business processes and customize existing Oracle Applications-embedded workflow processes. It also describes how to define and customize business events and event subscriptions.

Oracle Workflow User's Guide:

This guide describes how users can view and respond to workflow notifications and monitor the progress of their workflow processes.

Oracle Business Intelligence Discoverer Administration Guide:

Use this guide to find out how to set up and maintain a Discoverer system after installation. It covers how to use Discoverer Administrator to: create and maintain End User Layers; to set up business areas, folders and items; to help users find information by defining joins, calculated items, and conditions; and to improve Discoverer performance.

Oracle Business Intelligence Discoverer Plus User's Guide:

Use this guide to find out how to retrieve and analyze data by creating worksheets and charts, and how to publish those results. It covers the most common tasks you will perform with Discoverer Plus (for example, drilling and pivoting), along with reference information and useful examples. It includes an appendix containing detailed calculation examples.

Oracle Business Intelligence Discoverer Viewer User's Guide:

Use this guide to find out how to analyze data in worksheets that have already been created in Discoverer Plus. It covers the most common tasks you will perform with Discoverer Viewer (for example, drilling and pivoting), along with reference information and useful examples.

Oracle Embedded Data Warehouse Implementation Guide:

This guide describes how to implement Embedded Data Warehouse, including how to set up the intelligence areas.

Oracle Embedded Data Warehouse Install Guide:

This guide describes how to install Embedded Data Warehouse, including how to create database links and create the end user layer (EUL).

Oracle Embedded Data Warehouse User Guide:

This guide describes how to use Embedded Data Warehouse reports and workbooks to analyze performance.

Oracle Enterprise Performance Foundation User's Guide:

This guide describes Oracle Enterprise Performance Foundation, an open and shared repository of data and business rules that provides the framework for all of the applications in the Corporate Performance Management set of products. It describes the product features that allow you to manage repository metadata and enable you to generate management reports and perform analyses.

Oracle Financial Services Implementation Guide:

This guide provides information about setting up Oracle Financial Services (OFS) applications in Release 12.

Oracle Financial Services Reporting Administration Guide:

This guide describes the reporting architecture of Oracle Financial Services applications in Release 12, and provides information on how to view these reports.

Oracle General Ledger Implementation Guide:

This guide provides information on how to implement Oracle General Ledger. Use this guide to understand the implementation steps required for application use, including how to set up Accounting Flexfields, Accounts, and Calendars.

Oracle General Ledger Reference Guide:

This guide provides detailed information about setting up General Ledger Profile Options and Applications Desktop Integrator (ADI) Profile Options.

Oracle General Ledger User's Guide:

This guide provides information on how to use Oracle General Ledger. Use this guide to learn how to create and maintain ledgers, ledger currencies, budgets, and journal entries. This guide also includes information about running financial reports.

Oracle Profitability Manager User's Guide:

This guide describes Profitability Manager, which provides a rich set of features that support complex models to analyze your business. These features include a powerful allocation engine that supports many allocation methodologies, Activity-Based Management calculations that provide activity costs, rolled up costs and statistics, activity rates, and cost object unit costs, and customer profitability calculations to consolidate customer accounts, aggregate customer data, and determine profitability results.

Oracle Transfer Pricing User Guide:

This guide contains the information you need to understand and use Oracle Transfer Pricing, including how to generate transfer rates and option costs for your product portfolio and determine account level match-funded spreads.

Integration Repository

The Oracle Integration Repository is a compilation of information about the service endpoints exposed by the Oracle E-Business Suite of applications. It provides a complete catalog of Oracle E-Business Suite's business service interfaces. The tool lets users easily discover and deploy the appropriate business service interface for integration with any system, application, or business partner.

The Oracle Integration Repository is shipped as part of the E-Business Suite. As your instance is patched, the repository is automatically updated with content appropriate for the precise revisions of interfaces in your environment.

Do Not Use Database Tools to Modify Oracle E-Business Suite Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle E-Business Suite data unless otherwise instructed.

Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle E-Business Suite data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle E-Business Suite tables are interrelated, any change you make using an Oracle E-Business Suite form can update many tables at once. But when you modify Oracle E-Business Suite data using anything other than Oracle E-Business Suite, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle E-Business Suite.

When you use Oracle E-Business Suite to modify your data, Oracle E-Business Suite automatically checks that your changes are valid. Oracle E-Business Suite also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.