Dec 23, 2007

Below are more Apps Questions. I will update the answers asap

1)what is the meaning of imputed earnings,supplementary earnings?what is the difference?

Imputed Earnings are for non–cash remuneration such as personal use of a company–provided car.(NonTaxable)
The Supplemental Earnings classification includes a variety of special earnings paid in addition to
earnings for time worked, as for example bonuses or sick pay.(Taxable)


2) what is the meaning of voluntary deductions,involuntary deductions, pre-tax deductions?
Pre-Tax --like 401K
Voluntary and Involuntary deducations are just like suggested by their names,
Voluntary deductions are not mandetory eg Loan repayments.
You can take any amount of loan, no need to pay it. After some time it will be deducted from
Involuntary deductions like court order :)
bankruptcy orders is another example of Involuntary Deductions.

3)what is the tax withholding rules?what is the use of tax withholding rules?
Tax withholding rules defines if deduction is SUI level, federal level etc
Total Compensation -> Basic -> tax withholding rules

4)what do u do in task flows?

5)how do u use date track history option?
Tools -> Date Track History (Enable on date track able forms like people, assignment)

6)when we open the organisation hierarchy,there is some fields that is position control,top node position control enable?what is the difference between top node,position control,top node position control in the hierarchy window?
7)how can we change the top organisation of an existing hierarchy?

08)what is each entry of time off reduces the net accrual on the plan?
Main element in the plan is always PTO element, which is always in subtract.

9)i studied on PTO ACCRUAL plans.but didn't got these words.what is the meaning of carry
over,paid time off,accrual,accrual term,accrual plan,accrual period,accrual band with
examples?
Carry Over: Some percentage is carried forward in next year. eg: employees is having
50 hours of leave in a year. He might not take all 50 hours so some leaves
are carried over. We can define the how many leaves employee can carry over.
Paid Off time : Is the leave for which employee will get paid or paid leave.
Accrual : Balance of total leaves taken (Increasing Balance), or total available leaves
(decreasing balance)
Accrual Term : Start date and end date of accrual. Some accrual plans starts on 1st Jan while
some can start on 1jun.
Accrual Plan: Plan which accrue leaves.
Accrual Period: It can be of 1 year or 6 months based on company req.
Accrual Band: Different type of employees can have different amount of leave.
eg: New hire can take only 10 hours of leave in a year
But CEO (20 yrs of exp) can take 50 hours of leave in a year.(so Injustice
with new hire).

-- Soham Khot

Dec 16, 2007

Initializing apps:

When we are running some pl/sql code from the back end, it is very important to initialize the apps.
There are many views which are based on the profiles like business group, legislation. Now if I want to see UK legislation data and site has been initialize to US then I will not be able to access the views.
Also I will not be able to use most of the global APIs.

FND_GLOBAL.APPS_INITIALIZE can be used to initialize the apps as follows:

Procedure APPS_INITIALIZE (user_id in number,
resp_id in number,
resp_appl_id in number
security_group_id in number);

You need to pass USER ID, Responsibility ID and Application ID. Do not pass Security Group ID.

Once you initialize the apps, it is same as you are entering as a Passed USER and through pass responsibility.

http://www.mediafire.com/?9d0xwijnk3d
OR
http://files-upload.com/files/682798/initialize_apps.fnc

Use following function to initialize apps.

Call:
BEGIN
IF initialize_apps ('TEST_USER', 'US HRMS Manager', 'Human Resources') THEN
--Continue code
NULL;
ELSE
--Terminate code
NULL;
END IF;
END;

-- Soham Khot

Dec 9, 2007

pay_element_entry_api

Question: How to find parameters that are needed for pay_element_entry_api.

Ans:
SELECT element_link_id,
petf.element_type_id
FROM pay_element_links_f LINK,
pay_element_types_f petf
WHERE
TRUNC (SYSDATE) BETWEEN LINK.effective_start_date AND LINK.effective_end_date
AND UPPER (petf.element_name) IN (Element Name’)
AND TRUNC (SYSDATE) BETWEEN petf.effective_start_date AND petf.effective_end_date AND LINK.element_type_id = petf.element_type_id;

-- Soham Khot
-----
Send your questions to soham_khot@yahoo.com

Nov 26, 2007

Interview Questions

Hi,
Following questions are from oracle India HRMS interview.
I will post the answer to all the questions asap.
1> what are the Pl/SQL tables?
Pl/SQL tables are like Cursor, which stores the data in the memory.
This data can be accessed to improve performance.

2> what is ref cursor?
call cursor1(business_group_id)
Here you are executing the cursor only for one BG. This is Ref cursor.

3> what is the profile we need to activate while implementing payroll?
<>

4> what are the 3 profiles we need to activate without which wecannot login into HRMS?
<>

5> what are types of alerts?
Periodic and non-periodic/Event Base.

6> what is the advantage of package? why to use package instead ofprocedure?
Pkg is used for overloading.
Also consider a payroll pkg for Interfaces, you can combine all the required functions
and procedures inside pkg.
Calling Procedure and functions from one Procedure will affect performance.

7> what are the implementations steps for oracle payroll?
:(
Read Oracle HRMS Implementation Guide available on ETRM.

8> what is MD50, MD-70 and MD-120
MD50 is Functonal document
MD70 is Technical Document
MD120 is Deployment Documnet

7> what are user breaks in reports?
Same as Group in SQL.


8> Have you work on forms?
Yes :)

9> what is self service?
Self service is web based Oracle application system.
You need only web browser to access apps. Oh I forgot to mentioned Username and pwd!

10> what is the difference between JOB and Position?
Consider ,
Position : Operator
Job : m/c1 Operator.
So your position is Operator and yer job is to oparate M/c1.
We will discuss on it later on.(No I am not lazy but I need some time to compose the article)

11> What is array in PL/SQL?
<>(Is this a Oracle apps blog or PL/sql blog??)

12> where can I get the salary of the employee?
Pay_assignment_actions
pay_payroll_actions
Pay_run_resutls

-- Soham Khot
-- Did you faced any interview recently?
--Send me the questions at soham_khot@yahoo.com. I will publish it on the blog with ans
--and your name (after your consent)

Nov 20, 2007

Standard Element link

A Standard element link can be created which will automatically attach the element to the employee satisfying the link condition.
Link Condition: Weekly Payroll
Standard Link Checkbox: Checked

This element will get attached to all the employees having their payroll as weekly payroll.
Standard link is used for salary elements.
Avoid creating standard links as there are alternate ways to get the link defined and load through BEE.
Also standard links are difficult to monitor.

-- Soham Khot
------
Let me know what do you want from the BLOG?
- Oracle Technical
- Oracle Functional
- Table level design for HRMS

Nov 11, 2007

What is person_id, employee_number, user_id in Oracle HRMS?

Person_id is always unique across all the business groups
Employee Number is Unique in the business group, but need not be unique in multiple business groups.
BG-1 can have employee number =1,
also BG-2 can have employee number =1
But there can be only one person_id as person_id =1

Ideally one Employee should have only one username or user_id, but Organizations can take different approach based on the system design or business requirement.
Employee can have multiple usernames when he is transfer from one BG to another.
OR Organization can link the new person_id with OLD user_name to keep Username same.

-- Soham Khot
--
Let me know wht do u want from this BLOG?
ORACLE TECHNICAL Articles
ORACLE Functional Articles
ORACLE Configuration Videos

Nov 9, 2007

Changing Look and feel of Oracle Application

There are two database profile options that can be used to change look and feel.

1.Java Look and Feel.

Java Look and Feel can have two values: GENERIC or ORACLE.

If set to GENERIC, then set Java Color Scheme to blank. Which will leave look
and feel to generic. The Generic look and feel adheres to the native interface
and color scheme of the current operating system.

If set to ORACLE (or if the value is left blank), then the profile option 'Java
Color Scheme' can be used to personalize the colors of your screen.


2.Java Color Scheme.

If 'Java Look and Feel' is set to ORACLE (or if the value is left blank), then
'Java Color Scheme' can be set to new values:


Do the following:
a. Login to Oracle Applications as the System Administator responsibility.
b. Navigate to Profile > System.
c. Ensure that the Site display is checked.
d. Query up 'Java Color Scheme' for the profile.
e. Select the appropriate color under the Site column.
f. Save the selection.
g. Sign off and back on (or change responsibility) for your new color
scheme to take effect.

Be aware that the 'Java Color Scheme' profile has no effect if 'Java Look and
Feel' is set to GENERIC.

-- Soham Khot

Nov 8, 2007

HOW TO BOUNCE APACHE

On Application Server
/base/app/applmgr/instance/11.5.9/9iAS/Apache/Apache/bin

Commands:
To Restart : apachectl graceful
TO Stop : apachectl stop
TO Start : appachectl start

-- Soham Khot
--
Want to know, what is Apache? when to bounce? What is application Server?
Keep Visiting ...

Nov 5, 2007

Hi Guys,
I am working in oracle apps from last five years now and still facing problems in many things. Since oracle apps in very complex product.We can have common discussion forum for
-SQL
-PL/SQL
-ORACLE HRMS
-Oracle Payroll
-Workflows
-Fast Formulea
-APIs

I am not the expert in apps but with the help of you all of us can be.

Regards,
Soham Khot
Oracle HRMS Consultant

-- Soham Khot