Oracle Apps Technical Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle Apps Technical Interview Questions

Questions Answers Views Company eMail

where we will put the control file ,where we will run sql star loader what is the cmd?

Cap Gemini, KPMG,

1 8559

how to move the one file from one instance to another instance?and ur scripts also?

KPMG,

1 8192

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

KPMG,

1 7886

in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?

Oracle,

1 8926

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

Oracle, Schneider,

2 9769

how to print multi lay outs,muti currency,muti language in xml publisher

Deloitte, Oracle,

2 12297

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

IBM,

1 5222

what is instead of trigger in where u will use?

TCS,

2 8270

How to print multi currency,multi language in xml?

1 9400

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

Satyam,

1 6889

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

Satyam,

3 9618

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

Satyam,

3 9517

Hi Experts How to Create a purchase order without a requisition ?

Amdocs, KPMG, Oracle,

6 14251

Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

16 28209

what is tuning in oracle apps technical

TCS,

3 12953

Post New Oracle Apps Technical Questions

Un-Answered Questions { Oracle Apps Technical }

List the types of flexfield?

1044

In support project one ticket alloted which steps follows manualy tell me ?

2666

Can we create tables in apps schema?

1144

What do you understand by concurrent programs?

1108

tell me the scenarios of the independent in reports

2514

Can you differentiate between mediator and osb?

1147

How can you achieve loose coupling in soa framework?

1230

What is the concept of soa governance?

1256

What is a value set? List its various types.

1100

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1123

How can we import the data into a database using sql * loader?

1196

is it possible to run the interface without using oracle apps?

1983

What do you understand by soa and what are the benefits of using this architecture?

1093

Can u give the Documentation of Custom.pll in oracle apps

3483

For More Un-Answered { Oracle Apps Technical } Questions Click Here