Oracle Apps Interview Questions Asked for Technical and Functional Consultant .
1) P2P cycle with tables affected.
2) Difference in cycle 11i and R12.
3)What is XLA and TCA.
4) Link of XLA with AP and GL.
5) Accounting in AP.
6) IBY and PPR in R12.
7) How to know whether Po is matched 2-way 3-way or 4-way from backend.
8) How to know the values of DFF's from backend. Table?
1) User exits in Reports
2) Supplier A and Supplier B, 2 different organizations... how to set the output of the report so that A would be able to see the data of organization A and likewise.
3) Report runs to page 1-2-3-2-1 which triggers will fire and in which sequence and how many times.
4) Explain any complex report and ur approach.
5) Conditional formatting.
6) Amount sum at each page and total sum at last page.
Forms
1)Difference in 11i and R12.
2) Triggers and their use.
3)change in triggers
4)user defined triggers
5) LOV has 3 values for India and 1 value for US. How to set that if we open the form from US resp. only one value will be seen and three for India resp.
6) Alerts
7) Types of Canvass and thier Use.
8) Use of MOAC in forms.
PL/SQL
1) Business scenario where u used Pragma autonomous.
2) Major difference between proc and functions, decode and case, in and exists, substr and instr
3)types of pragma . explain
4)advantage and disadvantage of collections
Some more were there....
Interfaces.
1) On which interface u have worked upon and validations apart from Oracle standard.
2) Any conversion u have done.
AOL
1) Value sets in a value set. Possible? If yes How.
2) Scenario on $flex$.
3) Default types.
Some more were there...
XML
1) How many ways to create data definition.
2) Any standard package involved in it. Name it.
3) Can u write direct XML to load. How will u write the tags in it.
4) scenario on Conditional templates.
5) what is xdofo, xliff and xsl in BI publisher. have u used them.
6) How to register.
Some questions on discoverer- Not needed as it was mentioned in my profile.
1) P2P cycle with tables affected.
2) Difference in cycle 11i and R12.
3)What is XLA and TCA.
4) Link of XLA with AP and GL.
5) Accounting in AP.
6) IBY and PPR in R12.
7) How to know whether Po is matched 2-way 3-way or 4-way from backend.
8) How to know the values of DFF's from backend. Table?
1) User exits in Reports
2) Supplier A and Supplier B, 2 different organizations... how to set the output of the report so that A would be able to see the data of organization A and likewise.
3) Report runs to page 1-2-3-2-1 which triggers will fire and in which sequence and how many times.
4) Explain any complex report and ur approach.
5) Conditional formatting.
6) Amount sum at each page and total sum at last page.
Forms
1)Difference in 11i and R12.
2) Triggers and their use.
3)change in triggers
4)user defined triggers
5) LOV has 3 values for India and 1 value for US. How to set that if we open the form from US resp. only one value will be seen and three for India resp.
6) Alerts
7) Types of Canvass and thier Use.
8) Use of MOAC in forms.
PL/SQL
1) Business scenario where u used Pragma autonomous.
2) Major difference between proc and functions, decode and case, in and exists, substr and instr
3)types of pragma . explain
4)advantage and disadvantage of collections
Some more were there....
Interfaces.
1) On which interface u have worked upon and validations apart from Oracle standard.
2) Any conversion u have done.
AOL
1) Value sets in a value set. Possible? If yes How.
2) Scenario on $flex$.
3) Default types.
Some more were there...
XML
1) How many ways to create data definition.
2) Any standard package involved in it. Name it.
3) Can u write direct XML to load. How will u write the tags in it.
4) scenario on Conditional templates.
5) what is xdofo, xliff and xsl in BI publisher. have u used them.
6) How to register.
Some questions on discoverer- Not needed as it was mentioned in my profile.
No comments:
Post a Comment