Oracle Treasury Managment Implementation

Unlock the full potential of Oracle’s Treasury Management with our comprehensive guide to implementing the R12 Treasury Solution. This presentation is designed for financial professionals and system administrators aiming to streamline their treasury operations, enhance control over financial instruments, and ensure compliance with organizational policies.

Course Objectives:

Set Up Oracle Treasury:

Perform required setup steps for Oracle’s Treasury Solution.
Define system parameters, user access levels, and currency details.
Policy and Control Implementation:

Identify and implement various policies and controls.
Set up and manage policies related to brokerage, limits, settlement accounts, and audit requirements.
Deal Management:

Enter and manage deals ensuring compliance with policies.
Generate and interpret reports to support decision-making.
Key Features of Oracle Treasury:

Complete Solution: Manage a wide range of financial instruments and transactions.
Integrated System: Seamlessly integrates with other Oracle applications.
Policy Support: Define and manage detailed policies for currency, limits, and user access.
User Access Management: Securely manage user access.
Currency Management: Set up and manage currency details, spot rates, and combinations.
Setup Overview:

System Installation and User Setup:

Install Oracle Treasury.
Define user IDs, passwords, access levels, and assign companies and deal types to users.
Configuring System Parameters:

Set up GL sets of books, accounting periods, legal entities, and transaction calendars.
Define chart of accounts and system parameters.
Currency and Policy Setup:

Add and authorize currencies.
Define currency details and manage currency combinations and FX policies.
Managing Deals and Settlements:

Enter and validate deals.
Authorize and settle deals, generate reports.
Additional Features:

Brokerage Details: Manage brokerage settings.
Limit Policies: Establish transaction limits.
Settlement Accounts: Define default settlement accounts and manage confirmations.
Tax and Audit Requirements: Ensure compliance with tax and audit requirements.
Tips for Effective Implementation:

Start with one superuser for setup.
Incrementally add users as configuration progresses.
Ensure necessary currencies are defined in General Ledger.
Customize out-of-the-box configurations as needed.
This presentation provides a detailed roadmap for implementing Oracle Treasury, making it an essential resource for optimizing treasury management processes. With step-by-step instructions, best practices, and insights, you will be equipped to leverage Oracle’s powerful tools for effective treasury operations.

Target Audience:

Financial Managers and Analysts
System Administrators
IT Professionals in financial systems
Treasury Managers
Unlock the full potential of your financial operations with our detailed guide to Oracle Treasury. Download the presentation now and start transforming your treasury management!

1. R12 Implement Treasury Management

2. At the end of this course, you should be able to: Perform the required setup steps of Oracle’s Treasury Solution Identify the types of policies and controls supported by Oracle Treasury Enter and manage deals and reports supported by Oracle Treasury High level overview of Oracle’s Treasury Solution Objectives

3. Oracle’s Treasury Solution A Complete Solution

4. Oracle’s Treasury Solution An Integrated Solution

5. Support a Comprehensive List of Financial Instruments

6. “Understanding how to set up Oracle Treasury is the key to understanding this system.” Overview of Oracle Treasury Setup Brokerage Schedule and Details Step 38 Limits Policy Step 31 Default Settlement Accounts Step 25 Portfolios Step 19 Currency Details Step 13 Additional Rate Types Step 7 Install Oracle Treasury Step 1 User Sign- Ons and Passwords Step 2 GL Set of Books Name profile option Step 8 Counterparty Profiles Step 14 Journal Entry Actions Step 20 Default Settlement Actions Step 26 Deal Confirmation Groups Step 32 Tax Schedule and Details Step 39 Current System Rates Step 40 Deal Confirmation Template Step 33 Party Groups Step 27 Audit Requirements Step 21 Company Profiles Step 15 Transaction Calendar Step 9 Chart of Accounts Step 3 Accounting Periods and Calendar Step 4 Legal Entities Step 10 Deal Types/ Product Types Step 16 Bond Issues Step 22 Import Sources Step 34 System Languages Step 42 Request Sets Step 43 Payment Schedules Step 35 Deal Rate Tolerances Step 29 Bill/Bond Issue Numbers Step 23 Assign Companies and Deals to Users Step 17 User Access Levels Step 11 Enable Currencies Step 5 Set of Books Step 6 System Parameters Step 12 Currency Holiday Rules Step 18 Exposure Types Step 24 Interest Rate Policies Step 30 Descriptive Flexfields Step 44 Market Data Curves and Sets Step 41 Bank Account Interest Setoffs Step 28 Forecasting Open Interface Step 36 Forecast Template Step 37

7. When you set up a Treasury user, you define: Treasury User IDs and passwords (mapped to Oracle Application IDs) Access to companies Access to deal type, subtype, and product type combinations for deal entry As a default, every Treasury user has access to every authorized deal type. Companies must be assigned. User Access Levels

8. Define all Treasury users as Oracle Applications users first Define at least one Treasury user with Superuser responsibility to complete the setup Don’t add all your users at once Add a user to set up Treasury Set up your company and deal information Return to add other users later Tips for Setting Up User Access Levels

9. Oracle Treasury, and Oracle Risk Management provide common configurations “out of the box” Your System Administrator can modify or create your own Responsibilities based on any specific needs you may have Grant or restrict access to screens Responsibilities / Business Roles

10. Treasury  Setup  System  User Access Level User Access Levels

11. Currency Details To set up a currency in Treasury, it must be defined in General Ledger, first. When you set up a currency, you must: Add the currency Define spot rates Authorize the currency Authorize the currency combinations Do not set up currency limits at this time

12. Treasury  Setup  Policies  Currency Detail Currency Details

13. If you want the currency to appear at the top of the list of currencies in the Currency field of the foreign exchange deal input windows, in the FX Sequence field enter a foreign exchange sequence number for the currency. For example, if the top 5 currencies you use in foreign exchange trading are GBP, USD, CAD, JPY, and KRW, enter 1, 2, 3, 4, 5 in the FX Sequence field for the respective currencies. In the Quotation Basis Against USD field, choose a quotation basis for the currency. The quotation basis determines how the currency is quoted against the U.S. dollar. Base unit quote : Choose base unit quote if you are using the currency as a ledger currency against the USD dollar and for foreign exchange quotes. For example, in a DEM/USD quote, DEM is the ledger currency. Commodity unit quote : Choose commodity unit quote if you are quoting the currency against USD, or against another base unit quote currency. For example, in a USD/DEM quote, DEM is the contra currency. If you want to assign a GL calendar to a currency, in the GL Calendar field, select a GL calendar to define the non-business days. Currencies without a matching GL calendar will assume Saturday/Sunday weekend days. Currency Details

14. To be able to authorize a currency, you will need to define: Data feed code for the spot rate Reference Code on the Current Rates tab Spot rate against the USD However, you don’t have to record the cross rates In practice, you can use the Market Data File Loader Program to import any type of system rate Currency Detail(Spot Rate)

15. Currency System Rates

16. Currency System Rates(Current Rate)

17. Currency Detail(Authorized)

18. Adding and Authorizing Currencies As you add a currency in Treasury, you also define the following: Foreign Exchange Exposure Limit (optional) Foreign Exchange Sequence (optional) Money Market Sequence (optional) Year Basis Rounding Factor Day Count Basis (optional) Holiday Forward Years ( optional) If you want to deal a currency, you must authorize that currency for use in Treasury. You cannot authorize a currency unless you have set up a spot rate for that currency against the U.S. dollar.

19. Currency Combinations To define a currency combination: Define a currency combination between every authorized currency and the USD Define other currency combinations that your company deals in or monitors Authorize your currency combinations If you don’t authorize a currency combination you can still monitor that combination, but can not record deals of that combination Treasury cannot calculate foreign exchange cross rates if you do not define this currency combination. Remember that the order of the currencies in a currency combination is very important. For example, specify USD/JPY, not JPY/USD if the rate quoted is 120.00.

20. Treasury System Parameters Treasury  Setup  System  Treasury System Parameter

21. Treasury System Parameters Parameter Value Description Accrual Days Adjustment Type Forward or Arrears (default). Sets the range of dates for accruals to either all dates prior to the accrual date (Forward), or to all dates up to and including the accrual date (Arrears). Days Forwards as Default FX Value Date Numeric. The default is 2. The number of days that Treasury uses as a default for the spot date on foreign exchange deals. Default Company as Drawer, Acceptor, or Endorser Drawer (default), Acceptor, or Endorser. If the deal subtype is Issue, Treasury uses Acceptor, Drawer, or Endorser as the default for the company code. Display Warning After Limit Check Yes or No (default). Displays a warning if you exceed a limit.

22. Treasury System Parameters Validate Deal Input Yes or No (default). Validates deal input for correctness before any settlements can be authorized. Validation Required for Confirmations Yes or No (default). Determines whether validated deals or all deals are available for generating confirmation letters. Validation Required for Accounting Yes or No (default). Determines whether the journal process creates journals for validated deals and transactions only or all deals and transactions. Use Period End Rates for FX Realized Deals Yes or No (default). Uses the end-of-month rate for performing settlements rather than the actual rate on the date the deal matures. If you select No, you must maintain your daily GL rates tables. Settlements: Automatically Authorize Interaccount Transfers Yes or No Determines whether inter-account transfers are manually or automatically authorized. If set to Yes, the system automatically authorizes inter-account transfers for settlement. If set to No, you must manually authorize inter-account transfers for settlement.

23. Treasury System Parameters Limit Checks on Quick Input Yes (default) or No. Performs limit checks when creating deals by using the Quick Deal Input window. Settle to Other than Counterparty Bank Account Yes or No (default). If set to Yes, allows settlements to be paid to parties other than the counterparty. Receive to Other Than Company Bank Account Yes or No (default). Allows settlements to be received from or settled to parties/accounts other than the company accounts. Treasury Report Currency Currency short form. USD (default). Sets the standard currency used in Treasury reports.

24. What is a Deal? Why are they made? A trade, a transaction A contractual agreement between two parties to exchange an underlying at an agreed point in time Similar to you as an individual, corporations are quite concerned with their cash flows Short cash, excess cash, foreign exposures... Deals are made to maximize ROI and minimize COF within some acceptable level of risk

25. Deals Foreign Exchange (FX) deals Money Market (MM) deals Equity Market (Stock) deals A deal is a transaction or a series of transactions between a company and a counterparty

26. Money Market Deals Short Term Money Intercompany Funding Retail Term Money Wholesale Term Money Negotiable Instruments Fixed Income Securities Discounted Securities

27. Short Term Money Deals Any deal that meets a company’s short term money requirements Bank can request payment with same day, 1 day, or 2 day notice You can: Renegotiate or repay the deal once it reaches maturity Repay all or part of the principal Reset the interest rate or term Accrue, settle or compound the interest

28. Deals Three ways to enter a deal: Main deal input screens Quick deals (ONC & FX) Open interface or electronic feed

29. Quick Input Quick input allows you to capture multiple quotes on short term money and foreign exchange transactions.

30. Parties In Treasury a deal is conducted between two parties The two parties supported by Treasury are: Companies Counterparties

31. Counterparties You cannot generate journal entries for a counterparty Counterparties can be any of the following: Banks Brokers Tax Authorities Clients Subsidiaries Dealers

32. Counterparty or Company? To decide if a subsidiary is a company or a counterparty, ask yourself the following questions: 1. Do you want to generate journal entries for the subsidiary? 2. Do you want to be able to track the treasury activities of the subsidiary?

33. Counterparty Treasury  Setup  Parties  Counterparty Profile

34. Counterparty Profile Use the Counterparty Profiles window to set up the internal and external counterparties that your company does business with. You cannot generate journal entries for counterparties. An internal counterparty is any subsidiary that is part of a company group that you do not want to generate journal entries for. For example, a parent company, Vision Corporation, can set up internal counterparties for each of its subsidiaries: Vision North America, Vision Asia Pacific, and Vision Europe.

35. Counterparty Profile To designate counterparty as an internal counterparty you must cross-reference the counterparty to its parent company. This cross-reference creates an intercompany group . A parent company can have several internal counterparties assigned to its intercompany group. Once counterparty is assigned to an intercompany group, it can enter into intercompany funding and inter-account transfer deals with the parent company. The bank accounts for the internal counterparty can also be collected into a notional cash pool. An external counterparty is any other party that a company enters into deals with, for example, banks, brokers, or clients. If there is a relationship between two or more external counterparties, you can indicate the relationship by cross-referencing the counterparties to one another and creating a counterparty group .

36. Counterparty Profile Tab (Settlement Account Detail )

37. Company Profile Prerequisites for Setting Up a Company In General Ledger: Set up a legal entity for each company you are going to set up (one to one mapping) In Treasury: Define the company’s banks as counterparties Authorize the currencies used by the company

38. Company For each company, define the following: Header information Address (optional) Bank account details Settlement and Deal contacts (optional) Debit authorities (optional) Company parameters Settlement scripts (optional)

39. Company Profile Treasury  Setup  Party  Company Profile

40. Company Profile

41. Company Profile Click Bank Accounts Tab to setup and enable check box for “Treasury use” in Banks Accounts page.

42. Company Profile

43. Company Profile(Debit Authorities)

44. Deal Type Bond Buy TMM Sell Corp Subtype Product Type Fund Invest Vision Inc. Vision Services Companies Govt IRS Structured Balloon Fund Invest Currency Swap Accreting Principal Swaps APS Deal Type / Product Type at System Level

45. Deal/Sub Type and Product Types Entering deals is a key feature of Treasury. There are 16 different types of deals (for example, bonds, forward rate agreements, options) and 3 other deal-related items (deal orders, exposures, and external exposures) that you can enter in Treasury

46. Deal/Sub Types and Product Types Deal Subtype: The deal subtype determines the cash flow direction and, as a result, the accounting for each deal. For example, Forward Rate Agreement deals have a deal subtype of either Fund or Invest, whereas Foreign Exchange Option deals have a deal subtype of either Purchase or Sell. For a list of available deal subtypes supplied by Treasury . Product Type: The product type is a user-defined attribute that you can use to distinguish between similar deals with different accounting methods. You must define at least one product type for each deal type that you intend to use, except for current account balance transactions and intercompany transfer transactions. Deal Status: Each deal has a set of deal statuses that can be assigned to it over the entire life of the deal. For example, current, cancelled, expired, or closed. The deal status can change automatically based on an action taken (for example, exercising an option or reselling a discounted security) or it can be manually changed (for example, changing an option status to Expired). For a list of available deal statuses supplied by Treasury.

47. Deal/Sub Types and Product Types Date Type: Each deal has a set of date types that are used for settlement, accounting, and reporting purposes. For example, a bond has several dates associated with it: start date, maturity date, and coupon date. For a list of date types by deal type. Amount Type: Each deal has a set of amount types, such as a deal's principal amount, interest amount, and adjusted interest amount. For a list of available amount types supplied by Treasury. You can create additional amount types for retail term money deals only. Action: Some amount types have a set of actions that determine the cash flow accounting for the amount. For example, interest amounts can be paid or received, or an accrual can be an original posting or a reversal. For a list of available amount types supplied by Treasury . Pricing Model: The pricing model is used to calculate the fair value of the deal during a mark to market revaluation. A set of default pricing models is supplied by Treasury. You can create custom pricing models for each deal type. For a list of pricing models supplied by Treasury

48. Deal/sub Types and Product Types Treasury  Policies  Deals Types/Product Types

49. Deal/sub Types and Product Types

50. Deal/sub Types and Product Types

51. Deal/sub Types and Product Types

52. Deal/sub Types and Product Types

53. Portfolios Portfolios separate your accounting or reporting functions You can designate each portfolio as: Default portfolio Internal portfolio External portfolio TIPS in setting up Portfolios: Have at least one portfolio per company Minimize the number of portfolios you define Portfolios are essential to the Treasury accounting structure. For each portfolio you create you must set up an entirely separate set of deals, deal subtypes, and product types within your journal structure Minimize the number of portfolios you create. To make it easier for you to maintain your deals, deal subtypes, and product types,

54. Portfolios Treasury  Setup  System  Portfolio Code

55. Journal Entry Actions Journal Entry Actions automate how your journals are created and sent to General Ledger.

56. Journal Entry Actions Defines the method for posting each deal type-deal subtype-product type combination to a particular journal To set up a journal entry action, you need to define: GL accounts for the company Intercompany group GL accounts Journal structure for each deal, deal subtype, product type, and portfolio combination

57. Journal Entry Actions To define a journal structure: Define the deal, subtype, product type, and portfolio combination Select one of the following destinations: GL account Cash flow bank account Intercompany group GL account

58. Journal Entry Actions Flexible Journaling was introduced to allow greater flexibility in creating accounting entries You can now run revaluation or accruals at a different frequency than that for journal entries Also, a number of additional features include: Allowing or disallowing unbalanced journal batches to transfer to GL. Effective From Dates are added in setup Submit journals for one or all companies Ability to transfer detailed journal information Prevent posting entries to a closed GL period Ability to recalculate the functional currency debit/credit journals when changing dates

59. Tips for Setting Up Journal Entry Actions View every instance of particular GL account by using Query by GL Time Savers: Copy the journal structures for one deal combination to any other combination with the same deal type Copy the structures for one portfolio into another portfolio

60. GL Account & Journal Entry Action Treasury  Setup  System  Journal Entry Action

61. Journal Entry Action(GL Account Tab) Use the GL Accounts tabbed region of the Journal Entry Actions window to define General Ledger accounts for each company. You can add new accounts and review existing accounts, but you cannot change or delete existing accounts. The available General Ledger accounts derive from the ledger associated with the company . In the Treasury Reference field, you can enter your own description to identify this GL account. The Treasury reference that you enter appears alongside the GL account number in the list of values throughout Treasury.

62. Journal Entry Action(IC Account Tab) Intercompany accounts help when the organization has several affiliates and subsidiaries and needs to track transactions from and to these entities. The Intercompany Accounts tabbed region is used to review and update the intercompany accounts for intercompany funding deals within a company. These intercompany accounts are used for intercompany transfers and interest charges In the Principal GL field, enter the General Ledger account that you want to use for posting the principal for that company. In the Interest GL field, enter the General Ledger account that you want to use to posting interest for that company .

63. Journal Entry Action(Journal Structure Tab )

64. Journal Entry Action(Journal Structure Tab ) Use the Journal Structures tabbed region is used to set up the actual journal structure. you define for each applicable company name, the daily journal entries that you want to generate automatically

65. Journal Entry Action(Journal Structure Tab ) Firstly query the first Deal Type, Deal Subtype, Product Type and Portfolio combination that you want the general ledger number related to the company's cash flow bank account, select the Bank GL check box. Otherwise, enter an account number in the GL Account field.

66. Journal Entry Action(Journal Structure Tab ) If this is an intercompany funding deal, direct journal actions to either the principal or the interest General Ledger account number by selecting the Prin GL or the Int GL check box. check boxes are only available for non-accrual and non-revaluation date types. Identify the action as a Debit or Credit. If necessary, enter the effective dates for this journal action . You can enter a future date in the ‘Effective From’ field to pre-define a journal action. You canuse the ‘Effective To’ field to deactivate a journal action after the date you specify.

67. Journal Entry Action(Journal Structure Tab )

68. Journal Entry Action(Query GL Account) You can review the deal combinations that were set up for a specific General Ledger account . To do this enter the company code of the company whose General Ledger account you want to review and choose the Query by GL Account tab. The Find GL Accounts window appears. Select a General Ledger account and choose the Find button. The journal entry actions for that General Ledger account appear.

69. Enter Short T erm Money Deals This section describes the deals that you perform when you borrow or invest funds on a short-term basis. For short term money deals, a party to the deal can request payment with same day, one day, or two days notice. Each time you renegotiate or rollover a deal, you can repay all or part of the principal, increase the principal, or reset the interest rate and term. You can also choose to settle or compound the interest. Each short term money deal can consist of one or more transactions. The window contains two main regions: The Common Deal Details region of the window contains general information that identifies the deal. The Current Transactions for Above Cparty and the Trans History for Above Cparty tabbed regions list individual transactions associated with the deal that you identify in the Common Deal Details area of the window.

70. Enter Short T erm Money Deals(Quick Deal) Entering Short Term Money Quick Deals You can also use the Quick Deals window to enter short term money deals. Using this window you can enter the most important information when you make the deal and then return to the quick input deal and complete the deal details when you have more time. You must complete the deal details before you can view your short term money quick deals in the View Short Term Money To enter a short term money deal quickly 1. In the Common Deal Details region of the Short Term Money window, query or enter the common deal details for the deal that you want to enter quick transactions for. Then, choose the Quick Input button. The Quick Deals window appears. 2. Enter the deal details. For information on how to enter quick deal details

71. Enter Short T erm Money Deals(Consolidated Deal) You can consolidate short term money transactions with similar details. Consolidating transactions minimizes the need to repeat the same actions. For example, if a deal contains three separate deposits with the same counterparty, you can combine them into a single deposit to avoid renegotiating the transactions separately.

72. Enter Short T erm Money Deals(Entering Deals) Treasury  Money Market  Short term money

73. Enter Short T erm Money Deals(Entering Deals)

74. Validate Deals You should validate your deal transactions before settling them. Validating your transactions is mandatory if you choose the Validate Deal Input option in the System Parameters window. If you validate a wholesale term money deal or retail term money deal and then go back and make a principal or interest adjustment on the deal, the validation is removed. You need to confirm that the deal is correct and validate the deal again before you can settle the transactions.

75. Purpose of Validation Validation Process in Oracle Treasury is an additional level of control to insure : Company Policy is enforced correctly Only specific USER can perform certain operations, who are allowed to perform such actions. System is only checking, USER authorization and also the Other System parameters.

76. Automatic Validate of Deal The expectation that the deals will automatically be validated if Validate Deal Input is set to 'YES' is wrong. The meaning of 'validate deal input' as per the original intended design is following: 1). If the system parameter "Validation Deal Input" = NO, then on the Settlements form the user can drill down to the cash flow level and authorize it for settlement without validating it first. It should be noted that the user can  STILL validate the deal in the Transaction Validation form even if the parameter is set to NO. This, however, will not affect the availability for settlement authorization. 2). If the system parameter "Validation Deal Input" = YES, then on the Settlements form, if the user drills down to the cash flow level and tries to authorize it for settlement without validating it first, then they will see an error message and this action will not be allowed . 3). Somewhere in between then and now, the original intended meaning of these parameters was misconstrued and changed to 'automatic validation' form the intended 'validation not required'. But that is not correct.

77. Validate Deals(Entering Deals)

78. Enter Short T erm Money Deals(Entering Deals)

79. Validate Deals(Entering Deals)

80. Confirmation Letter You can produce one-page confirmations for most deal-related actions and send a print or file version of the confirmation to counterparty. You can print confirmation letters manually or choose to produce them automatically when you confirm a deal. Confirmation templates define the layout of your deal confirmations. You can create your own template, copy an existing template, or use the standard templates provided with Treasury You can create different confirmation templates for a particular deal type or deal action. For example, you can create a confirmation template to confirm an initial option deal and another template to confirm the exercise details for the option deal. You can create more than one template for a deal action, but you can set only one template as the default.

81. Confirmation Template You can produce one-page confirmations for most deal-related actions and send a print or file version of the confirmation to counterparty. You can print confirmation letters manually or choose to produce them automatically when you confirm a deal. Confirmation templates define the layout of your deal confirmations. You can create your own template, copy an existing template, or use the standard templates provided with Treasury You can create different confirmation templates for a particular deal type or deal action. For example, you can create a confirmation template to confirm an initial option deal and another template to confirm the exercise details for the option deal. You can create more than one template for a deal action, but you can set only one template as the default . You cannot print confirmation letters for retail term money adjustments through this window

82. Confirmation Group Deal Confirmation Groups A confirmation is a document that one party sends to another describing all the relevant details about a transaction. If a deal consists of one or more actions, each of which may require confirmation, you can group several confirmations into a single deal confirmation group. For example, a deal confirmation group for a foreign exchange option may consist of two confirmations: one for the trade and one for exercising the option. If you want to use confirmations, then you must define at least one confirmation group . Use the Confirmation Groups window to define different groups of transactions that require confirmation. Once defined, you can assign confirmation groups to parties in the Counterparty Profiles window.

83. Settlement Deals Using the Settlements window, you can also manage your settlement process. You can pre-authorize future settlements, change the default settlement details for a deal, split a settlement between different accounts or parties, or net all the settlements between your company and another party . In addition, you can generate payment instructions and transmit payments electronically.

84. Settlement Deals

85. Settlement Deals

86. Settlement Deals(Authorized) Use the Settlements window to identify, query, validate, and authorize your settlements. You cannot initiate payment instructions until you authorize settlements for the deals. For Exposure transactions, you also cannot generate journal entries until you authorize the settlements for the transaction.

87. Settlement Deals(Authorized)

88. Settlement Processed

89. Settlement Authorized

90. Settlement Voucher Creating Settlement Vouchers Use the Vouchers window to record settlement vouchers for your reference. To create a settlement voucher In the Settlements window, select the settlement for which you want to create a voucher. Choose the Maintain Settlements button. The Maintain Settlements window appears. Choose the Vouchers button. The Vouchers window appears. In the Reference field, enter a reference number for the voucher. In the Amount field, enter the amount for the voucher. In the Comments field, enter any comments about the voucher. Save your work.

91. Generate Journal Use the Daily Journals window to generate the daily journals for an accounting batch, view the generated journal entries, change the dates or GL accounts for your journal entries, and reallocate suspense journal entries to a GL account. After you enter and verify all accounting changes for the journal, use the Transfer Journals to GL window to transfer your journals from Treasury to General Ledger. Once you transfer your daily journals to General Ledger, you cannot change any of the accounting for the batch in Treasury. If you once transfer Journal into GL so you cannot change your journal.

92. Generate Journal Please note: SLA is not implemented in Oracle Treasury R12.1.3 or before. Currently there is no indication has been given as to whether it will be available in later versions. In any release where SLA is available, the customer has the option of buying Financial Accounting Hub that allows plugging in any third party application into SLA . If the customer is inclined to have everything go through SLA, they can build a customization that will divert Treasury journals into Financial Accounting Hub instead of going to GL directly. But this will be a 100% customization.

93. Generate Journal Treasury  Accounting  Daily Journal

94. Accounting Journal Revaluation/Accrual Related Journal Processing "Non-Revaluation/Non-Accrual Related Journals" creates journal entries for " cash“ A mounts (principal transfers, interest settlements, deposits, etc.). If you select this type in the batch Source region, then you will be required to enter a Cutoff Date in order to generate journals. A Cutoff Date allows you to specify up until what date you want to journalize "cash" amounts. If you want to capture everything, set this date equal to today's date ( futuredating is not allowed ). If you set the Cutoff Date equal to, say, March 1, 2003, only those "cash " amounts in the system that are dated March 1, 2003 or prior will be journalized . Non-Revaluation/Non-Accrual Related Journal Processing can be run any time and does not go through the revaluation, accrual cycle .

95. Accounting Journal The second batch type is called "Revaluation/Accrual Related Journals" and it creates journal entries for all amounts ("cash", revaluation, accrual). The pre-requisite for this type of a journal batch is, thus, the creation of Revaluation and/or Accrual batch. If you select this batch type in the Batch Source region, then you will be required to enter a Batch ID that has been generated when you finished running Revaluation and/or Accruals.

96. Accounting Journal

97. Concurrent Request of Accounting

98. Transfer Journal into GL If your journal batch contains entries with journal dates that fall into a closed GL period, you can optionally post these entries to the next open GL period. If you choose this option, Treasury maintains a record of both the actual journal date and the new posting date . You can choose to allow the transfer of unbalanced journals to GL by setting the company parameter ‘Accounting - Allow Unbalanced Journal Transfer (Yes/No)’ in the Company Profiles window. Daily journals are transferred to General Ledger in both the transaction currency and the set of books currency equivalent. The rate used to calculate the set of books currency equivalent is drawn from the GL RATES table. This calculation takes place when you generate daily journals .

99. Transfer Journal into GL

100. Transfer Journal into GL