You are browsing the archive for Oracle Treasury.

Data Exchange – Upload FX Rates to GL Using Relative Dates

 

NAME: Data Exchange – Upload FX Rates to GL Using Relative Dates
SHORT CODE: XTRGLRIR
MODULE: Oracle Treasury

Description: Data Exchange – Upload FX Rates to GL Using Relative Dates
Navigation: Oracle Treasury Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_rel_abs : Relative or Absolute
  • p_abs_start_date : Start Date
  • p_abs_end_date : End Date
  • p_rel_end_date : End Date (number of days ago)
  • p_rel_start_date : Start Date (number of days ago)
  • p_rate_calc : Treasury Rate Calculation
  • p_bid_mid_ask : Market Data Side
  • p_conv_type : GL Rate Type
  • p_overwrite : Overwrite Existing GL Rates

 

Data Exchange – Upload FX Rates to GL Using Absolute Dates

 

NAME: Data Exchange – Upload FX Rates to GL Using Absolute Dates
SHORT CODE: XTRGLRIA
MODULE: Oracle Treasury

Description: Data Exchange – Upload FX Rates to GL Using Absolute Dates
Navigation: Oracle Treasury Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_rel_abs : Relative or Absolute
  • p_abs_start_date : Start Date
  • p_abs_end_date : End Date
  • p_rel_end_date : End Date (number of days ago)
  • p_rel_start_date : Start Date (number of days ago)
  • p_rate_calc : Treasury Rate Calculation
  • p_bid_mid_ask : Market Data Side
  • p_conv_type : GL Rate Type
  • p_overwrite : Overwrite Existing GL Rates

 

Positions – FX Exposures Report

 

NAME: Positions – FX Exposures Report
SHORT CODE: XTRFXEXP
MODULE: Oracle Treasury

Description: Positions – FX Exposures Report
Navigation: Oracle Treasury Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Company : Company
  • Currency : Currency
  • Exposure Type : Exposure Type
  • Factor : Factor
  • SQL Trace : SQL Trace
  • Display Debug : Display Debug
  • Include Intercompany : Include Intercompany