Apps Technical Interview Questions asked in wipro

            1. What are different cursors available?

            2. What are cursor attributes?

            3. Can we use sql%found in Explicit cursors opened in cursor for loop?

            4. What is token?

            5. What is init pragma exception?

            6. How do you define a table type value set depending on another table value set?

            7. In this case, if the child parameter has sequence no. as 5 and the parent parameter has sequence no. as 10, what is the effect? When you will get the error and what is the error?

            8. What is the order flow including tables effected at each stage?

            9. What is the hierarchy of Multi org concept?

            10. Where do you define the ‘Set of Books’ in Multi Org Concept?

            11. In which table, you will get Organization_id and in which tables, you will get org_id?

            12. What is Run alone report?

            13. What is incompatibility in Report definition?

            14. What you have done for an interface?

            15. What is the procedures you have done?

            16. Any API used in your procedures?

            17. What are different APIs available in Oracle Apps?

            18. How the oracle Applications recognizes the print style?

            19. what is the use of Row & column columns in Report Definition above the printer style?

            20. When the workflow back end process will run in the order cycle?

            21. Can you customize a workflow?

            22. How a multi org concept effects in GL module?

            23. What is a miscellaneous receipts & issues?

            24. Do you face any performance related issues in your work?

            25. What is TCA architecture?

            26. What are the tables effected when ‘ship confirm’?

            27. In the order cycle, where it is interrelate with other oracle modules like INV, AR etc.

            28. what are the table affected when you make a customer under credit hold?

( hz_customer_profiles)

            29. What is the data available in HZ_CUST_ACCOUNTS and HZ_CUST_ACCT_SITES_ALL?

            30. Which trigger fires first in Reports?

            31. What will fire first when a parameter is defined in Report in Reports 6i and the parameters are not defined in Program definition?

            32. Can we give a parameter as mandatory(i.e. Required flag –Yes) and display is disabled?

            33. What are the possible values we can give in a value set?