Previous Next JavaScript must be enabled to correctly display this content

## 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.

Parent topic: Inter Company Loans