12. Oracle Financial Services Lending and Leasing Reports
During the day, or at the end of the day, you may want to retrieve information on any of the several operations that were performed during the day in your financial institution. You can generate this information in the form of reports in Oracle Financial Services Lending and Leasing. You can specify the values in the Report Parameters section and generate a report using that information.
Navigation to Reports
On the Oracle Financial Services Lending and Leasing home page, click Servicing > Servicing > Reports.
12.1 Accounts Payable Log By Customer
This servicing report lists accounts payables, sorted by customer.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Accounts Payable Log By Customer report
12.2 Accounts Payable Log By Producer
This servicing report lists accounts payables, sorted by producer.
Parameters:
- Company/Branch
- Producer
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Accounts Payable Log By Producer report
12.3 Accounts Payable Log By Third Party
This servicing report lists accounts payables, sorted by third party.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Accounts Payable Log By Third Party report
12.4 Accounts Payable Log By Vendor
This servicing report lists accounts payables, sorted by vendor.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Accounts Payable Log By Vendor report
12.5 GL Posting Log
This servicing report lists general ledger postings between the date ranges specified in input parameters. The report includes date of GL postings, description, additional information in Segment (1-10), Debited (Dr) and Credit (Cr) Amount.
Parameters:
- Company/Branch
- GL Portfolio Company
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the GL Posting Log report
12.6 Pool Txns Log By GL Post Dt
This servicing report lists monetary transactions by GL post date.
Parameters:
- Company/Branch
- Account Number
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Pool Txns Log By GL Post DT report
12.7 Producer Monetary Txns Log By GL Post DT
This servicing report lists producer monetary transactions sorted by GL post date.
Parameters:
- Company/Branch
- Producer
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Producer Monetary Txns Log By GL Post DT report
12.8 Producer Statement
This servicing report lists producer statements.
Parameters:
- Company/Branch
- Producer
- Date MM/DD/YYYY
- Report Format
Example of the Producer Statement report
12.9 Account Wise PDC List
This report lists all the accounts with the corresponding PDCs received. Details including account number, customer name, tenor, bank name, cheque numbers (from and to), number of checks given and cheque amount are displayed.
Parameters:
- Company/Branch
- Account No. To
- Account No. From
- Report Format
Example of the Account Wise PDC List report
.jpg)
12.10 Payment Posting (Daily Cash) Log
This servicing report lists payment postings (daily cash).
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Payment Posting Daily Cash Log
12.11 PDC Payslip
This report lists all accounts for which PDCs are required. This report is generated using month and year as parameters.
Parameters:
- Company/Branch
- PDC Realization Date
- Report Format
Example of the PDC Payslip report
12.12 Pending PDC List
This report lists all accounts for which the PDCs have to be deposited based on a cheque deposit date.
Parameters:
- Company/Branch
- PDC Pending Since
- Report Format
Example of the Pending PDC List report
12.13 Pool Defaults
This servicing report lists not liquidated securitization pools.
Parameters:
- Company/Branch
- PDC Pending Since
- Report Format
Example of the Pool Defaults report
12.14 Pool Delinquency
This servicing report lists delinquency securitization pools.
Parameters:
- Company/Branch
- Pool
- Report Format
Example of the Pool Delinquency report
12.15 Pool Liquidated Contracts
This servicing report lists monthly recovery securitization pools.
Parameters:
- Company/Branch
- Pool
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Pool Liquidated Contracts report
12.16 Pool Monthly Activity
This servicing report lists monthly activity securitization pools.
Parameters:
- Company/Branch
- Pool
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Pool Monthly Activity report
12.17 Pool Payoffs
This servicing report lists payoff securitization pools.
Parameters:
- Company/Branch
- Pool
- Report Format
Example of the Pool Payoffs report
12.18 Pool Recovery
This servicing report lists recovery securitization pools.
Parameters:
- Company/Branch
- Pool
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Pool Recovery report
12.19 Pool Repurchased Accounts
This servicing reports lists repurchased account securitization pools.
Parameters:
- Company/Branch
- Pool
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Pool Repurchased Accounts report
12.20 Vendor - Invoice Log
This report lists invoices.
Parameters:
- Company/Branch
- Vendor #
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Vendor - Invoice Log report
12.21 Vendor - Work Order Log
This report lists work orders.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Vendor - Work Order Log report
12.22 Payment Receipt
This report lists payment receipts.
Parameters:
- Transaction ID
- Report Format
Example of Payment Receipt report
12.23 Account Wise Payment Receipt
This report lists account wise payment receipts.
Parameters:
- Transaction ID
- Report Format
Example of Account Wise payment Receipt report
12.24 Account Payable (Servicing)
This report lists the payable accounts.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of Servicing Account Payable report
.jpg)
12.25 WorkList/Queue Log Summary
This report lists the collectors queue details with the total of accounts with delinquent and outstanding amounts.
Parameters:
- Company/Branch
- Queue Name
- User Name
- Report Format
Example of WorkList/Queue Log Summary report
12.26 Payment Error Log
This report lists the account specific error log report generated during payment posting batch transaction.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of Payment Error Log report
12.27 Payment Error Log by Suspense Amount
This report lists the suspense amount in an account during a batch transaction.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of Payment Error Log by Suspense Amount report
12.28 Customer Statements Transactions
This report lists the statements generated for customer account and Master Account during a batch transaction.
Parameters:
- CUSTOMER NUMBER
- MASTER ACCOUNT NUMBER
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of Customer Statements Transactions report
12.29 Account Asset Details
Generating this report lists all ‘active’ assets associated to an account during a batch transaction.
Irrespective of the account status, only active asset details are listed in the report and if an account has multiple assets associated, then multiple entries are listed for same account with different asset details.
However, if an account does not have any active asset associated or the entered Account Number is invalid, then blank report is generated.
Report Parameters:
- COMPANY / BRANCH
- PRODUCT TYPE
- ASSET SUB TYPE
- ACCOUNT NUMBER
- ASSET PHASE NUMBER
- ASSET INVENTORY SITE
- REPORT FORMAT
Example of Account Assets Detail Report
12.30 Trade Details
Generating this report lists the traded accounts information within the specified date range provided in input parameters. These accounts consists of both existing (old) accounts which are traded along with new accounts which are created as part of the trade.
Also, this report consists of only those accounts in which the ‘Trade Details’ are populated as on the report generation date. Only the ‘Primary’ customer details are captured and if an account has multiple associated assets, then the consolidated points of all assets is displayed against each account.
Report Parameters:
- COMPANY / BRANCH
- PRODUCT TYPE
- TRADE STATUS
- FROM MM/DD/YYYY
- TO MM/DD/YYYY
- REPORT FORMAT
Example of Trade Details Report
12.31 Funding Accounts Log Details
Generating this report lists all the accounts which are funded between the date range specified in input parameters. Also by default this report is generated daily during the scheduled batch job processing and consists of accounts which are funded as on report generation date.
If an account has multiple assets associated, then multiple entries are listed for same account with different asset details. The ‘Trade Type’ column in the report indicates that the account is created as part of Trade. Else, the same is displayed blank. For more information on Trade, refer to Appendix: Trading of Accounts chapter.
Report Parameters:
- COMPANY / BRANCH
- PRODUCT TYPE
- ASSET TYPE
- FROM MM/DD/YYYY
- TO MM/DD/YYYY
- REPORT FORMAT
Example of Funding Accounts Log Details
12.32 Master Account Payment Log
Generating this report lists all the payment details posted on Master account and its Associated accounts between the date range specified in input parameters.
This report is also generated daily during the scheduled batch job processing and populates the payment details available in ‘Transactions’ table for Master and Associated accounts as on report generation date for selected product type.
However, since system derives the payment details from ‘Transactions’ table data, the scheduled batch job has to be sequenced to run only after ‘Account Balance Summary’ batch job so that the opening balance for account is available on report generation date.
By default this report captures the payments details posted on ‘Primary’ customer of account and in case an invalid account # is selected or if the selected one is not a Master Account, then the report is generated blank.
Report Parameters:
- COMPANY / BRANCH
- PRODUCT TYPE
- ASSET TYPE
- FROM MM/DD/YYYY
- TO MM/DD/YYYY
- REPORT FORMAT
Example of Master Account Payment Log
12.33 Payment Allocation Details
Generating this report lists the payment allocation details applied on account between the date range specified in input parameters.
This report is also generated daily during the scheduled batch job processing and populates all the payment allocation details applied on accounts as on report generation date for selected product type.
In case an invalid account # is selected, then the report is generated blank.
Report Parameters:
- COMPANY / BRANCH
- PRODUCT TYPE
- ACCOUNT NUMBER
- PAYMENT MODE
- FROM MM/DD/YYYY
- TO MM/DD/YYYY
- REPORT FORMAT
Example of Payment Allocation Details
12.34 Amortized Txns Log By GL Post Dt - Lease
This servicing report lists monetary transactions by GL post date for leases.
Parameters:
- Company/Branch
- Account Number
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Amortized Txns Log By GL Post Dt - Lease report
.jpg)
12.35 Monetary Txns Log By GL Post Dt - Lease
This servicing report lists monetary transactions by GL post date for leases.
Parameters:
- Company/Branch
- Account Number
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Monetary Txns Log By GL Post Dt - Lease report
12.36 Payment Allocations Log By GL Post Dt - Lease
This servicing report lists payment allocations sorted by GL post date for leases.
Parameters:
- Company/Branch
- Account Number
- From MM/DD/YYYY
- To MM/DD/YYY
- Report Format
Example of Payment Allocations Log - Lease report
12.37 Advance Posting Error Log Desc Lease
This servicing report lists errors in advance postings for lease.
Parameters:
- Company/BranchFrom MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Advance Posting Error Log Desc Lease report
.jpg)
12.38 Advance Posting Log Lease
This servicing report lists advance postings for leases.
Parameters:
- Company/Branch
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Advance Posting Log Lease report
.jpg)
12.39 Excess Payments (Refund) Log Lease
This report lists excess payment refunds for leases.
Parameters:
- Company/Branch
- Report Format
Example of the Excess Payments (Refund) Log Lease report
Log(Lease).jpg)
12.40 Payment Allocations Log Lease
This servicing report lists payment allocations for leases.
Parameters:
- Company/Branch
- Account Number
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Payments Allocation Log Lease report
12.41 Payment History Lease
This servicing report lists the payment history for leases.
Parameters:
- Company/Branch
- Account Number
- Report Format
Example of the Payment History Lease report
.jpg)
12.42 Scheduled For Chargeoff Accounts Log Lease
This servicing report lists lease accounts scheduled for charge off.
Parameters:
- Company/Branch
- Report Format
Example of the Scheduled For Chargeoff Accounts Log Lease report
.jpg)
12.43 Scheduled For Termination Accounts Log Lease
This report lists lease accounts scheduled for termination.
Parameters:
- Company/Branch
- Report Format
Example of the Scheduled For Termination Accounts Log Lease report
.jpg)
12.44 Trial Balance Lease
This report lists trial balances for leases.
Parameters:
- From MM/DD/YYYY
- To MM/DD/YYYY
- Report Format
Example of the Trial Balance Lease report
.jpg)