Search found 195 matches

by akumar.oracle
Sun Jul 17, 2011 8:43 pm
Forum: Oracle Forms & Reports
Topic: Why do SQL query run slow first time?
Replies: 0
Views: 4015

Why do SQL query run slow first time?

Hi,

I came across one interview question.
The interviewer asked me why do SQL query run slow first time. Explain in detail.

From what I know its because of CACHING.

Any suggestions?

ta
Arvin
by akumar.oracle
Tue Nov 16, 2010 11:37 pm
Forum: Application DBA & System Administration
Topic: versions of EBS
Replies: 0
Views: 3406

versions of EBS

Hi

Can anyone please tell me what are all versions in R12

is 12.1.1 latest?

cheers,

Arvin
by akumar.oracle
Thu Oct 21, 2010 8:34 pm
Forum: General / Others
Topic: middleware and web servies
Replies: 0
Views: 3873

middleware and web servies

hi,

Can anyone please explain me the difference between oracle middleware and web services?

ta
Arvin
by akumar.oracle
Wed Oct 13, 2010 12:49 am
Forum: General / Others
Topic: weblogic and oracle apps
Replies: 0
Views: 3521

weblogic and oracle apps

hi

I am bit confused on the difference between Weblogic and Oracle Apps..?

Can anyone please tell me what is the role of Weblogic and Oracle Apps (eg 11.5.10.2)..

when both are deployed..

ta
Arvin
by akumar.oracle
Wed Oct 13, 2010 12:37 am
Forum: Operating System
Topic: Sun Sparc Question
Replies: 1
Views: 4064

Sun Sparc Question

Can anyone please tell me the name of widely used Sun Sparc machines on which oracle application is installed?

thanks
ta
Arvin
by akumar.oracle
Thu Oct 07, 2010 11:48 pm
Forum: Oracle Databases
Topic: cursor question help needed
Replies: 0
Views: 4442

cursor question help needed

Which line in the following statement will produce an error?
cursor action_cursor is

select name, rate, action
into action_record
from action_table;
There are no errors in this statement.
by akumar.oracle
Fri Aug 13, 2010 11:52 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Derivatives (bonds and swaps)
Replies: 4
Views: 2040

Derivatives (bonds and swaps)

Hi
Can anyone please explain me in simple words what does Bonds and Swaps means?

and how does we implement it in Oracle ERP?

ta
Arvin
by akumar.oracle
Mon Jul 26, 2010 10:07 am
Forum: Oracle Forms & Reports
Topic: scalar, reference, composite, and large object (LO
Replies: 0
Views: 4316

scalar, reference, composite, and large object (LO

hi

Can anyone please give me example of
scalar, reference, composite, and large object (LOB) data types

ta,

Arvin
by akumar.oracle
Tue Apr 27, 2010 10:25 am
Forum: HCM (Human Capital Management)
Topic: What is Element?
Replies: 1
Views: 1675

What is Element?

Hi,

Can anyone explain me what is the purpose of Element in Payroll? and where else it is used?

thanks in advance

ta
Arvin
by akumar.oracle
Sun Apr 11, 2010 9:43 am
Forum: HCM (Human Capital Management)
Topic: diff between oracle HRMS and peoplesoft HRMS
Replies: 0
Views: 1733

diff between oracle HRMS and peoplesoft HRMS

Hi,

What is the difference between oracle HRMS and peoplesoft HRMS?

ta
Arvin
by akumar.oracle
Sun Apr 11, 2010 9:34 am
Forum: HCM (Human Capital Management)
Topic: Oracle HRMS in Budgeting and Costing?
Replies: 1
Views: 2167

Oracle HRMS in Budgeting and Costing?

hi,

How does Oracle HRMS helps in Budgeting and Costing?

ta
Arvin
by akumar.oracle
Sun Apr 11, 2010 9:30 am
Forum: HCM (Human Capital Management)
Topic: Standard Benefits, Advanced Benefits, CWB
Replies: 0
Views: 1391

Standard Benefits, Advanced Benefits, CWB

Hi,
Can anyone please explain me the purpose of

Standard Benefits

Advanced Benefits and

Compensation Workbench

in HRMS suite?

ta
Arvin
by akumar.oracle
Sun Apr 11, 2010 7:39 am
Forum: HCM (Human Capital Management)
Topic: call pl/sql package function from FastFormula
Replies: 1
Views: 1737

call pl/sql package function from FastFormula

Hi,

How to call pl/sql package functions from within a Fast Formula?

ta
Arvin
by akumar.oracle
Sun Apr 11, 2010 7:32 am
Forum: HCM (Human Capital Management)
Topic: Difference between EIT and SIT
Replies: 3
Views: 3291

Difference between EIT and SIT

Hi
What is the difference between EIT and SIT?

ta
Arvin
by akumar.oracle
Wed Apr 07, 2010 7:56 am
Forum: HCM (Human Capital Management)
Topic: Fastformula to prepare records format for tape wri
Replies: 3
Views: 2035

Bank file that is will be send to bank or the file that is received from the bank?