Oracle Applications

Google Chrome and Oracle Apps.

noreply@blogger.com (Soham) — Tue, 04 May 2010 05:55:00 +0000

UPDATE:

Oracle apps is working on google chrome now.(version 4.1.249.1064 and J2SE Plug in version 1.6.0_16). It is amazingly fast on chrome. I will test it more and log the bugs here, if any.

You will not be able to use google chrome for running oracle applications.Google Chrome is in beta for now.
No dynamic apps will run.Even if you install Jinitiator after getting a prompt, it will not be able to launch
application.But google will make it available soon.

-- Soham Khot

Microsoft Internet Explorer 8 and Oracle Applications

noreply@blogger.com (Soham) — Sat, 26 Sep 2009 03:03:00 +0000

Microsoft Internet Explorer 8 is now certified as a client browser for Oracle E-Business Suite Release 12.

E-Business Suite Release 12.0 Prerequisites
         R12.ATG_PF.A.DELTA.6 (patch 7237006) or later
         Oracle Forms Version 10.1.2.3 or later
         Windows XP Service Pack 2 or 3/Windows Vista Service Pack 1 or 2

E-Business Suite Release 12.1 Prerequisites
         Oracle E-Business Suite 12.1.1
         Windows XP Service Pack 2 or 3/Windows Vista Service Pack 1 or 2

But it is not yet certified with 11i.As per oracle it will be available soon.
Update: IE8 is certified for 11i now.

check : http://blogs.oracle.com/stevenChan/2009/10/internet_explorer_8_certified_ebs11i.html

Please refer to following link for more information:
http://blogs.oracle.com/stevenChan/2009/09/internet_explorer_8_certified_ebs12.html

Thanks,
Soham Khot

Oracle Audit Trail

noreply@blogger.com (Soham) — Sun, 03 Aug 2008 22:40:00 +0000

Do we need oracle Audit?
Find out more on oracle Audit.

Uploaded on authorSTREAM by soham_khot

--
Soham Khot

Initiating Workflow from pl/sql

noreply@blogger.com (Soham) — Mon, 12 May 2008 01:28:00 +0000

There are many ways to invoke workflow. Let’s see how we can start a workflow from pl/sql package.

Inputs needed: Obviously, validated workflow which is saved in database.
Itemkey: Get the itemkey for the workflow you want to initiate.
Process Name: Get internal name of the procedure in the workflow which you want to initiate.

Call following APIs in the given sequence.

1> wf_engine.createprocess
This API creates a new runtime instance of the workflow process, Pass the item type and item key for the workflow.

2> wf_engine.setitemuserkey
Use this API to mark the new runtime instance of the workflow process with an
end–user key

3> wf_engine.SetItemAttrText
Use this API to set values for the item type attributes defined for workflow process .E.g.: Email ID, Description defined in the workflow.

4> wf_engine.setitemowner
Use this API to set the value of owner (Of Workflow)

5> wf_core.context
In case of exception, it will help in locating source of an error.

6> wf_engine.startprocess
Use this API to invoke the workflow for the item type and item key specified.

All the APIs are explain in Oracle Workflow API Reference Guide.

---Sample Code ---

DECLARE

l_itemtype VARCHAR2(30) := 'XX_TEST';
l_itemkey VARCHAR2(300) := 'TEST';

BEGIN

Begin
wf_engine.createprocess(l_itemtype, l_itemkey, 'XX_MAIN_TEST');
Exception
when others then
dbms_output.put_line('Error in create process:' sqlerrm);
End;

BEGIN
wf_engine.setitemuserkey(itemtype => l_itemtype
,itemkey => l_itemkey
,userkey => 'USERKEY: ' l_itemkey);
EXCEPTION
when others then
dbms_output.put_line('Error in set userkey process:' sqlerrm);
END;

BEGIN
wf_engine.setitemowner(itemtype => l_itemtype
,itemkey => l_itemkey
,owner => 'SYSADMIN');
EXCEPTION
when others then
dbms_output.put_line('Error in set owner process:' sqlerrm);
END;

BEGIN
wf_engine.startprocess(l_itemtype, l_itemkey);
dbms_output.put_line('Process started');
commit;
EXCEPTION
when others then
dbms_output.put_line('Error in set owner process:' sqlerrm);
END;
END;
/

-- Download the code.
Get the Code

When to use pl/sql calls?
Pl/sql calls can be used for mass uploads (not conversion), interface with the 3rd
party systems. Also to initiate approvals and to send emails from pl/sql.

In next posts I will explain which are the other methods to call workflows, how to monitor them and how to troubleshoot workflow issues.
Please let me know your comments/feedbacks.

Thanks,
Soham Khot

Free Access to an Oracle Vision Instance

noreply@blogger.com (Soham) — Thu, 01 May 2008 00:21:00 +0000

Solution Beacon is offering free access to our Release 11i and Release 12 Vision instances.
You will not get backend access to database and Unix box. But atleast you will get front access with sysadmin responsibility.

Solution Beacon

Enjoy,
Soham Khot

Flex Program Vs Non-Flex Programs

noreply@blogger.com (Soham) — Tue, 22 Apr 2008 19:45:00 +0000

What is the difference between flex programs and non-flex programs?

noreply@blogger.com (Soham) — Sun, 23 Dec 2007 16:28:00 +0000

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

noreply@blogger.com (Soham) — Mon, 17 Dec 2007 01:39:00 +0000

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

pay_element_entry_api

noreply@blogger.com (Soham) — Mon, 10 Dec 2007 01:51:00 +0000

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

Interview Questions

noreply@blogger.com (Soham) — Tue, 27 Nov 2007 03:13:00 +0000

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)

Standard Element link

noreply@blogger.com (Soham) — Wed, 21 Nov 2007 01:09:00 +0000

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

What is person_id, employee_number, user_id in Oracle HRMS?

noreply@blogger.com (Soham) — Mon, 12 Nov 2007 01:37:00 +0000

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

Changing Look and feel of Oracle Application

noreply@blogger.com (Soham) — Sat, 10 Nov 2007 00:50:00 +0000

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

HOW TO BOUNCE APACHE

noreply@blogger.com (Soham) — Thu, 08 Nov 2007 19:14:00 +0000

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 ...

noreply@blogger.com (Soham) — Mon, 05 Nov 2007 18:18:00 +0000

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