Oracle Loans User Guide
Oracle LoansUser GuideRelease 12Part No. B25869-03October 2007
Oracle Loans User Guide, Release 12Part No. B25869-03Copyright 2005, 2007, Oracle. All rights reserved.Primary Author:Melanie Heisler, Kristin Penaskovic, Shivranjini KrishnamurthyContributing Author:Karthik Ramachandran, Raj VermaThe Programs (which include both the software and documentation) contain proprietary information; theyare provided under a license agreement containing restrictions on use and disclosure and are also protectedby copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, ordecompilation of the Programs, except to the extent required to obtain interoperability with otherindependently created software or as specified by law, is prohibited.The information contained in this document is subject to change without notice. If you find any problems inthe documentation, please report them to us in writing. This document is not warranted to be error-free.Except as may be expressly permitted in your license agreement for these Programs, no part of thesePrograms may be reproduced or transmitted in any form or by any means, electronic or mechanical, for anypurpose.If the Programs are delivered to the United States Government or anyone licensing or using the Programs onbehalf of the United States Government, the following notice is applicable:U.S. GOVERNMENT RIGHTSPrograms, software, databases, and related documentation and technical data delivered to U.S. Governmentcustomers are "commercial computer software" or "commercial technical data" pursuant to the applicableFederal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication,disclosure, modification, and adaptation of the Programs, including documentation and technical data, shallbe subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extentapplicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--RestrictedRights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherentlydangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,redundancy and other measures to ensure the safe use of such applications if the Programs are used for suchpurposes, and we disclaim liability for any damages caused by such use of the Programs.The Programs may provide links to Web sites and access to content, products, and services from third parties.Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear allrisks associated with the use of such content. If you choose to purchase any products or services from a thirdparty, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the qualityof third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party,including delivery of products or services and warranty obligations related to purchased products or services.Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any thirdparty.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarksof their respective owners.
ContentsSend Us Your CommentsPreface1Setting Up Oracle LoansSetting Up Oracle Loans. 1-2Oracle HRMS Setup. 1-2Oracle System Administrator Setup. 1-2Oracle Resource Manager Setup. 1-4Oracle General Ledger Setup. 1-4Oracle Receivables Setup. 1-5Oracle Payables Setup. 1-6Oracle Workflow Setup. 1-6Oracle Loans Setup. 1-7Setting Up Rates. 1-7Defining Loan Conditions. 1-8Enabling Notifications. 1-8Setting Up Loan Types. 1-9Setting Up System Options. 1-10Setting Up Accounting. 1-12Validation for Loan Accounting. 1-13Accounting Derivation Rules. 1-14Accounting Events. 1-14Defining Loan Fees. 1-16Setting Up Loan Products. 1-17Defining Oracle Loans Lookups. 1-19iii
2Creating A LoanUsing Oracle Loans. 2-2Using the Loans Dashboard. 2-4Creating a Loan. 2-5Updating a Loan. 2-10Loan Overview. 2-11General. 2-11Rates. 2-12Fees. 2-14Conditions. 2-16Amortization. 2-16Notes. 2-18Related Loans. 2-18Viewing Borrowers. 2-18Creating a New Organization. 2-19Adding Borrowers and Guarantors.2-20Creating Assets. 2-20Adding Collateral. 2-21Disbursing a Loan. 2-22Creating a Disbursement Schedule. 2-22Adding a Payee. 2-23Credit Review. 2-24Approving a Loan. 2-25Viewing Accounting Events. 2-26Using Notifications. 2-273Funding A LoanOverview of Loan Funding. 3-14Loan ServicingOverview of Servicing Loans. 4-1Servicing Center. 4-2Loan Overview. 4-3Loan History. 4-5Using Reports. 4-5Updating Loan Status. 4-6Running Scoring to Update Loan Status. 4-8Payments. 4-9Accounting for Loan Payments. 4-10iv
Processing Loan Payoffs. 4-10Viewing Current Amortization and Payment History. 4-12Memo Fees Due Before First Loan Payment. 4-13Amortization Schedule. 4-13Outstanding Bills. 4-14Creating Manual Bills. 4-14Creating Credits. 4-15Credit and Rebill. 4-165Billing A LoanOverview of Loan Billing. 5-1Integration with Oracle Receivables.5-2LNS: Billing Program. 5-2Submitting the LNS: Billing Program. 5-3Submitting the LNS: Reverse Last Bill Program. 5-56Budgetary ControlSetting up Budgetary Control. 6-1Setting Up Loan Types: Approval Depends on Funds Availability. 6-3Setting up Loan Products: Subsidy Rate.6-3AOracle Loans Profile Options and Profile Option CategoriesProfile Options and Profile Option Categories Overview. A-1Profile Option Category and Profile Options Descriptions. A-1Profile Options Owned by Oracle Loans. A-2Profile Options Not Owned by Oracle Loans. A-3BOracle Loans Concurrent ProgramsLNS: Billing. B-1LNS: Fee Assessment. B-2LNS: Generate Distributions. B-3LNS: Receipts Application Engine. B-3LNS: Refresh Materialized Views. B-3LNS: Reverse Last Bill. B-3COracle Loans ReportsLNS: Loan Agreement Report.C-1LNS: Loans Portfolio Report.C-1LNS: Loans Reconciliation Report. C-2v
Indexvi
Send Us Your CommentsOracle Loans User Guide, Release 12Part No. B25869-03Oracle welcomes customers' comments and suggestions on the quality and usefulness of this document.Your feedback is important, and helps us to best meet your needs as a user of our products. For example: Are the implementation steps correct and complete?Did you understand the context of the procedures?Did you find any errors in the information?Does the structure of the information help you with your tasks?Do you need different information or graphics? If so, where, and in what format?Are the examples correct? Do you need more examples?If you find any errors or have any other suggestions for improvement, then please tell us your name, thename of the company who has licensed our products, the title and part number of the documentation andthe chapter, section, and page number (if available).Note: Before sending us your comments, you might like to check that you have the latest version of thedocument and if any concerns are already addressed. To do this, access the new Applications ReleaseOnline Documentation CD available on Oracle MetaLink and www.oracle.com. It contains the mostcurrent Documentation Library plus all documents revised or released recently.Send your comments to us using the electronic mail address: appsdoc us@oracle.comPlease give your name, address, electronic mail address, and telephone number (optional).If you need assistance with Oracle software, then please contact your support representative or OracleSupport Services.If you require training or instruction in using Oracle software, then please contact your Oracle local officeand inquire about our Oracle University offerings. A list of Oracle offices is available on our Web site atwww.oracle.com.vii
PrefaceIntended AudienceWelcome to Release 12 of the Oracle Loans User Guide.This guide assumes you have a working knowledge of the following: The principles and customary practices of your business area. Computer desktop application usage and terminologyIf you have never used Oracle Applications, we suggest you attend one or more of theOracle Applications training classes available through Oracle University.See Related Information Sources on page x for more Oracle Applications productinformation.TTY Access to Oracle Support ServicesOracle provides dedicated Text Telephone (TTY) access to Oracle Support Serviceswithin the United States of America 24 hours a day, seven days a week. For TTYsupport, call 800.446.2398.Documentation AccessibilityOur goal is to make Oracle products, services, and supporting documentationaccessible, with good usability, to the disabled community. To that end, ourdocumentation includes features that make information available to users of assistivetechnology. This documentation is available in HTML format, and contains markup tofacilitate access by the disabled community. Accessibility standards will continue toevolve over time, and Oracle is actively engaged with other market-leading technologyvendors to address technical obstacles so that our documentation can be accessible to allof our customers. For more information, visit the Oracle Accessibility Program Web siteix
at http://www.oracle.com/accessibility/ .Accessibility of Code Examples in DocumentationScreen readers may not always correctly read the code examples in this document. Theconventions for writing code require that closing braces should appear on an otherwiseempty line; however, some screen readers may not always read a line of text thatconsists solely of a bracket or brace.Accessibility of Links to External Web Sites in DocumentationThis documentation may contain links to Web sites of other companies or organizationsthat Oracle does not own or control. Oracle neither evaluates nor makes anyrepresentations regarding the accessibility of these Web sites.Structure1 Setting Up Oracle LoansThis chapter provides an overview of Oracle Loans as well as the setup tasks that youneed to perform in Oracle Applications for Oracle Loans.2 Creating A LoanThis chapter describes how to create and update a loan.3 Funding A LoanThis chapter describes how to fund a loan.4 Loan ServicingThis chapter describes how to service a loan.5 Billing A LoanThis chapter describes how to bill a loan.6 Budgetary ControlThis chapter describes setting up budgetary control.A Oracle Loans Profile Options and Profile Option CategoriesB Oracle Loans Concurrent ProgramsC Oracle Loans ReportsRelated Information SourcesThis document is included on the Oracle Applications Document Library, which issupplied in the Release 12 DVD Pack. You can download soft-copy documentation asPDF files from the Oracle Technology Network at http://otn.oracle.com/documentation,or you can purchase hard-copy documentation from the Oracle Store athttp://oraclestore.oracle.com. The Oracle E-Business Suite Documentation LibraryRelease 12 contains the latest information, including any documents that have changedsignificantly between releases. If substantial changes to this book are necessary, arevised version will be made available on the online documentation CD on Oraclex
MetaLink.If this guide refers you to other Oracle Applications documentation, use only theRelease 12 versions of those guides.For a full list of documentation resources for Oracle Applications Release 12, see OracleApplications Documentation Resources, Release 12, OracleMetaLink Document394692.1.Online DocumentationAll Oracle Applications documentation is available online (HTML or PDF). PDF - PDF documentation is available for download from the Oracle TechnologyNetwork at http://otn.oracle.com/documentation. Online Help - Online help patches (HTML) are available on OracleMetaLink. Oracle MetaLink Knowledge Browser - The OracleMetaLink Knowledge Browserlets you browse the knowledge base, from a single product page, to find alldocuments for that product area. Use the Knowledge Browser to search forrelease-specific information, such as FAQs, recent patches, alerts, white papers,troubleshooting tips, and other archived documents. Oracle eBusiness Suite Electronic Technical Reference Manuals - Each ElectronicTechnical Reference Manual (eTRM) contains database diagrams and a detaileddescription of database tables, forms, reports, and programs for a specific OracleApplications product. This information helps you convert data from your existingapplications and integrate Oracle Applications data with non-Oracle applications,and write custom reports for Oracle Applications products. Oracle eTRM isavailable on OracleMetaLink.Related GuidesYou should have the following related books on hand. Depending on the requirementsof your particular installation, you may also need additional manuals or guides.Oracle Applications Installation Guide: Using Rapid Install:This book is intended for use by anyone who is responsible for installing or upgradingOracle Applications. It provides instructions for running Rapid Install either to carryout a fresh installation of Oracle Applications Release 12, or as part of an upgrade fromRelease 11i to Release 12. The book also describes the steps needed to install thetechnology stack components only, for the special situations where this is applicable.Oracle Applications Maintenance Procedures:This guide describes how to use AD maintenance utilities to complete tasks such ascompiling invalid objects, managing parallel processing jobs, and maintaining snapshotinformation. Part of Maintaining Oracle Applications, a 3-book set that also includesOracle Applications Patching Procedures and Oracle Applications MaintenanceUtilities.xi
Oracle Applications Maintenance Utilities:This guide describes how to run utilities, such as AD Administration and ADController, used to maintain the Oracle Applications file system and database. Outlinesthe actions performed by these utilities, such as monitoring parallel processes,generating Applications files, and maintaining Applications database entities. Part ofMaintaining Oracle Applications, a 3-book set that also includes Oracle ApplicationsPatching Procedures and Oracle Applications Maintenance Procedures.Oracle Applications Patching Procedures:This guide describes how to patch the Oracle Applications file system and databaseusing AutoPatch, and how to use other patching-related tools like AD Merge Patch,OAM Patch Wizard, and OAM Registered Flagged Files. Describes patch types andstructure, and outlines some of the most commonly used patching procedures. Part ofMaintaining Oracle Applications, a 3-book set that also includes Oracle ApplicationsMaintenance Utilities and Oracle Applications Maintenance Procedures.Oracle Applications Upgrade Guide: Release 11i to Release 12:This guide provides information for DBAs and Applications Specialists who areresponsible for upgrading a Release 11i Oracle Applications system (techstack andproducts) to Release 12. In addition to information about applying the upgrade driver,it outlines pre-upgrade steps and post-upgrade steps, and provides descriptions ofproduct-specific functional changes and suggestions for verifying the upgrade andreducing downtime.Oracle Alert User's Guide:This guide explains how to define periodic and event alerts to monitor the status ofyour Oracle Applications data.Oracle Application Framework Developer's Guide:This guide contains the coding standards followed by the Oracle Applicationsdevelopment staff to produce applications built with Oracle Application Framework.This guide is available in PDF format on OracleMetaLink and as online documentationin JDeveloper 10g with Oracle Application Extension.Oracle Application Framework Personalization Guide:This guide covers the design-time and run-time aspects of personalizing applicationsbuilt with Oracle Application Framework.Oracle Applications Concepts:This book is intended for all those planning to deploy Oracle E-Business Suite Release12, or contemplating significant changes to a configuration. After describing the OracleApplications architecture and technology stack, it focuses on strategic topics, giving abroad outline of the actions needed to achieve a particular goal, plus the installation andconfiguration choices that may be available.Oracle Applications Flexfields Guide:This guide provides flexfields planning, setup, and reference information for the Oraclexii
Applications implementation team, as well as for users responsible for the ongoingmaintenance of Oracle Applications product data. This guide also provides informationon creating custom reports on flexfields data.Oracle Applications Multiple Organizations Implementation Guide:This guide describes the multiple organizations concepts in Oracle Applications. Itdescribes in detail on setting up and working effectively with multiple organizations inOracle Applications.Oracle Applications System Administrator's Guide Documentation Set:This documentation set provides planning and reference information for the OracleApplications System Administrator. Oracle Applications System Administrator's Guide Configuration contains information on system configuration steps, including definingconcurrent programs and managers, enabling Oracle Applications Manager features,and setting up printers and online help. Oracle Applications System Administrator's Guide- Maintenance provides information for frequent tasks such as monitoring your systemwith Oracle Applications Manager, managing concurrent managers and reports, usingdiagnostic utilities, managing profile options, and using alerts. Oracle ApplicationsSystem Administrator's Guide - Security describes User Management, data security,function security, auditing, and security configurations.Oracle Applications User's Guide:This guide explains how to navigate, enter data, query, and run reports using the userinterface (UI) of Oracle Applications. This guide also includes information on settinguser profiles, as well as running and reviewing concurrent requests.Oracle Approvals Management Implementation Guide:Use this guide to learn how to implement Oracle Approvals Management (AME). AMEis a self-service Web application that enables users to define business rules governingthe process for approving transactions in Oracle Applications where AME has beenintegrated.Oracle Workflow Administrator's Guide:This guide explains how to complete the setup steps necessary for any product thatincludes workflow-enabled processes. It also describes how to manage workflowprocesses and business events using Oracle Applications Manager, how to monitor theprogress of runtime workflow processes, and how to administer notifications sent toworkflow users.Oracle Workflow Developer's Guide:This guide explains how to define new workflow business processes and customizeexisting Oracle Applications-embedded workflow processes. It also describes how todefine and customize business events and event subscriptions.Oracle Workflow User's Guide:This guide describes how users can view and respond to workflow notifications andmonitor the progress of their workflow processes.xiii
Oracle Workflow API Reference:This guide describes the APIs provided for developers and administrators to accessOracle Workflow.Oracle XML Publisher Administration and Developer's Guide:Oracle XML Publisher is a template-based reporting solution that merges XML datawith templates in RTF or PDF format to produce a variety of outputs to meet a varietyof business needs. Outputs include: PDF, HTML, Excel, RTF, and eText (for EDI andEFT transactions). Oracle XML Publisher can be used to generate reports based onexisting E-Business Suite report data, or you can use Oracle XML Publisher's dataextraction engine to build your own queries. Oracle XML Publisher also provides arobust set of APIs to manage delivery of your reports via e-mail, fax, secure FTP,printer, WebDav, and more. This guide describes how to set up and administer OracleXML Publisher as well as how to use the Application Programming Interface to buildcustom solutions.Oracle Common Application Calendar User Guide:Use this guide to learn to create appointments, tasks, notes, adding attachments tonotes, as well as invite attendees to appointments, and view scheduled activitiesthrough flexible daily, weekly, and monthly calendar views.Oracle Integration Repository User's Guide:This guide covers the employment of Oracle Integration Repository in researching anddeploying business interfaces to produce integrations between applications.Oracle Credit Management User Guide:This guide provides you with information on how to use Oracle Credit Management.This guide includes implementation steps, such as how to set up credit policies, as wellas details on how to use the credit review process to derive credit recommendationsthat comply with your credit policies. This guide also includes detailed informationabout the public application programming interfaces (APIs) that you can use to extendOracle Credit Management functionality.Oracle Financials and Oracle Procurement Functional Upgrade Guide: Release 11i toRelease 12:This guides provid
1 Setting Up Oracle Loans This chapter provides an overview of Oracle Loans as well as the setup tasks that you need to perform in Oracle Applications for Oracle Loans. 2 Creating A Loan This chapter describes how to create and update a loan. 3 Funding A Loan This chapter describes how to fund a loan. 4 Loan Servicing
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
International Student Loans Private loans offered to non-U.S. citizens who generally won't qualify for federal student loans. State and nonprofit loans Usually offered by state or a nonprofit organization, usually to promote college access. Credit union loans Institutional loans Medical school loans Bar exam loans
Credit Cards Secured Loans Signature Loans Auto Title Loans Payday Loans Pawn Loans Secured Loans Signature Loans How Does a Payday Loan ompare to Other Options? Per 100 borrowed over 2 weeks Payday loans are cash advances provided to a borrower to meet financial needs. As a borrower, you will be required to sign a loan agreement
Specific tasks you can accomplish using Oracle Sales Compensation Oracle Oracle Sales Compensation setup Oracle Oracle Sales Compensation functions and features Oracle Oracle Sales Compensation windows Oracle Oracle Sales Compensation reports and processes This preface explains how this user's guide is organized and introduces
7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
There are also four possible examples of themes which could be followed. Each has a set of readings with an introduction to them. This could either act as a prompt to whoever is preaching, or could be read when there is no preacher present, as sometimes happens in our rural groups of churches where each church holds its own service. There is a linked prayer and suggestions for the music .
