Hi Techies,

Let's start posting Oracle Apps based interview questions and answers in this thread.

Thanks

__________________
Prasanna Vignesh
MCPD | Web Developer

1.What are the setup steps for AP, AR, GL?

Below are some of the Main Step in GL, AP, AR Module



GL: Account Flex field

Account Combinations

Period Types

Define Calendar

Define Currency

Define Set of Books

Assign Set of Books to Responsibility

Daily Conversion Rate Types

Rates

JE Sources

Categories

System Controls

Profile Options

Open and Close Accounting Period



AP: Define Payables Lookups.

Define Purchasing Lookups.

Define payment programs.

Define your payment terms.

Define bank accounts.

Define Suppliers.

Define invoice approval codes.

Open your Payables accounting period.



AR: Define Payment Terms

Open and Close Period

Auto Accounting

Transaction Types

Transaction Source

Collectors

Approval Limit

Remittance Bank

Payment Method

Receipt Source

Aging Bucket

Customer Profile Classes

Customers

Customer Sites

Uses of Customer Sites (Ship to /Bill to)

Remit-to Address

Regards

Kiruthika

1. What is the difference between cross-validation rules and security-rules?

Security rules are segment specific and enforce predefined restrictions of a particular segment. After defining a security rule, for the security rule to take affect it should be assigned to a responsibility.

Cross validation rules prohibit invalid account combinations being created, thus they are applicable to a combination of segment values. Cross validation rule once created, would immediately take affect with all the responsibilities that are using the accounting structure(chart of accounts) for which the rule is defined.

2.How many Flexfields are there in AR and what are they?

Hi,

there are 2 flex fields in AR.

1.SALES TAX LOCATION

2.TERRITORY

thx
Kiruthika

What limitations are there in UTL_FILE?How to create the file using the UTL_FILE option?

To create a file it is required to initially create a directory..

CREATE DIRECTORY temp AS "/user/test/"

this would create the directory inthe unix box with name temp under the path /user/test.

now using the UTL_FILE.FOPEN we can read or write to a file.

UTL_FILE.FOPEN(/user/test/temp,testfile01,W,50)

the above command will create a file by name testfile01 under the specified path in Write mode containing each line a max of 50 character.

A max of 50 files can be open simultaneaously and max line size is 50 char these are some of limitations of UTL_FILE

Thanks

Kiruthika

What is auto invoice?

Auto Invoices are also used in Service Contracts as a concurrent Program namely "Auto Invoice Import Program". This program is Owned by Oracle Receivables. It imports the billing transactions from the "Service Contracts Main Billing" Program (This Program Belongs to Oracle Service Contracts) into Oracle Receivables & generate the invoice details. You have to pass down certain parameters regarding the Service Contract while running this program.
Also this Program pass down the information regarding Invoice No. & Taxation from Oracle Receivables to update the Contracts Billing History, when "Service Contracts Fetch Receivables Info for Billing" Concurrent Program (This Program also belongs to Oracle Service Contracts) is run.

Thx
Kirthika

Types of invoce in AP ?

Invoice types in AP :
---------------------
Standared invoice
Debit memo
Credit memo
PO Defult
Mixed Invoice
Withholding Tax
Expence Invoice
Prepayment Invoice

Prepayment is invoice u enter to pay an advance Payment to Expences to a supplier or Employee

Steps for Prepayment :
----------------------------
1.we have to check Payable options.
2.Create Prepayment Invoice.
a.Temporary
b.Permanet.
3.we have to apply to Invoice.
4.Pay the Prepayment Amount.
5.Cash Clearing at Cash Management Module.

Thx
Kirthika

How many key flex fields in HRMS?
There are 6 Key Fields, Namely

1. Job KeyFlexFields.
2. Position KeyFlexFields.
3. Grade KeyFlexFields.
4. Cost Allocation FlexFields.
5. Competence FlexFields.
6. People Group FlexFields.

ThankQ
KiruthikaSambandam

What is Costing sub module in Oracle HRMS?

There is no such module in HRMS. But the expenses incurred because of HR activities such as Recruitment expenses, Learning Expenses (Training, Training facilities etc) and Time & Labor expenses (Project related expenses) and other misc expenses are Budgeted through providing the Costing information trhough the Cost Allocatiion Flex Field details in respective windows.

Even the employee pay and facilities are also been costed and allocated through the same Cost Allocation Flexfield information.

All these expenses are later transferred to General Ledger, to have an overall accounting at one particular point.

ThankQ
KiruthikaSambandam

What is date tracking, how it is used in HRMS ?

Well date tracking isa feature in Oracle HRMS esp with all tables whose name send with _F eger_all_people_f .Now what happens here is we cannont purge a record what we can do is endate a record and if we need to create an extension eg: of an assignment then we end-date the assignment and on a new record that is appended to the table we create a new record with starting date after the eend date and can restate the assignment, used in cases of Re-hire after end of assignment or in the extension of assignment beyond the end date. It helps Oracle maintain historical data and hence the tables are data trackable

ThankQ

KiruthikaSambandam

What are the system administration tasks in Oracle HRMS?

Following are the tasks for system administrator
-- Set Profile Options
-- Create Menu and Request Group for Custom Responsibilities
-- Create Responsibilities
-- Create Users
-- Attached Responsibilities with User


ThankQ

KiruthikaSambandam

How is employment information maintained in Oracle HRMS?

At table level, employee records are stored with effective start date and end date. Whenever you change any record in the Employee record in UPDATE mode, a new row is created at back-end. Hence history get stored in system.
At front end you have option to select effective date to get effective record on that date.

Enter and Maintain contains most of the required information related to employee. If you have some more information to cover, you can use Extra Information or Special Information to store details.


ThankQ
KiruthikaSambandam

What are the key flexfields present in Oracle HRMS?

There are 8 Key Fields, Namely

1. Job KeyFlexFields.
2. Position KeyFlexFields.
3. Grade KeyFlexFields.
4. Cost Allocation FlexFields.
5. Competence FlexFields.
6. People Group FlexFields.
7. personal analysis flex field
8. banking flex fields

ThankQ

KiruthikaSambandam

What are the steps involved in implementation of Oracle HRMS?

Following are the steps to implement Oracle HRMS,

-- Define Key Flexfields
-- Define Descriptive Flexfields
-- Define Business Group
-- Set required Profile Options
-- Define Location
-- Define Organization
-- Define Grades
-- Define Jobs
-- Define Positions
-- Set required Lookup values
-- Set person type and Assignments type as per requirement
-- Associate Special Informationa with your Responsibility
-- Register Extra Information and associate with your Responsibility

ThankQ
KiruthikaSambandam

What are the tools used with Oracle HRMS?

Discoverer -- To develop reports
Web ADI -- Either to upload or down load the data from Oracle to legacy system or viceversa
RDF Reports -- Standard reports developed by Report Builder
TOAD -- Testing Tool
Data Loader -- To upload different data into oracle data base
XML Publisher -- Integrated Oracle Reports with the help of Microsoft Template Builder

ThankQ
KiruthikaSambandam

What is the difference between key flexfield and Descriptive flexfield?

Key Flexfield is used to describe unique identifiers that will have a better meaning than using number IDs. e.g a part number, a cost centre etc
Desc Flex is used to just capture extra information.
Key Flexfields have qualifiers whereas Desc Flexfields do not.
Desc Flexfields can have context sensitive segments while Key flexfields cannot.


ThankQ
KiruthikaSambandam

What is difference between ICM, Standard Managers & CRM in Concurrent Manager ?

ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks & try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well.

Standard Manager These are normal managers which control/action on the requests & does batch or single request processing.

CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers & request. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are actioned/assigned to CRM for Incompatibilities & Conflict resolution.

How many ORACLE HOME are Oracle Apps and whats significance of each ?

There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and One in Database Tier.

ORACLE_HOME 1 : On Application Tier used to store 8.0.6 techstack software. This is used by forms, reports & discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying Apps Patch.

ORACLE_HOME 2: On Application Tier used by iAS (Web Server) techstack software. This is used by Web Listener & contains Apache.

ORACLE_HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database.

What are Summary Accounts and Rollup groups ?

Summary Account: An account whose balance represents the sum of other account balances. We can use summary accounts for faster reporting and inquiry as well as in formulas and allocations.

Rollup Groups: A collection of parent segment values for a given segment. We use rollup groups to define summary accounts based on parents in the group. We can use letters as well as numbers to name the rollup groups.


Thanks

Sathian.K

What are different types of Journal entries ?

A Debit or Credit to a General Ledger Account is called Journal Entry...

Types of Journal Entries:-

1) General Journal Entry.

2)Recurrning Journal Entry.

3)Mass Allocation Journal Entry.

4)Reversing Journal Entry.

Thanks
Sathian.K

When you are moving a cursor on a form what are the possible triggers that are going to be fired?

If you are moving from a item of first block to the item of another block in a form then following trigger will be fired.

post-text
when-validate-item (fired only when the status of the textitem has been changed)
post-block
pre-block
when-new-block-instance
pre-text
when-new-item-instance

If you are moving from a item to another item in same form then following trigger will be fired.

post-text
when-validate-item (fired only when the status of the textitem has been changed)
pre-text
when-new-item-instance

Thanks
Sathian.K