2. PL/SQL
3. Forms
4. Reports
5. OAF
6. XML Publisher
7. Workflow and AME
8. Interfaces
9. Conversions
10. PL/SQL Collections and Bulk Binding
11. XML Report Bursting
12. AOL
13. Procure to Pay
14. Order to Cash
15. Accounting Entries
16. Basic Setups
17. Performance Tuning
18. S3 Buckets - AWS
19. Encryption
20. XML - XSLT (example)
21. HTTP Request to send data to Transaction Bridge
22. WSO2 Concepts
23.Transaction Bridge
24. Topology
25. TCA Architecture
26. XLA Tables and Joins and Queries
27. SQL Loader
28. Connect by PRIOR
Interview Questions -1
Can we Write DML Statements in a Function ?
No, If we want we can write using Pragma Autonomous Transaction
How to Handle Bulk Data
Bulk Exceptions
Bulk Binds
Parallel Porcessing
Table Partitions
Indexes
Batches
How to delete the duplicate rows
How to handle duplicate records while processing
How to handle Exception Handling
RAISE APPLICATION_ERROR
Interview Questions -2
difference between 11i and R12 in general
• difference between process_order API parameters between 11i and R12
• how to import high volume of orders into Oracle
• shipping tables and their joins
• what are versioned components in Oracle Workflow and workflow customizations I have worked upon
• sequence of event execution in Oracle forms, custom.pll and forms personalization
• what are business events and how their architecture works
• what are pragma autonomous transactions
• difference between pragma exceptions and normal exceptions
• benefits of bulk collect and how it improves performance
• how to improve performance of a concurrent program
• Questions was mainly focused on Order management, shipping and inventory.
• For example what are the differences between 11 and r12.
• Order to Cash flow.
• what tables are updated.
• Process in customizing work flows ?
• what is VPD?
• Major concentration is how well you know OM in general.
Actual:
1. A conc program is running for more time than usual. What approach you follow to debug and how can you face the customer
2. Order to cash flow
3. Shipping tables and their joins and its time of populating data
4. Delivery assignment table use
5. Release statues
6. How to know whether order is pick relerased
7. Can we use commit in a trigger
8. What is the other way to commit in trigger
9. How can you approach that
10. What is difference between form personalization and custom.pll
11. What are limitations of using custom .pll
12. What is difference between 11i tables and r12 tables
13 How to set multi org structure
14. What is the difference of multi org in 11i and r12
15 How to approach 1millon of data to process in 10 min What approach you follow
16. What is bulk bind
17. How will be the performance affects if we use indexes and triggers
18. How many ways we can create the index
19. How can we use parallel hints
20. What table changes will happen while the order line gets back order
21. What are Defaulting rules
22. Process constraints
23. Defaulting rule comes under which module
24. can we cancel a order at pick confirmed order
25. How Can we cancel a order
26. Can we get the order number in wsh_delivery_details
27. What are the column joins available in wsh_delivery_details and oe_order_headers and oe_order_lines
No comments:
Post a Comment