Welcome to Release 12.1 of the Oracle Transfer Pricing User Guide.
This guide assumes you have a working knowledge of the following:
The principles and customary practices of your business area.
Computer desktop application usage and terminology
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.
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.
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/.
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.
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.
This chapter provides an introduction to Oracle Transfer Pricing and discusses its place in the Oracle Financial Services (OFS) group of applications.
This chapter describes the set of steps that you need to follow to transfer price your balance sheet using Oracle Transfer Pricing.
This chapter focuses on the rule management tasks that are common across all rules in this application.
This chapter discusses the rule approval process and the procedure for managing approved rules.
This chapter discusses the process for managing currency rate information, including creating daily, historical, and cross rates. The chapter also describes how to upload daily rates and upload and download historical rates from spreadsheet-based applications to Oracle Transfer Pricing.
This chapter discusses the procedure for validating and cleansing your Account table data before you process it to generate transfer pricing results.
This chapter describes the procedure for capturing instrument payment patterns that are too complex to be accommodated in the standard fields of Account tables.
This chapter discusses the procedure for working with and managing user defined repricing patterns.
This chapter discusses the procedure for working with and managing interest rate codes and loading related data such as historical rates and term structure parameters.
This chapter describes the steps you need to take to work with and manage the Rate Index Rules.
This chapter discusses the procedure for assigning transfer pricing, prepayment, and adjustment methodologies to product-currency combinations using conditional logic.
This chapter describes the procedure for working with and managing Transfer Pricing rules.
This chapter describes the procedure for working with and managing Prepayment rules.
This chapter describes the procedure to build prepayment tables using Prepayment Table Rules.
This chapter describes the procedure for working with and managing Adjustments rules.
This chapter describes the procedure to output transfer pricing results to the seeded or user-defined alternate columns instead of default columns of the application.
This chapter describes the procedure for defining the propagation pattern.
This chapter discusses the procedure for working with and managing the Transfer Pricing Process rules.
This chapter describes the Oracle Transfer Pricing reports and the procedure for generating and viewing them.
This appendix gives you information to navigate through the pages referred to in this guide.
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).
PDF - PDF documentation is available for download from the Oracle Technology Network at http://otn.oracle.com/documentation.
Online Help - Online help patches (HTML) are available on My Oracle Support.
Release Notes - For information about changes in this release, including new features, known issues, and other details, see the release notes for the relevant product, available on My Oracle Support.
Oracle Electronic Technical Reference Manuals - Each Electronic Technical Reference Manual (eTRM) contains database diagrams and a detailed description of database tables, forms, reports, and programs for a specific Oracle Applications product. This information helps you convert data from your existing applications and integrate Oracle Applications data with non-Oracle applications, and write custom reports for Oracle Applications products. Oracle eTRM is available on My Oracle Support.
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 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 high level service enablement process and how users can browse and view each integration interface definitions and services resided in Oracle Integration Repository.
Oracle E-Business Suite Integrated SOA Gateway Implementation Guide:
This guide explains the details of how integration repository administrators can manage and administer the entire service enablement process based on the service-oriented architecture (SOA) 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 working with Oracle Workflow Business Event System, manage Web service security, and 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 including orchestrating discrete Web services into meaningful end-to-end business processes using BPEL (business process execution language), and deploying BPEL processes at run time.
It also explains how to invoke Web services using Service Invocation Framework in details including 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 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 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 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 iSetup User Guide
This guide describes how to use Oracle iSetup to migrate data between different instances of the Oracle E-Business Suite and generate reports. It also includes configuration information, instance mapping, and seeded templates used for data migration.
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 Approvals Management Implementation Guide:
Use Oracle Approvals Management (AME) to define the approval rules that determine the approval processes for Oracle applications.
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 Reference Guide:
This guide provides reference material for Oracle Financial Services applications in Release 12, such as Oracle Transfer Pricing, and includes technical details about application use as well as general concepts, equations, and calculations.
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.
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.
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.