May 4, 2010

Google Chrome and Oracle Apps.

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

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

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

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

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

Apr 22, 2008

Flex Program Vs Non-Flex Programs

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

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