Oracle EBS Technical Consultant

1. Explain the architecture of Oracle E-Business Suite. 2. What are Concurrent Programs and Concurrent Requests? 3. Explain Oracle Forms and Oracle Reports. 4. What are PL/SQL Procedures, Functions, and Packages? 5. What are Interface Tables? 6. Explain the difference between Interface Tables and Base Tables. 7. What are Oracle EBS APIs? 8. What are Flexfields? 9. Explain Responsibilities and Menus in Oracle EBS. 10. What is a Value Set? 11. Explain the Procure-to-Pay process from a technical perspective. 12. Explain the Order-to-Cash process from a technical perspective. 13. How does Oracle Purchasing integrate with Accounts Payable? 14. A Concurrent Program finishes in Error status. How would you investigate it? 15. An interface loads records successfully into an interface table but fails during import. What would you check? 16. A custom report returns duplicate records. How would you identify the problem in the SQL logic? 17. A Purchase Order is created but the expected accounting information is missing. What would you investigate? 18. A PL/SQL program becomes slow when processing a large number of records. What basic optimization techniques would you consider? 19. A requirement affects Purchasing, Inventory, AP, and GL. How would you understand the end-to-end impact before development? 20. How would you decide between using a standard Oracle API, interface, customization, or PL/SQL solution?