16.4 Loan Query

This topic describes the systematic instructions to query the intercompany loans booked in the system.

Specify User ID and Password, and login to Home screen.

1. On Home screen, click Oracle Banking Liquidity Management System. Under Oracle Banking Liquidity Management System, click Intercompany Loan.
2. Under Intercompany Loan, click Loan Query.
   The Loan Query screen displays.

   Figure 16-5 Loan Query

   
   

   
   Description of "Figure 16-5 Loan Query"

   
   
3. Specify the field on Loan Query screen.
   For more information on fields, refer to the field description table.

   Table 16-6 Loan Query – Field Description

   Field	Description
   Group Customer ID	Click Search to view and select the group customer ID. This selection ensures that All the transactions are related to this group customer ID only. Further selection of customer IDs are from the children of this group customer.
   Customer ID 1	Click Search to view and select the customer ID1 wherever this customer is involved.
   Customer ID 2	Click Search to view and select the customer ID2 where only these two customers are involved.
   Disbursement From Date	Select the disbursement from date. By selecting these dates, the search is restricted for the transaction between these two dates. One can choose any one of these dates as well.
   Disbursement To Date	Select the disbursement to date.
   Account From	Click Search to view and select the account. If the user is interested in transactions related to specific account(s) only, this selection will help.
   Account To	Click Search to view and select the account.
   Loan status	Select the loan status from the drop-down list. The available options are: Active Settled All
   ICL Ref No	Specify the ICL reference number to list the transactions related to only that specific ICL reference number.

4. Click Fetch to view the loan records.
   For more information on fields, refer to the field description table.

   Table 16-7 Loan Query_Search – Field Description

   Field	Description
   Loan Ref No	Displays the loan reference number.
   ICL Ref No	Displays the ICL reference number.
   Loan Date	Displays the loan date.
   From Account	Displays the from account.
   To Account	Displays the to account.
   Loan Amount	Displays the loan amount.
   Loan Status	Displays the loan status.
   Action	Displays the actions to view loan details.

5. Click View Loan to view the loan details.
   The Loan Details screen displays.

   Figure 16-6 Loan Detail

   
   

   
   Description of "Figure 16-6 Loan Detail"

   
   

   For more information on fields, refer to the field description table.

   Table 16-8 Loan Detail – Field Description

   Field	Description
   From Customer ID	Displays the customer ID of the lender.
   To Customer ID	Displays the customer ID of the borrower.
   Exchange Rate	Displays the exchange rate between the currencies of lender and borrower.
   Maturity Date	Displays the exchange rate between the currencies of lender and borrower.
   Loan O/S	Displays the maturity date if this is a fixed tenure loan. Else, This field will be blank.
   Loan Currency	Displays the current outstanding loan amount.
   Mode of Booking	If this loan is created using the structure and sweep mechanism, the mode of booking will be “Auto”. As of now, only this mode of booking is available in the system.
   Sweep ID	Displays the ID of the sweep with which is amount is transferred and loan is created.
   Sweep Log ID	Displays the log ID of a sweep.
   Structure ID	Displays the structure ID through which the loan transaction took place.
   Structure Description	Displays the description of the structure that is involved in the loan transaction.