1. when we r doing interface/conversion which things u will
take care to improve the perfrmonce?(except bulk collect)

2. In conversion,u r loading the data using sql*loader,I dnt
want to use sql*loader,& i have millions of records,Id der
any way to load the data withing fraction of time
considering best performance.

3. When u r doing conversion,taht using sql*loader u r
loading data into staging table,u r writing control file bt
I dnt want to use sql*loader,when u r creating con prog that
time can we pass all values from flat file using
paramere,valuset?how?

4. In flat file u got 50 records,out of 50 ,30 records are
proceesed & inserted into base table,after taht clien
understood that 1 item having wrong name e.g insted of ABC
he given DCE, so can we delete?hw?(client permission is der)

i have lot of wrong item name randomly spreaded,can we
delete it?hw?

5.after doing validation hw u will follow approach to error
out records?if i want to send all the error out records to
client daily,whats ur approach?

6. In outbound interface is der any way to load the
data(large data-millions of records) except UTL_FILE package?

7. what is parsing?

8. In technical doc.s which section will mention?except code?

9. Do u have any idea about code depository tool?

10.whats is performance tunning,DB link?

11, How u will do RMA?


Answers were Sorted based on User's Feedback



1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(ex..

Answer / amar

Question 2 - Answer :

With help of Oracle External Tables

Is This Answer Correct ?    7 Yes 1 No

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(ex..

Answer / saurabh

1. Basically many. Apart from using Bulk collect one can be to flag records already processed so that in the next run, not all records are processed again. If using Database 10g or higher, for Packaged functions based on Master Tables, one can choose using RESULT_CACHE. This goes without saying that all queries should be checked for the cost and plan and check for Full Table Scans or high costs.

2. You can use External Table or look into using Database Links.

9. Tortoise SVN. Used as code depository and versioning.

10. Performance tuning can span from Application (Front End) to backend (Database) to a process. In Oracle eBS, for frontend, one can take trace navigating to Help > Diagnostics > Trace >. For database (including PLSQL Packages, procedures, function one links to Concurrent Programs), one can apps initialize the session and execute the PLSQL unit after enabling TKPROF.
DB Link is a way you can link a remote database and access its object from the current database. Following is the command to create Database Link:
CREATE DATABASE LINK <DB_LINK_NAME> CONNECT TO <CUSTOM_USER> IDENTIFIED BY <CUSTOM_USER_PASSWORD> USING <REMOTE_DB_CONNECT_STRING>;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

How to move the one file from one instance to another instance? And your scripts also?

0 Answers  


What r the type Models in the system parameters of the report?

1 Answers  


for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  


differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,






what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,


what are the types of interfacing?

3 Answers   TCS,


The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,


name all status attributes.

1 Answers   Scan Steel,


testing tools?

0 Answers   BirlaSoft, Convergys,


Can you have two functions with the same name in a pl/sql block?

5 Answers   TCS,


types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)