Oracle Apps technical questions List-5

1. What are the interfaces you worked on?
2. What are the different validations you performed on the staging table?
3. Name some interface table?
4. What are the API’s you used?
5. Tell me about your role in your past projects.
6. What are the major customizations or achievements you got in previous projects?
7. How would you rate yourself in PLSQL?
8. What are varrays?
9. How table types are differ from database tables?
10. How will you load bulk data from a table type to a table?
11. What are the functions that are available for a table type?
12. How you delete a particular data in a table type?
13. What are the different exceptions that are available?
14. What if I define when others first in Exceptions block?
15. What are database triggers?
16. Name some database triggers.
17. Can we write triggers on a view?
18. Can we insert into two tables at a time using single insert statement?
19. How can we register a concurrent program?
20. Among xml publisher reports and RDF reports which is comfortable?
21. What is used in a concurrent program to pass as a parameter to a report?
22. What are the triggers available for reports?
23. How will you send a report as a mail?
24. What is bursting?
25. How comfortable are you with forms?
26. Name some triggers that are mandatory for a form?
27. What is process for RDF reports?
28. How to start the process of page personalization in OAF if you are given a base page?
29. How will you deploy a OAF page?
30. Why we are using Import after page deployment to server?
31. What are the tables that are related to OAF?
32. If I want the structure of the page how can I get and what are the different ways to achieve this?
33. What is substitution? Why we are doing it?
34. Tell the importer command? What are the different ways to import a page?
35. Why VO.xml files are not getting imported?
36. What is MDS data and how it is getting generated?
37. How will you extend a Controller for a page and what is the step by step process that needed to be followed?
38. How will you debug a Concurrent program?
39. Explain P2P cycle and O2C cycle with tables and different stages, tables involved in the process?
40. What are different value sets available?
41. What is ADF-DI?
42. How ADF-DI is different from forms? What are the advantages and disadvantages?
43. If I want to have headers and line details we are doing it by forms and ADF-DI which process is preferable and how much time will it take to complete?
44. What is Copy and No Copy?
45. What is the difference between View and Materialized View?
46. What is the hierarchy of tables for Purchase order?

Oracle Apps technical questions List-4

1. introduction, what modules you know
2. forms in profile
3. forms from scratch level - steps to be followed
4. forms personalization coparision with custom.pll
5. what are the tables for forms personailization.
6. triggers used in forms and forms personalization.
7. what are collections and how many types of collections. where did you use.
8. reports - RDF
9. User exits -
10. new report from scratch - steps
11. xml publisher - triggers used
12. Any advanced tech. ADF and OAF
13. workflows -  No experience
14. UNIX - unix commands where you have used in your experience
15. triggers - types of triggers and mutating error
16. how to get report name with conconrrent program name
17. How many procedures are there in SRW
18. wat is the purpose of userexits
19. diff. between case and decode

Oracle Apps technical questions List-3

1.Brief about yourself
2.what is the recent xml report you developed.
3.RDF reports
4.on what areas your more comfortable reports or pl/sql
5.MOAC Architecture
6.AP module Difference in 11i and R12
7.Performance Tuning real time scenario
8.Bursting program fuctionality
9.concurrent program migration from 11i to R12
10.How to make changes to the standard report
11.work experience into API
12.regardig kintana and clearcase usage
13.difference between oracle session id and transaction
14.difference between database table and plsql table
15.value sets and types
16.have u worked on form personization.what personalization u have done
17.have u worked on OAF.
18.SLA concepts and difference in 11i and R12
19.how XML reports has been replaced in your project is there any different tool they are using earlier, if yes?
20.OU level modules
21.any idea on SOA or ADF
22.how strong into interfaces and conversions
23.LOgo and image printing functionality through reports
24.what are your roles and responsibilities in current project
25.How to upgrade the package or custom code from 11i to R12

Oracle Apps technical questions List-2

1.Brief about yourself
2.order to cash life cycle  along with involved tables
3.Types of ap invoices
4.credit memo and debit memo
5.ap tables
6.what is cursor
7.cursor attributes
8.what is bulk collect
9.what is trigger
10.util file vs sqlldr, which one is good for data loading ? why ?
11.what type of interface you worked
12.how to register forms
13.how to register xml template
14.types of triggers in reports
15.what is the usage of srw
16.triggers are in forms
17.where u have used xml publisher what kind of things you known on this
18.workflow analysis (item, notifications,approvers)
19.how to register bar code

Oracle Apps technical questions List-1

1.Brief about yourself
2.Business event and its parameters
3.Difference between Business event and Database triggers
4.About global temporary table- where you are using in project
5.Mandatory parameters of concurrent program

create or replace procedure main(errbuf OUT varchar,retcode OUT number)
this is used for plsql procedure

6.why retcode and errbuff in concurrent programs

Oracle standard process will supportConcurrent program


7.DFF creation and its uses
8.what is Bursting and its examples
9.Tell about SQL Loader(control file definition, bad file and log file details)
10.what are Inbound (how API will be used) and outbound file processing in your project ?
11.Mutation and how it can be avoided
12.What migration tool you are using and any other options
13.Difference between transaction and pragma transaction
14.How many transaction id's will be created while bursting
15.how the email will be sent to the multiple recipients using bursting
16.where the menu exclusion option is there in Apps screen.