Oracle Treasury User Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Overview

About Oracle Treasury

Treasury Setup

Setting Up Oracle Treasury
Related Product Setup Steps
Setup Flowchart
Treasury Setup Checklist
System Setup
User Access Levels
System Parameters
Currency Details
Party Setup
      Party Types
Counterparty Profiles
Portfolio Codes
Company Profiles
Deal Types and Product Types
Currency Holiday Rules
Journal Entry Actions
Audit Requirements
Deal Setup
      Stock Issues
      Bond Issues
      Bill/Bond Issue Numbers
      Payment Schedules
      Exposure Types
      Hedging
      Defining Hedge Policies
      Defining Hedge Objective Types
      Defining Hedge Strategies
Default Settlement Accounts
Default Settlement Actions
Party Groups
Cash Leveling
Deal Rate Tolerances
Interest Override Tolerances
Policy Setup
      Interest Rate Policy
Limits Setup
      Limits
      Defining Limit Types and Limits Monitoring
      Defining Global Limits
      Limit Weighting
      Defining Term Limits
      Defining Counterparty Limits
      Defining Counterparty Group Limits
      Defining Currency Limits
      Defining Dealer Limits
      Defining Settlement Limits
      Defining Sovereign Limits
      Limits Workflow Notification
Deal Confirmation Groups
Deal Confirmation Templates
Import Sources and Reconciliation
Tax/Brokerage Setup
      Brokerage Schedule and Details
      Tax Schedule and Details
Rates, Curves, and Market Data Sets Setup
      Current System Rates
      Market Data Curves
      Viewing Market Data Curves
      Market Data Sets
System Languages

Foreign Exchange Deals

Foreign Exchange
Spot and Forwards
Foreign Exchange Options
Rollovers and Pre-deliveries

Money Market Deals

Money Market Deals
Short Term Money
Common Details for Short Term Money Deals
Transaction Details for Short Term Money Deals
Intercompany Funding
Wholesale Term Money
Retail Term Money
Negotiable Securities
Discounted Securities
Fixed Income Securities
Derivatives
Forward Rate Agreements
Interest Rate Swaps
Options
Bond Options
Interest Rate Options
Interest Rate Swaptions

Equities

Equity Market Deals
Equities
Purchasing Stocks
Reselling Stocks
Entering Cash Dividends
Viewing Cash Dividends
Viewing Deal Summary
Viewing Resale and Dividend History

Other Deal Items

Other Deal Items
Quick Deals
Exposure Transactions
Deal Linking Codes
Deal Orders
Inter-Account Transfers
Deal Data Import

Hedges

Hedging
Hedges
Hedge Attributes
Entering Hedge Attributes
Hedge Relationships
Entering Actual Hedge Relationships
Actual Hedge Positions
Viewing Open Positions and Outstanding Actual Hedges
Criteria Set
Entering Forecast Hedge Relationships
Viewing Forecast Hedge Fulfillment Items
Completing the Forecast Hedge Fulfillment Process

Balances, Positions, Rates, and Limits

Calculators
Annuities Calculator
Fixed Income Securities Calculator
Bank Accounts
Bank Account Balances
Bank Statement Input
Bank Account Reconciliation
Rates
Current System Rates
Retail Transaction Rates
Positions
Average Rates
Interest Rate Exposures
Liquidity
Currency
Net Transaction Summary
Limit Utilization and Excesses

Settlements and Accounting

Settlements
Transaction Validation
Confirmation Letters
Settlements
Tax Brokerage Settlements
Generating Payment Instructions and Transmitting EFT Payment Files
Accounting
Prospective Hedge Effectiveness Testing
Revaluations
Retrospective Hedge Effectiveness Testing
Accruals and Amortizations
Daily Journals
Auditing

Inquiries and Reports

Inquiries
Reports and Programs
      Common Report Parameters
      Common Report Headings
Administration Reports and Programs
      Audit Report
      Audit Summary Report
      Average FX Rates Report
      Calculate Revaluations
      Cancelled Transactions Summary Report
      Clear Journals
      EFC - Listing of Companies by Ledger
      EFC - Treasury Verification Report
      Generate Accruals
      Import Deal Data
      Import Deal Data Log File
      Limit Exceptions Log Report
      Loan Securities Report
      Monthly Average Rates/Amounts Report
      Non-Revaluation/Non-Accrual Related Journal Processing
      Reset Floating (Benchmarked) Rates Program
      Reset Floating (Benchmarked) Bond Issue Rates
      Retrieve Payment File Confirmations
      Revaluation/Accrual Related Journal Processing
      Transfer CE Bank Statement to Treasury
      Update Limit Utilizations Program
      Update Limit Weightings Program
      Update Settlement Bank Account Program
      Update Today's Average Rate Program
      Upload Bank Balances
Bank Statement Programs
      Bank Account Reconciliation Program
      Bank Statement Transfer Program
Data Exchange Programs
      Market Data Sample File Loader Request Set
      Market Data Load Sample File Program
      Market Data Transfer Sample File
      Market Data Transfer Program
      Market Data Transfer Report
      Upload FX Rates to GL
Hedging Reports
      Positions - Derivatives Disclosure by Hedge Type Report
      Positions - Derivatives Disclosure by Hedge Attribute Report
      Positions - Outstanding Hedge Instruments Report
      Positions - Forecast Hedge Items Fulfillment Report
      Positions - Outstanding Receivables/Payables Report
Intercompany Reports
      Interest Settlement Report
      Letters Report
      Statements
Positions Reports
      Positions - Treasury Cashflows by Account Report
      Positions - Treasury Cashflows by Currency Report
      Positions - Treasury Consolidated Cashflows Report
      Discounted Securities Register
      FX Exposures Report
      Interest Rate Exposures Report
      Interest Rate Hedges Report
      Limit Utilization Report
      Maturities by Counterparty Report
      Maturities by Date Report
Revaluations Reports
      Currency Gain/Loss Revaluation Report
      Mark to Market Revaluation Summary Report
Settlement Reports
      Confirmation Letters Report
      Daily Payments/Receipts Letters Report
      Daily Payments/Receipts Report
      Journals by Date Report
      Status Report
Term Money Reports
      Calculate Retail Term Money Maturity Date Extensions
      New/Settled Retail Term Money Report
      Retail Term Money Aging Report
      Retail Term Money Overdues Report
      Retail Term Money Statements Report
      Summary Term Current Balances Report
      Term Average Rates Report
      Term Money By Type and Product

Navigation

Treasury Navigator Paths

Deal Type Components

Deal Subtypes by Deal Type
      Date Types by Deal Type
      Deal Statuses by Deal Type
      Hedge Statuses
      Deal Amount Types and Deal Actions by Deal Type
      Deal Pricing Models by Deal Type

Open Interface Tables

Treasury Open Interface Tables
      Understanding Open Interface Tables
Table Descriptions

Treasury Terminology

Index