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
May 4, 2010
Google Chrome and Oracle Apps.
Posted by Soham 2 comments
Labels: Software
Sep 25, 2009
Microsoft Internet Explorer 8 and Oracle Applications
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
Posted by Soham 2 comments
Aug 3, 2008
Oracle Audit Trail
Do we need oracle Audit?
Find out more on oracle Audit.
Uploaded on authorSTREAM by soham_khot
--
Soham Khot
Posted by Soham 1 comments
Labels: Oracle Audit Trail
May 11, 2008
Initiating Workflow from pl/sql
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
Posted by Soham 3 comments
Labels: Workflow
Apr 30, 2008
Free Access to an Oracle Vision Instance
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
Posted by Soham 3 comments
Labels: Instance
Apr 22, 2008
Flex Program Vs Non-Flex Programs
What is the difference between flex programs and non-flex programs?
Posted by Soham 0 comments
Labels: Discuss
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
Posted by Soham 0 comments
Labels: Interview