You are browsing the archive for Oracle Treasury.

by oracleguru

Treasury Tables

ORACLE APPS COMMUNITY > Tutorial > Financials > Oracle Treasury

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

Tags: No Comments »

by oracleguru

Treasury Descriptive Flex Fields

ORACLE APPS COMMUNITY > Tutorial > Financials > Oracle Treasury

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.

Tags: , No Comments »

by oracleguru

Treasury Concurrent Programs

ORACLE APPS COMMUNITY > Tutorial > Financials > Oracle Treasury

Oracle Treasury Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
XTRMTDAT Positions – Maturities by Date Report
XTRMTCPY Positions – Maturities by Counterparty Report
XTRCFCCY Positions – Treasury Cashflows by Currency Report
XTRCFCON Positions – Treasury Consolidated Cashflows Report
XTRCFACC Positions – Treasury Cashflows by Account Report
XTRLIUTL Positions – Limit Utilizations Report
XTRLIEXP Admin – Limit Exceptions Log
XTRTMBLS Term Money – Summary Term Current Balances Report
XTRAUNCL Admin – Cancelled Transactions Summary Report
XTRIRHED Positions – Interest Rate Hedges Report
XTRIREXP Positions – Interest Rate Exposures Report
XTRFXTAX Admin – FX Contracts Tax Gain / Loss Report
XTRFXREV Admin – FX Contracts Revaluation Report
XTRFXAVG Admin – Average FX Rates Report
XTRFXDEL Positions – FX Deal Rate versus Spot Report
XTRRTAMT Admin – Monthly Average Rates / Amounts Report
XTRJLDAT Settlements – Journals by Date Report
XTRSTDAY Settlements – Daily Payments / Receipts Report
XTRLTDAP Settlements – Daily Payments / Receipts Letters
XTRDISRE Positions – Discounted Securities Register
XTRSESTA Settlements – Status Report
XTRTMNEW Term Money – New/Settled Retail Term Money Report
XTRTMODR Term Money – Retail Term Money Aging Report
XTRTMBLT Term Money – By Type and Product Report
XTRTMSTM Term Money – Retail Term Money Statements
XTRMILNS Admin – Loan Securities Report
XTRTMAOD Term Money – Retail Term Money Overdues Report
XTRFXEXP Positions – FX Exposures Report
XTRLTIGI Intercompany – Letters
XTRTMAVG Term Money – Term Average Rates Report
XTRIGSUM Intercompany – Statements
XTRIGINS Intercompany – Interest Settlement Report
XTRRECON Program – Bank Account Reconciliation
XTRTRANS Program – Bank Statement Transfer
XTRFCAST Cash Forecasting
XTRURATE Program – Update Today’s Average Rate
XTRLTCFM Settlements – Confirmation Letters
XTRJRNAL Program – Revaluation/Accrual Related Journal Processing
XTRJNLTR Journals – Transfer to GL
XTRFCERR Cash Forecasting Execution Report
XTREXRTM Term Money – Calculate Retail Term Money Maturity Date Extensions
XTRUPLMT Program – Update Limit Utilizations
XTRUPWGH Program – Update Limit Weightings
XTRRAPRD Program – Update Retail Term Money Transaction Interest Rates
XTRCLJNL Program – Clear Journals
XTRUPACC Program – Upload Bank Account Balances
XTRCALAC Program – Generate Accruals
XTRCALRV Program – Calculate Revaluations
XTRAUDTR Program – Update Audit Summary
XTRAUSRM Admin – Audit Summary Report
XTRSETTL Settlement-Generate Report/Script
XTREFCOM EFC – Listing of Companies by Ledger
XTREFCAN EFC – Amount Comparison Report
XTRMDTRP Data Exchange – Market Data Transfer Report
XTRMDLDF Data Exchange – Market Data Load Sample File
XTRMDTSF Data Exchange – Market Data Transfer
XTRIMPRT Program – Import Deal Data
XTRRTSET Program – Reset Floating (Benchmarked) Rates
XTRREVGL Positions – Mark to Market Revaluation Summary Report
XTRCCYGL Positions – Currency Gain/Loss Revaluation Report
XTRJNLCA Program – Non-Revaluation/Non-Accrual Related Journal Processing
XTRHOAPR Positions – Outstanding Receivables / Payables Report
XTRAPRCV Program – Retrieve Payment File Confirmations
XTRGLRIA Data Exchange – Upload FX Rates to GL Using Absolute Dates
XTRGLRIR Data Exchange – Upload FX Rates to GL Using Relative Dates
XTRHDGPC Program – Calculate Hedge Percentage Allocations
XTRHIFUL Positions – Forecast Hedge Items Fulfillment Report
XTROHINS Positions – Outstanding Hedge Instruments Report
XTRSTRMC Program – Accounting Streamline Processing by Company
XTRSTRMM Program – Accounting Streamline Processing
XTRDDHAT Positions – Derivatives Disclosure by Hedge Attribute Report
XTRDDHTY Positions – Derivatives Disclosure by Hedge Type Report
XTRUPBAC Program – Update Settlement Bank Account
XTRUPREP Program – Update Settlement Bank Account Execution Report
XTRPAYSTDEF Payment Transmission Status Report
XTRPAYTRANSDEF Program – Electronic Payment Transmission
XTRRFBRS Program – Reset Floating (Benchmarked) Bond Issue Rates
XTRRETET Program – Perform Retrospective Effectiveness Testing
XTRCFCCY_XML Positions – Treasury Cashflows by Currency Report (XML)
XTRIREXP_XML Positions – Interest Rate Exposures Report (XML)

Tags: , No Comments »