After you query or save the common deal details for a short term money deal, you can work with the transactions that comprise the deal. You can enter the transaction details for short term money deals using the Short Term Money window or the Quick Deals window.
Use the Short Term Money window to enter the transaction details for your short term money deals.
If your short term money (ONC) deals' principal or interest is subjected to taxes, Oracle Treasury provides the following tax options:
calculate flat tax on the interest amount (INS_F)
annual tax on the principal amount (PRN_A)
flat tax on the principal amount (PRN_F)
For more information, see: Tax Schedule and Details.
Identify or add general deal information. See: Common Details for Short Term Money Deals.
Define Tax Rates and Schedules. See: Tax Schedule and Details.
Navigate to the Short Term Money window.
In the Common Deal Details region, choose the deal that you want to enter a transaction for, then choose the Transactions button. The Transaction Details window appears. The Dealer field is automatically populated based on the application user login. The Deal Status field is CURRENT for new deals, and the Deal Date field is populated with the current system date.
Tab through the Deal Subtype, Company, Counterparty, Client, Currency, Day Count Basis, and Portfolio fields. The data from the Common Deal Details region of the Short Term Money window appears.
Choose the Main Details tab region.
In the Security Type field, choose the security type for the short term money deal. The possible security types are Secured or Unsecured.
In the Product Type field, choose a product type for the deal.
In the Settlement Date field, enter a settlement date for the deal.
If the transaction has a pre-set maturity date, in the Maturity Date field, enter the maturity date. The Days field displays the number of days between the settlement date and the maturity date.
If you want to link the transaction to another transaction or group of transactions, in the Link Code field choose a link code. For more information on Link Codes, see: Deal Linking Codes.
In the Principal Amt field, enter the principal amount for the transaction.
If you want to apply a limit to the transaction, in the Limit field choose a limit.
Choose the Interest Details tab region and complete the following fields as necessary:
Interest Rate: Enter the interest rate that applies to the transaction.
Note: The interest rate field is mandatory. Once you save the short term money transaction details, you cannot change the deal interest rate unless the deal interest rate is zero. Therefore, if you do not know the deal interest rate at the time of deal entry, enter an interest rate of zero. Then, when you find out the interest rate, you can re-query your transaction, enter the interest rate and re-save.
Interest Amount: If you want to override the system calculated interest amount, enter a new interest amount. You can only add an interest amount if a Maturity Date is specified for the deal. Maturity Dates are specified in the Main Details tab region.
Note: You can only override interest amounts if you have the appropriate user access levels. See: User Access Levels.
System Interest: The total accrued interest for the transaction as calculated by the system.
Interest Rounding (Display only): The interest rounding method. The possible choices are: Nearest, Round Up, or Round Down.
Interest Includes (Display only): The days you want to include in your interest calculations. The possible choices are: First Day, Last Day, or Both Days.
Note: The Interest Rounding and Interest Includes fields are defaulted from the information that you entered in the Common Deal Details region and cannot be changed.
Prepaid Interest check box: Enable this option if you intend to settle the interest on this deal on the deal start date. You can only enable this option if a Maturity Date is specified for the deal.
Interest Due On (Display only): This field displays the date interest is due to be settled. If you enable the Prepaid Interest option, the field displays the deal start date. Otherwise it displays the deal maturity date.
Prepaid Interest Refund (Display only): If you enable the Prepaid Interest option and later renegotiate the deal, this field displays a refund due on the renegotiated prepaid interest deal prior to maturity and after interest was paid.
Choose the Additional Details tab region and complete the fields as needed.
In the Brokerage/Tax tab region, complete the fields as needed.
Save your work.
To add another transaction for this deal, choose the New Transaction button.
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 or View Deals windows.
Identify or add general deal information. See: Common Details for Short Term Money Deals.
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.
Enter the deal details. For information on how to enter quick deal details, see: Quick Deals.
You must complete the details for a short term money deal to view your short term money quick deals in the Transaction Details window.
In the Common Deal Details region of the Short Term Money window, query the common deal details for the deal that you want to complete. Then, choose the Quick Input button. The Quick Deals window appears.
Select the deal transaction that you want to complete and choose the Complete Details button. The Transaction Details window appears, displaying the information that you already entered on the Quick Deals window.
To complete the remaining fields, see: Entering Short Term Money Deals.
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.
In the Short Term Money window, query the common deal details of the transactions that you want to consolidate.
Choose the Consolidate button. The Renegotiation Criteria window appears.
In the Criteria For Reneg Repay region, define the criteria you want to use to select the transactions to renegotiate by entering or changing information.
In the Default Details For New Renegs region, enter the default values for the consolidated transaction.
Use the following buttons, as needed, to consolidate your transactions:
Open Transactions. The Open Transactions for All Counterparties window appears. This window lists all of the open short term money transactions that have not yet been consolidated and groups the transactions that are eligible for consolidation.
Default Details. The Select Renegotiations Criteria window appears. Use this window to define the default details for the transactions that you are going to renegotiate.
Get Records. Use this button to populate the Open Transactions window with the list of all open short term money transactions.
Save your work.
Use the Renegotiation Details window to renegotiate the repayment terms for transactions in a short term money deal. You can enter information related to the increase or repayment of principal on short term money transactions, as well as the new interest rate and maturity date.
If your transaction includes the prepaid interest option and the interest amount has been authorized for settlement or journalized, renegotiating such a transaction before the maturity date will result in an interest refund.
In the Common Deal Details region of the Short Term Money window, query and then select the deal that you want to renegotiate.
In the Current Transactions for Above Deal tab region, choose the transaction that you want to renegotiate and choose the Select Above Row for Reneg button. The details for the transaction appear in the Renegotiation Details window.
To consolidate and renegotiate a transaction, check the Reneg check box next to the transaction. If you want to renegotiate all of the transactions at the same time, check all of the check boxes. Only the records that have the Reneg check box checked are saved.
In the Reneg Date field, enter the date that you want to renegotiate the deal transaction. The default date is either the transaction maturity date or the current system date.
In the Accrued Interest field, the total amount of accrued interest appears. You can override this calculated interest amount by entering a new interest amount. The System Interest field shows the original interest amount calculated by the system.
Note: You can only override interest amounts if you have the appropriate user access levels. See: User Access Levels.
In the Interest Action field, select the action you want to perform for the interest that has accrued to date. If the transaction has prepaid interest, the interest action defaults to None and cannot be updated. The choices are:
COMPGRS: Compound Gross Interest
COMPNET: Compound Interest Net of Tax
NONE: No Action
SETTLE: Settle Interest
In the Client Settle Via field, choose a method that the client will use to settle the interest on the transaction. The choices are:
Clearing Account
Direct to Cparty
On Account
In the Principal Action field, choose the action that you want to perform on the principal. The choices are:
Increase: Increase the principal balance.
Decrease: Decrease the principal balance.
None: Perform no action.
If you chose Increase or Decrease in the Principal Action field, in the Principal Adjustment field enter the amount to increase or decrease the principal. The balance is recalculated and appears in the Balance Carry Fwd field. If the Prepaid Interest option is enabled, Treasury recalculates the prepaid interest on the new principal.
If you increase the principal, Treasury calculates the principal tax, interest tax, and brokerage fee according to the schedule. The Brokerage Amount field displays the brokerage fee. The Brokerage/Tax tab region of the Transaction Details window displays the principal and interest tax.
In the Client Principal Via field, choose a method that the client will use to settle the principal on the transaction.
In the Rate field, enter the rate that applies from the renegotiation date onward.
If necessary, choose the new Product Type.
If necessary, update the Maturity Date. You must enter a date if the transaction includes prepaid interest.
The Prepaid Interest check box indicates whether the original transaction included prepaid interest. If the transaction included prepaid interest, the Interest Due On field displays the renegotiation date. Otherwise it displays the deal maturity date.
In the Brokerage Amount field, you can manually enter a brokerage amount if you want to override the system-calculated brokerage amount for the transaction.
Save your work.
Use the View Short Term Money window to view the details of a short term money deal.
In the View Short Term Money Deal window, query the deal you want to view.
If you want to view a list of short term money quick input deals, choose the Quick Input button.