This appendix covers the following topics:
This program enables the Loans Administrator to assign Loan Access Level for borrowers, co-borrowers, and guarantors based on the parameters entered. Using the parameters an administrator can:
Filter and process loans for specific organization, borrower, or product.
Assign specific access levels for borrowers, co-borrowers, and guarantors at once.
Remove individual loan access level settings to use global settings.
Submit the LNS: Billing program in Oracle Loans to create bills (Receivables documents) for your active loans. You can create bills for a single loan or borrower, or for a range of loans, borrowers, or dates. Using standard request submission, you can schedule billing to run at a specific time, or to run periodically.
Submit the LNS: Billing program from either the Forms-based Submit Request window, or the HTML-based Submit Request page. See: Using Standard Request Submission, Oracle E-Business Suite User's Guide
For more information, see: Overview of Loan Billing.
The LNS: Billing program creates a bill for all active loans that match the entered parameters. Enter at least one parameter to run billing:
Borrower
Note: Parameter searches are not interdependent. For example, searching by borrower name does not restrict the loan values available, if you then search by loan number, to just loans for that borrower.
Loan
From/To Number of Days to Due Date
Note: The numbers that you enter here represent the number of days between the system date and the payment due date, and can be positive or negative.
From Number of Days to Due Date is blank by default. The default value for To Number of Days to Due Date is the value of the Invoice Generation Timing system option. If you run the billing program using the defaults, Loans generates bills for loans with due dates that range from any date before the system date to the number of days specified in Invoice Generation Timing system option.
Loan Type: The specified loan type is billed.
Loan Product: The specified loan product is billed.
In general, do not specify a borrower or loan when submitting the LNS: Billing program. Instead, you should run the program for all borrowers and loans.
You might, however, need to run the program for an individual borrower or loan to correct isolated billing issues.
Use a combination of the From/To Number of Days to Due Date parameters with Standard Request Submission's scheduling options to complete the billing for your active loans.
For example, you can schedule the LNS: Billing program to run everyday, for all loans whose installment due date falls 15 days before and after the system date.
To bill loans with back-dated start dates, set only the To Number of Days to Due Date parameter. The billing program will pick up all loans that should have been billed as long ago as the date you created the loan. Since the Loans billing program only creates one bill per loan, you may need to submit the program multiple times to make sure you generate bills for all periods required.
During billing, if the calculated loan invoice gl_date falls into a closed GL period, it is posted to the next open period.
See: Running Reports and Programs, Oracle E-Business Suite User's Guide.
This program enables the user to export loans amortization schedules into LNS_AM_SCHEDS_EXPORTS table for further usage by external reports and analytical tools.
This program generates distributions for ERS loans.
This program creates the Journal Entry for the accrued interest from last Billing installment Due Date to the Period End or Daily Accrual entered. The following parameters are available for this program:
Borrower: The interest accrual is calculated for all loans of the operating units which are assigned to this borrower and the other input parameter Ledger.
Ledger: The interest accrual is calculated for all loans of the operating units which are assigned to the entered ledgers.
Operating Unit: The interest accrual is calculated for all loans of the entered operating unit.
Loan Number: The interest accrual is calculated only for this loan number
Accrual Type: Select from one of the following parameters:
Period End Accrual: The interest accrual is calculated up to the last day of the given period which is closed in AR and open in GL.
Daily Accrual: The interest accrual is calculated up to the entered accrual date. This value is limited to two years before and one year after the system date.
Period: This parameter is enabled and mandatory for accruals of type Period End Accrual. The accrual interest is calculated till the last day of this GL period.
Accrual Date: This parameter is enabled and mandatory for accruals of type Daily Accrual. The accrual interest is calculated till this date.
Accrual Mode: The program runs in two modes:
Draft Mode: Creates accounting entries in Loans and the user can check the distributions in the output report. These entries are not eligible for the SLA concurrent program Create Accounting.
Final Mode: Creates accounting entries in Loans and makes these entries eligible for the SLA concurrent program Create Accounting.
This program synchronizes (mass updates) loans with Rates Type of Floating and Floating By Date with the global Index Rate which is set up. The program has only one parameter, Index Name. If an index name is selected, then only those loans with the selected index are synchronized. If the index name is omitted, then all loans in the system are synchronized.
This program searches and applies payments to Loans invoices based on selected parameters.
Note: This concurrent program has been obsoleted.
This program refreshes the Loans Dashboard Graphs data.
This program credits the original bill if the bill issued to a borrower is incorrect. You can optionally rebill the loan at the same time. Alternatively, you can complete the credit, or credit and rebill, process from within the Servicing tab. See: Outstanding Bills.
This program enables the Loans Administrator to transfer loans from one loan officer to another. The parameters present are From Loan Officer and To Loan Officer.