Oracle Loans Setup problem on Vision instance

All the discussion which is not possible in the above forums should be posted here.
Post Reply
sindhu
Posts: 2
Joined: Thu Jan 08, 2009 10:25 am
Location: India

Oracle Loans Setup problem on Vision instance

Post by sindhu »

Hi,

Im having set up problems with Oracle R12 Loans modules. When tried to login as Loan Administrator and on clicking setup, getting invalid resource ID error.
Ive referred to Oracle Loans user guide and still not able to solve the problem.
I would like to know whether anyone has done set up for the same in a vision instance.

Awaiting for the response
Sindhu
SIVAKUMAR_G
Posts: 194
Joined: Tue May 15, 2007 7:45 am
Location: United Arab Emirates

Post by SIVAKUMAR_G »

Hi Sindhu

Please follow the steps as provided in metalink note

Table of Contents
Purpose and Scope

Prerequisites
Steps to Complete a Basic Setup

Purpose and Scope
The intention of this note is to show the basic Oracle Loans setup. This note is not to be used in place of the Oracle Loans User Guide.
The information in this document applies to any platform.

11i.LNS.B is NOT GENERALLY AVAILABLE to customers since it is a Controlled Production Release.
11i.LNS.B is NOT available for download from Oracle Metalink.

Prerequisites
In order to use the basic Oracle Loans product, the following Oracle Products MUST be loaded to at least these installation statuses:
Product Installed Status
Oracle Loans Fully
Oracle Payables Fully
Oracle Receivables Fully
Oracle HRMS Shared
Oracle CRM Shared
Oracle General Ledger Shared

In order to use the advanced features of Oracle Loans, you may have the following Oracle Products loaded:
Product Installed Status
Oracle Advanced Collections Fully
Oracle Credit Management Fully
Workflow Fully

Steps to Complete a Basic Setup
1. Setup your Loans User:

A. Typically, the user creates loans, enters credits, views loan info and payment history, views and submits concurrent requests and answers customer inquiries.
In System Administrator Responsibility
Security>User>Define
Enter a Username and Password
Assign the following responsibility:
? Loan Agent

2. Setup your Loans Administrator:

A. Typically, the administrator, sets system options, enters accounting defaults, defines loan conditions, fees, interest rates and notifications.
In System Administrator Responsibility
Security>User>Define
Enter a Username and Password
Assign the following responsibility:
? Loan Administration

3. Setup HRMS:

A. Setup employees,
In your HR Responsibility
People>Enter & Maintain
Enter name, birthday, gender, SSN
Save.

4. System Administrator Setup:

A. Replicate the Loans Batch Source, Receivables Activities and Reason Codes for each operating unit.
In System Administrator Responsibility
Requests>Run
Query Program = Replicate Seed Data
Submit this program for each operating unit in which you plan to use Loans

B. Set profile options
In System Administrator Responsibility
Profile>System
Set the following profile options:
? LNS:Generate Loan Number (default is YES at site level)
? LNS:Disable Loan Class
? Enable Transaction Code
? Concurrent Report Access Level

C. There are two descriptive flexfields available. We will not get into the setup of dff in this document.
? Loan Information
? Loan Asset Information

5. Setup your Resources:

A. Define your employees as resources and assign one or more roles to each resource.
Using the CRM Resource Manager Responsibility
Maintain Resources>Resources
Query your employee
Click on Resource Details
Assign or more or the following roles to each:
? Loan Agent
? Loan Manager

6. Setup General Ledger:

A. (Optional) If you offer loans in currencies other than your functional currency, it must be defined in GL
In your General Ledger Responsibility
Setup>Currencies>Rate>Daily
Enter your currencies
Save.

B. Ensure you have enough General Ledger periods open so you can successfully execute billing.
In your General Ledger Responsibility
Setup>Financials>Calendar>Accounting
Ensure you have at least open year of accounting periods defined.

Setup>Open/Close
Ensure you have at least one year of accounting periods opened.

7. Setup Receivables:

A. Define an active credit memo transaction batch source.
In your Receivables Responsibility
Setup>Transactions>Sources
Name = <your CM loan name>
Type = manual
(X) Active
(X) Automatic Transaction Numbering
Reference Field Default Value = interface_header_attribute1
Standard Transaction Type = Credit Memo
Save
Query Name = Loan Credit Memos
For Credit Memo Batch Source, enter <your cm loan name>
Save.

B. (Optional) Define three default transaction types for use when billing:
In your Receivables Responsibility
Setup>Transaction>Transaction Types
Define:
? Loan Principal
? Loan Interest
? Loan Fees

When defining these types,
Transaction Status = Open
Creation Sign = Positive Sign
Tax Calculation = ( )
Natural Application Only = (X)
Save

C. Ensure Revenue Policy is not defined.
In your Receivables Responsibility
Setup>System>System Options
Click on Revenue Policy tab

D. Setup the accounting on the Receivables Activity.
In your Receivables Responsibility
Setup>Receipts>Receivables Activities
Query Name = Loan Conversion
Click on Resource Details
For Activity GL Account, enter the code combination for loan clearing
when an existing receivable is converted to a loan.

8. Setup Payables:

A. Verify that Loans appears in the Source Lookups in Payables.
In your Payables Responsibility
Setup>Lookups>Payables
For Application, verify that Oracle Loans is in the list of values.

B. (Optional) If your organization pays invoice in multiple currencies:
Setup and enable the additional currencies.
In your Payables responsibility,
Setup>Currency>Define
Define your currency.
Setup>Currency>Daily
Enter your daily rates.

Set the profile option, Use Multiple Currencies.
In your Payables responsibility,
Setup>Options>Payables->Currency Tab
(X) Use Multiple Currencies
Save.

Define Additional internal bank accounts and remittance accounts
for each currency you use.
In your Payable responsibility,
Setup>Payments>Bank
Enter your Bank information
Click on Bank Accounts
Account Use = Internal
For each Currency, enter the account information
Save.

9. (Optional) Setup Workflow:

A. For basic setup we will not get into Workflow setup. For more information,
refer to the Oracle Loans Users Guide,
Chapter 1, Oracle Workflow Setup.

10. Setup Oracle Loans:

A. Set System Options for each operating unit in which you want to use Oracle
Loans.
In your Loans Administration responsibility,
Setup>System Options
(1) Under General:
Choose Day Count Method
Choose Batch Source

(2) Under Billing:
Choose Default Transaction Type
Choose Default Interest Transaction Type
Choose Default Fee Transaction Type
Choose Invoice Generation Timing
Choose GL Due Date

(3) Under Original Receivable Adjustment:
Choose Activity Name = Loan Conversion (required if Loan Class = ERS
only)
(Optional) Choose Transaction Code (required for Loan Class = ERS or
public sector installations)

(4) Under Fee Accounting:
Enter the default debit accounting flexfield for Fee Receivables.
(Optional) Enter a Transaction Code (required only for public sector)

(5) Save.

B. Setup Accounting.
All Accounting code combinations must be entered according to the Validation
for Loan Accounting. See Oracle Loans Users Guide, Chapter 1, Setting up
Accounting.

In your Loans Administrator responsibility,
Setup>Accounting
For each combination of loan class and loan type you must define GL accounts.
Choose Loan Class
Choose Loan Type
Click on Create
Enter accounting code combination(s) for Loan Booking
(Optional) Enter the Transaction Code
Click on Next

Enter accounting code combination(s) for Loan Funding (for Direct Loans only)
(Optional) Enter the Transaction Code
Click on Next

Enter the accounting code combination(s) for Billing
(Optional) Enter the Transaction Code
Click on Next

After reviewing your entries
Click on Submit.

C. Setup Index Rates.
In your Loans Administrator responsibility
Setup>Rates
Enter a Name
Enter a Description
Save. (You must save the name before adding rows)
Click on Create
Click on Add Another Row
Enter your Interest Rate information
Save.

D. (Optional) Enable Workflow Notifications.
In your Loans Administrator responsibility,
Setup>Notifications
Enter an Event Name and /or Loan Class
Click on Go
Click on an event
Choose Enabled = Yes or No
Save.

E. Define Conditions
In your Loans Administrator responsibility,
Setup>Conditions
Click on Create Condition
For Type, choose either Approval, Delinquency or Servicing
Enter Condition Name (must be unique within an Operating Unit)
Enter Description
Save.

F. Define Fees.
In you Loans Administrator responsibility,
Setup>fees
Click on Create
For Fee Category, choose Memo, Event Based, Manual or Recurring
For Fee Name (must be unique within an Operating Unit)
Enter Start Date
Enter the Currency
All other information required depends on the Fee category selected.
If you need more explanation, please refer to the Oracle Loans Users Guide.
Save.

G. Define Lookups.
In your Loans Administrator responsibility,
Navigate to LNS Lookups
For Application, choose Oracle Loans from the list of values.
For each lookup Type defined in Chapter 1 of Oracle Loans User Guide,
Enter the meaning and type
Choose Extensible
Enter the Code, Meaning, Descriptions and Effective Dates
Save.

Regards
Sivakumar
sindhu
Posts: 2
Joined: Thu Jan 08, 2009 10:25 am
Location: India

Post by sindhu »

Hi Sivakumar,

Thanks for the reply.

I've followed the step up to 10 where it is asking me to set up as Loan Administrator.
When Im navigating to Loan Administrator->Setup, Im getting the following error:

"Login Resource ID is invalid. Please contact your system administrator. "

According to metalink, it is because of setup problem, but im not able to solve the problem. I'm trying these on a vision instance and I got R12.LNS.A.4 patch set installed on the server. This is a R12 vision instance.
Is there any other way to set up the system without applying patch set LNS.B?

Please help.

Regards
Sindhu
mramadhani
Posts: 10
Joined: Sat Oct 02, 2010 12:44 am
Location: Tanzania
Contact:

Re: Oracle Loans Setup problem on Vision instance

Post by mramadhani »

Dear all
Greetings!

My client need to deploy oracle loan module, is their any one can help me from scratch.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests