You are browsing the archive for XTR.

Oracle Treasury Forms

Oracle Treasury Forms:

FORM SHORT CODE ORACLE FORM NAME
XTRACACL Accruals
XTRACJNL Daily Journals
XTRACJST Journal Entry Actions
XTRACREV Revaluations
XTRAUACC User Access Levels
XTRAUREQ Audit Requirements
XTRAUSUM Audit Summary
XTRBAINS Bank Account Interest Setoffs
XTRCAANN Annuity Calculator
XTRCAFXR Fixed Rate Security Calculator
XTREQADL Deals by Criteria
XTREQAVG Average Rates
XTREQCAN Cancelled Transactions
XTREQCFN Generate Confirmation Letters
XTREQCSS Net Cashflow Summary
XTREQDLC Deal Linking Codes
XTREQDLD Deal Details
XTREQEXP Exposure Positions
XTREQFXH Rollover History
XTREQIRE Interest Rate Exposures
XTREQLIQ Liquidity
XTREQMDL Deal Amounts
XTREQNET Net Transaction Positions
XTRFCDFN Cash Forecast Templates
XTRINBDO Bond Options
XTRINBND Bonds / Fixed Rate Securities
XTRINBNK Current Account Balances
XTRINDIS Discounted Bills / Securities
XTRINEXP Exposure Transactions
XTRINFRA FRAs
XTRINFXO Options
XTRINFXR Contract Rollovers / Predeliveries
XTRINFXS Spot / Forwards
XTRINIAC Inter-Account Transfers
XTRINING Intercompany Funding
XTRINIRO Interest Rate Options
XTRINIRS Interest Rate Swaps
XTRINMIM Manual Statement Input
XTRINORD Deal Orders
XTRINQIN Quick Deals
XTRINRBN Fixed Rate Security Resales/Repurchases
XTRINRDS Discounted Security Resales
XTRINRTL Retail Term Money
XTRINSHT Short Term Money
XTRINSWN Interest Rate Swaptions
XTRINTXB Tax / Brokerage Settlements
XTRINWHL Wholesale Term Money
XTRLICHK Limit Utilization Popup
XTRLIEXC Limit Excesses
XTRLIQRY Limits Utilization
XTRLISET Limits
XTRMTREC Bank Account Reconciliation
XTRMTVAL Transaction Validation
XTRRAPRD Retail Transaction Rates
XTRRASYS Current System Rates
XTRRPTMP Confirmation Template
XTRSEBKI Bank Account Interest Rates
XTRSEBKP Bank Account Interest Rate Popup
XTRSEBKR Brokerage Schedule & Details
XTRSEBND Bill / Bond Issues
XTRSECFG Confirmation Group Codes
XTRSECOM Company Profiles
XTRSECPY Counterparty Profiles
XTRSEDAD Default Settlement Accounts
XTRSEEXC Exchange Codes
XTRSEEXP Exposure Types
XTRSEFXP Currency Details
XTRSEHOL Currency Holiday Rules
XTRSEISS Bill / Bond Issue Numbers
XTRSELNG System Languages
XTRSEMMP Interest Rate Policies
XTRSEPAR System Parameters
XTRSEPGP Party Group Codes
XTRSEPOR Portfolio Codes
XTRSEPYS Payment Schedules
XTRSESRC Import Sources
XTRSETAX Tax Schedule & Details
XTRSETOL Deal Rate Tolerances
XTRSETYP Deal Types / Types
XTRSLACT Default Settlement Actions
XTRSLCBK Cashbook Inquiry
XTRSLSET Settlements
XTRSYTRP Confirmation View Setup
XTRINSTK Stocks
XTRINRST Stock Resales
XTRINCDV Cash Dividends
XTREQCDV View Cash Dividends by Deal
XTRINHAT Hedge Attributes
XTRINHRL Actual Approach
XTRHEPOS Hedge Positions
XTRSESTK Stock Issues
XTRSEITL Interest Override Tolerances
XTRSEPOL Hedge Policies
XTRSESTR Hedge Strategies
XTRWFRLS Event Assignment
XTRINHRF Forecast Approach
XTRACPRO Prospective Testing
XTRACRET Retrospective Testing
XTREQMDC Show Market Data Curves
XTRSEMDC Market Data Curves
XTRSEMDS Market Data Sets

Treasury Tables

Oracle Treasury Tables:

  • XTR_ACCEPTED_BIDS
  • XTR_ACCOUNT_DEBIT_AUTHS
  • XTR_ACCRLS_AMORT
  • XTR_ACCRUAL_AMORTISE_SETUP
  • XTR_AMOUNT_ACTIONS
  • XTR_AMOUNT_TYPES
  • XTR_ARCHIVE_DETAILS
  • XTR_ARCHIVE_ERROR_LOG
  • XTR_ARCHIVE_HISTORY
  • XTR_ARCHIVE_SETUP
  • XTR_AUDIT_COLUMNS
  • XTR_AUDIT_GROUPS
  • XTR_AUDIT_MODULE_ACCESS
  • XTR_AUDIT_SUMMARY
  • XTR_AUTH_CCY_COMBINATIONS
  • XTR_AUTH_TYPE_SUBTYPE_PROD
  • XTR_AVG_RATES_RESULTS
  • XTR_A_BANK_ACCOUNTS
  • XTR_A_BANK_BALANCES
  • XTR_A_BANK_SETTLEMENT_CODES
  • XTR_A_BOND_ISSUES
  • XTR_A_BUY_SELL_COMBINATIONS
  • XTR_A_COMPANY_LIMITS
  • XTR_A_COMPANY_PARAMETERS
  • XTR_A_COUNTERPARTY_LIMITS
  • XTR_A_DEALER_CODES
  • XTR_A_DEALER_LIMITS
  • XTR_A_DEALS
  • XTR_A_DEAL_DATE_AMOUNTS
  • XTR_A_DEAL_ORDERS
  • XTR_A_EXPOSURE_TRANSACTIONS
  • XTR_A_EXPOSURE_TYPES
  • XTR_A_FUTURES
  • XTR_A_FUTURES_FEES
  • XTR_A_FUTURES_MARGIN_DETAILS
  • XTR_A_GL_REFERENCES
  • XTR_A_INTERGROUP_TRANSFERS
  • XTR_A_JOURNALS
  • XTR_A_JOURNAL_ENTRY_ACTIONS
  • XTR_A_MASTER_CURRENCIES
  • XTR_A_PARTY_DEFAULTS
  • XTR_A_PARTY_INFO
  • XTR_A_PORTFOLIOS
  • XTR_A_PRODUCT_TYPES
  • XTR_A_PRO_PARAM
  • XTR_A_RATE_SETS
  • XTR_A_REVALUATION_DETAILS
  • XTR_A_REVALUATION_RATES
  • XTR_A_ROLLOVER_TRANSACTIONS
  • XTR_A_SETTLEMENT_CATEGORIES
  • XTR_A_STANDING_INSTRUCTIONS
  • XTR_A_TAX_BROKERAGE_RATES
  • XTR_A_TAX_BROKERAGE_SETUP
  • XTR_A_TAX_CATEGORIES
  • XTR_BANK_ACCOUNTS
  • XTR_BANK_BALANCES
  • XTR_BANK_BAL_INTERFACE
  • XTR_BATCHES
  • XTR_BATCH_EVENTS
  • XTR_BIDS_RECD
  • XTR_BILL_BOND_ISSUES
  • XTR_BOND_ALLOC_DETAILS
  • XTR_BOND_COUPON_DATES
  • XTR_BOND_ISSUES
  • XTR_BROKERAGE_CATEGORIES
  • XTR_BUY_SELL_COMBINATIONS
  • XTR_CALL_DETAILS
  • XTR_CASHPOOL_ATTRIBUTES
  • XTR_CFLOW_REQUEST_DETAILS
  • XTR_CFLOW_UPDATED_RECORDS
  • XTR_COMPANY_AUTHORITIES
  • XTR_COMPANY_LIMITS
  • XTR_COMPANY_PARAMETERS
  • XTR_CONFIRMATION_ACTIONS
  • XTR_CONFIRMATION_DETAILS
  • XTR_CONFIRMATION_SETUP
  • XTR_COST_OF_FUNDS
  • XTR_COUNTERPARTY_LIMITS
  • XTR_COUNTRY_COMPANY_LIMITS
  • XTR_CUM_DIST_CALCS
  • XTR_CURRENCY_CROSS_RATES
  • XTR_DATA_FEED_CODES
  • XTR_DATE_AMOUNT_TYPES
  • XTR_DATE_TYPES
  • XTR_DDE_FEED_LOCKS
  • XTR_DEALER_CODES
  • XTR_DEALER_LIMITS
  • XTR_DEALS
  • XTR_DEALS_INTERFACE
  • XTR_DEAL_CONFO_TYPES
  • XTR_DEAL_CONTACTS
  • XTR_DEAL_DATE_AMOUNTS
  • XTR_DEAL_LINKING
  • XTR_DEAL_ORDERS
  • XTR_DEAL_OVERWRITE_TYPES
  • XTR_DEAL_RETRO_TESTS
  • XTR_DEAL_STATUSES
  • XTR_DEAL_SUBTYPES
  • XTR_DEAL_TYPES
  • XTR_DEDUCTION_CALCS
  • XTR_EXPOSURE_SUMMARY
  • XTR_EXPOSURE_TRANSACTIONS
  • XTR_EXPOSURE_TYPES
  • XTR_EXTERNAL_CASHFLOWS
  • XTR_EXT_IMPORT_INTERFACE
  • XTR_FORECAST_PERIODS
  • XTR_FORECAST_PERIOD_TEMP
  • XTR_FUTURES
  • XTR_FUTURES_FEES
  • XTR_FUTURES_MARGIN_DETAILS
  • XTR_FX_MULTIPLE_CONTRACTS
  • XTR_FX_PERIOD_WEIGHTINGS
  • XTR_FX_ROLL_PRE_DETAILS
  • XTR_FX_ROLL_PRE_ITERATIONS
  • XTR_FX_WHAT_IFS
  • XTR_GAIN_LOSS_DNM
  • XTR_GENERAL_LEDGER_SUMMARY
  • XTR_GL_BY_PARTY
  • XTR_GL_REFERENCES
  • XTR_GROUP_LIMITS
  • XTR_HEDGE_ATTRIBUTES
  • XTR_HEDGE_CRITERIA
  • XTR_HEDGE_ITEMS_TEMP
  • XTR_HEDGE_JOURNAL_ACTIONS
  • XTR_HEDGE_POLICIES
  • XTR_HEDGE_PRO_TESTS
  • XTR_HEDGE_RELATIONSHIPS
  • XTR_HEDGE_RETRO_TESTS
  • XTR_HEDGE_STRATEGIES
  • XTR_HOLIDAYS
  • XTR_HOLIDAY_RULES
  • XTR_IG_JOURNAL_STRUCTURES
  • XTR_IMPORT_TRAILER_DETAILS
  • XTR_IMPORT_TRANSFER_ERRORS
  • XTR_INTERACCT_TRANSFERS
  • XTR_INTEREST_PERIOD_RATES
  • XTR_INTEREST_RATE_AVERAGES
  • XTR_INTEREST_RATE_BANDS
  • XTR_INTEREST_RATE_EXPOSURE
  • XTR_INTEREST_RATE_EXP_PER
  • XTR_INTEREST_RATE_POLICY
  • XTR_INTEREST_RATE_RANGES
  • XTR_INTEREST_TOLERANCES
  • XTR_INTERFACE_ERRORS
  • XTR_INTERGROUP_TRANSFERS
  • XTR_INTRA_DAY_LIMITS
  • XTR_IRE_MATURITY_BY_POLICY
  • XTR_IRS_ACTUALS
  • XTR_ITEM_RELEASE_DETAILS
  • XTR_JEA_DUPLICATE
  • XTR_JOURNALS
  • XTR_JOURNAL_ENTRY_ACTIONS
  • XTR_LAYOUT_RESULTS
  • XTR_LAYOUT_TEMPLATE
  • XTR_LAYOUT_TEMPLATE_LINE
  • XTR_LAYOUT_VALUES
  • XTR_LAYOUT_VIEW_FX_CONFO
  • XTR_LAYOUT_WHERE_CLAUSE
  • XTR_LIMIT_EXCESS_LOG
  • XTR_LIMIT_TYPES
  • XTR_LIMIT_UTILIZATION_FEE
  • XTR_LOAN_SECURITIES
  • XTR_MARKET_DATA_INTERFACE
  • XTR_MARKET_PRICES
  • XTR_MASTER_CURRENCIES
  • XTR_MIRROR_DDA_LIMIT_ROW
  • XTR_MIRROR_DDA_LIM_ROW_TMP
  • XTR_MTS_RECORDS
  • XTR_MTS_RECORDS_HISTORY
  • XTR_ONE_STEP_SETTLE_CODES
  • XTR_PARCEL_SPLITS
  • XTR_PARTY_DEFAULTS
  • XTR_PARTY_GROUPS
  • XTR_PARTY_INFO
  • XTR_PAYMENT_SCHEDULE
  • XTR_PAY_REC_RECONCILIATION
  • XTR_PORTFOLIOS
  • XTR_PORTFOLIO_DEAL_AMOUNTS
  • XTR_POSITION_HISTORY
  • XTR_PRICE_MODELS
  • XTR_PRINTED_FILE_DETAILS
  • XTR_PRODUCT_TYPES
  • XTR_PRO_DUAL
  • XTR_PRO_PARAM
  • XTR_PRT_BODY
  • XTR_PRT_HEAD
  • XTR_QUICK_INPUT_DEALS
  • XTR_QUICK_INPUT_QUOTES
  • XTR_RATE_GROUPS
  • XTR_RATE_PREFERENCES
  • XTR_RATE_SETS
  • XTR_RECLASS_DETAILS
  • XTR_RECONCILIATION_PASSES
  • XTR_RECONCILIATION_PROCESS
  • XTR_REG_HEDGE_POLICIES
  • XTR_REVALUATION_DETAILS
  • XTR_REVALUATION_MARGINS
  • XTR_REVALUATION_RATES
  • XTR_REVIEW_CURRENCIES
  • XTR_REVIEW_TRANSACTIONS
  • XTR_RM_MD_CURVES
  • XTR_RM_MD_CURVE_RATES
  • XTR_RM_MD_SETS
  • XTR_RM_MD_SET_CURVES
  • XTR_ROLLOVER_TRANSACTIONS
  • XTR_R_BANK_BALANCES
  • XTR_R_CURRENCY_CROSS_RATES
  • XTR_R_DEALS
  • XTR_R_DEAL_DATE_AMOUNTS
  • XTR_R_EXPOSURE_TRANSACTIONS
  • XTR_R_INTEREST_PERIOD_RATES
  • XTR_R_ROLLOVER_TRANSACTIONS
  • XTR_R_SPOT_RATES
  • XTR_SETTLEMENT_CATEGORIES
  • XTR_SETTLEMENT_CONTACTS
  • XTR_SETTLEMENT_SCRIPTS
  • XTR_SETTLEMENT_SUMMARY
  • XTR_SETUP_AUDIT_REQMTS
  • XTR_SOURCE_OF_IMPORTS
  • XTR_SOURCE_TYPES
  • XTR_SPOT_RATES
  • XTR_STANDING_INSTRUCTIONS
  • XTR_STMT_TXNS
  • XTR_STOCK_ALLOC_DETAILS
  • XTR_STOCK_CASH_DIVIDENDS
  • XTR_STOCK_ISSUES
  • XTR_SYS_LANGUAGES
  • XTR_SYS_LANGUAGES_TL
  • XTR_TAX_BROKERAGE_RATES
  • XTR_TAX_BROKERAGE_SETUP
  • XTR_TAX_CATEGORIES
  • XTR_TAX_DEDUCTION_CALCS
  • XTR_TEMP_AUDIT_VIEW
  • XTR_TERM_ACTIONS
  • XTR_TIME_RESTRICTIONS
  • XTR_TMP_FX_EXPOSURE
  • XTR_TRANSACTIONS_INTERFACE
  • XTR_VOUCHER_REFERENCES
  • XTR_WF_USER_ROLES
  • XTR_WHATIF_DETAILS
  • XTR_WHATIF_RATES
  • XTR_YIELD_CURVES
  • XTR_YIELD_CURVE_DETAILS

Treasury Descriptive Flex Fields

Oracle Treasury module DFF list:

DFF View DFF CODE NAME DFF name
XTR_RECLASS_DETAILS_DFV XTR_RECLASS_DESC_FLEX Additional Recalssification Info.
XTR_HEDGE_RETRO_TESTS_DFV XTR_RETRO_DESC_FLEX Retrospective Tests – Additional Information
XTR_HEDGE_PRO_TESTS_DFV XTR_PRO_DESC_FLEX Prospective Tests – Additional Information
XTR_HEDGE_ATTRIBUTES_DFV XTR_ATTRIBUTES_DESC_FLEX Hedge Attributes – Additional Info.
XTR_STOCK_ISSUES_DFV XTR_STOCK_ISSUES_DESC_FLEX Stock Issues – Additional Info
XTR_HEDGE_RELATIONSHIPS_DFV XTR_HEDGE_RLTN_DESC_FLEX Hedge Relationships – Additional Info.
XTR_HEDGE_STRATEGIES_DFV XTR_STRATEGY_DESC_FLEX Hedge Strategies – Additional Info.
XTR_COUNTERPARTY_LIMITS_DFV XTR_CPARTY_LIMIT_DESC_FLEX Additional Counterparty Limits Information
XTR_COMPANY_LIMITS_DFV XTR_GLOBAL_LIMIT_DESC_FLEX Additional Global Limits Information
XTR_DEALS_DFV XTR_DEALS_DESC_FLEX Additional Deal Information
XTR_ROLLOVER_TRANSACTIONS_DFV XTR_RT_DESC_FLEX Additional Transaction Info.
XTR_EXPOSURE_TRANSACTIONS_DFV XTR_EXP_DESC Additional Exposure Info.
XTR_INTERGROUP_TRANSFERS_DFV XTR_IG_DESC_FLEX Additional info for Inter Group Deals
XTR_BOND_ISSUES_DFV XTR_BOND_ISSUES_DESC_FLEX Bond Issues – Additional Info
XTR_RM_MD_CURVES_DFV XTR_MD_CURVES_DESC_FLEX Market Data Curve Additional Information
XTR_BANK_ACCOUNTS_DFV XTR_BANK_DESC_FLEX Additional Bank Account Info.
XTR_RM_MD_SETS_DFV XTR_MD_SETS_DESC_FLEX Market Data Set Additional Information
XTR_INTERACCT_TRANSFERS_DFV XTR_IAC_DESC_FLEX Additional Inter-Account Transfer Info.