You are browsing the archive for Oracle Treasury.

Program – Revaluation/Accrual Related Journal Processing

 

NAME: Program – Revaluation/Accrual Related Journal Processing
SHORT CODE: XTRJRNAL
MODULE: Oracle Treasury

Description: Program – Revaluation/Accrual Related Journal Processing
Navigation: Oracle Treasury Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Source Option : Journal Source. Set to null to represent Revaluatin/Accrual related journal batches.
  • Company : Company
  • Batch ID From : Batch ID From Range
  • Batch ID To : Batch ID To Range
  • Batch Cutoff Date : Batch Cutoff Date for Non-Reval/Accrual Related Batches
  • Dummy Sysdate : Dummy Sysdate
  • Processing Option : Processing Option. Generate, Transfer, or Generate and Transfer Journals
  • Dummy Processing Option : Dummy flag which contains a value if processing options includes transferring of batches. Otherwise, null.
  • Journals in Closed Periods : Handling option for journals falling in closed GL periods during transfer.
  • Include Transferred Batches : Flag to indicate if transferred batches are to be re-transferred
  • Multiple Accounting Periods : Checking wether the journals span over different accounting periods

 

Program – Non-Revaluation/Non-Accrual Related Journal Processing

 

NAME: Program – Non-Revaluation/Non-Accrual Related Journal Processing
SHORT CODE: XTRJNLCA
MODULE: Oracle Treasury

Description: Program to process non-reval/non-accrual related journals.
Navigation: Oracle Treasury Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Source Option : Journal source. Set to ‘J’ to represent processing of non-reval/non-accrual related batch(es).
  • Company : Company
  • Batch ID From : N/A to this SRS program. Placeholder only.
  • Batch ID To : N/A to this SRS program. Placeholder only.
  • Batch Cutoff Date : Cutoff Date of batch(es) to process.
  • Dummy – Sysdate : For validation of cutoff date
  • Processing Option : Option to Generate, Transfer, or Generate and Transfer
  • Dummy – Processing Option : Used for disabling/enabling of the ‘Journals In Closed Period’ parameter.
  • Journals In Closed Periods : Handling option for journals in closed GL periods.
  • Include Transferred Batches : Flag to indicate if previously transferred batches meeting the criteria are also to be re-transferred.
  • Multiple Accounting Period : Checking wether the journals span over different accounting periods

 

Settlements – Journals by Date Report

 

NAME: Settlements – Journals by Date Report
SHORT CODE: XTRJLDAT
MODULE: Oracle Treasury

Description: Settlements – Journals by Date 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
  • Deal Type : Deal Type
  • Deal Number : Deal Number
  • GL Date From : GL Date From
  • GL Date To : GL Date To
  • Chart of Account ID : Chart of Account ID
  • Amount Type : Amount Type
  • Transaction Amount : Transaction Amount
  • GL Account : GL Account
  • SQL Trace : SQL Trace
  • Display Debug : Display Debug
  • Transferred to GL : Transferred to GL