NAME: LNS: Loans Reconciliation Report
SHORT CODE: LNS_RECONCILIATION
MODULE: Oracle Loans

Description: Loans Reconciliation Report
Navigation: Oracle Loans Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• LOAN_CLASS : Loan Class Code
• LOAN_TYPE_ID : Loan Type Id
• CURRENCY_CODE : Currency Code
• BILL_DUE_DATE_FROM : Bill Due Date From
• BILL_DUE_DATE_TO : Bill Due Date To
• LEGAL_ENTITY_ID : Legal Entity Id
• LOAN_NUMBER : Loan Number
• BORROWER_ID : Primary Borrower Id
• CUST_ACCOUNT_ID : Customer Account Id
• LOAN_ASSIGNED_TO : Loan Assigned To

NAME: LNS: Receipts application engine
SHORT CODE: LNS_RC_APPL_ENG
MODULE: Oracle Loans

Description:
Navigation: Oracle Loans Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• LOAN_BORROWER_ID : Borrower Party ID
• LOAN_PRODUCT_ID : Product ID
• LOAN_ID : Loan ID
• RECEIPT_ID : Receipt ID
• RECEIPT_MATCH_CRITERIA : Receipt Matching Criteria
• RC_FROM_DATE : From Receipt Date
• RC_TO_DATE : To Receipt Date

NAME: LNS: Loans Portfolio Report
SHORT CODE: LNS_PORTFOLIO
MODULE: Oracle Loans

Description:
Navigation: Oracle Loans Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• LOAN_CLASS : Loan Class
• LOAN_TYPE_ID : Loan Type Id
• CURRENCY_CODE : Currency
• LOAN_NUMBER : Loan Number
• BORROWER_ID : Borrower
• CUST_ACCOUNT_ID : Account
• LOAN_START_DATE_FROM : Loan Start Date From
• LOAN_START_DATE_TO : Loan Start Date To
• LEGAL_ENTITY_ID : Legal Entity Id
• PRODUCT_ID : Product Id
• LOAN_ASSIGNED_TO : Loan Assigned To
• LOAN_STATUS1 : Loan Status (1)
• LOAN_STATUS2 : Loan Status (2)
• INCLUDE_CHARTS : Include Charts