Hr round describe about yourself in brief current CTC notice periods negotiable about skills in Reports Forms interfaces conversation and workflows and oaf
Oracle Apps Technical Interview Questions
25 oracle apps technical interview questions shared by candidates
PL/SQL - Let's say we have a PL/SQL block in which we have 2 Exceptions. 1) WHEN NO_DATA_FOUND THEN 2) WHEN OTHERS THEN. In the Exception part of the block, the exception - WHEN OTHERS THEN is written before WHEN NO_DATA_FOUND Exception. Then what kind of error do you get? Will the code work? (Hint - Compilation Error)
SQL - How do you get distinct records in SQL?
Technical - skils interview and module wise knowledge.
1. Technical RICEW and OAF 2. Managerial includes your strength , weakness , goals.
What do you know about PRAGMA AUTONOMOUS TRANSACTIONS?
First round was pretty good, questions on the areas that I've worked on and plsql coding. Second round was more in a detailed way, like giving some scenarios and asking questions around it.
Function in SQL nvl,nvl2 and coalesce lookups and valuesets
Oracle EBS Apps (Functional) - How do you link Sales Order (OM) Tables with Invoice (AR) Tables.
PL/SQL - What do you know about the statement - EXECUTE IMMEDIATE? (Hint: Dynamic SQL)
Viewing 1 - 10 interview questions
See Interview Questions for Similar Jobs
Oracle Apps Technical ConsultantOracle AppsOracle Applications Business Systems AnalystOracle GrcSenior Oracle Applications Technical ConsultantTechnical Consultant Oracle ApplicationsOracle Applications Functional ConsultantOracle ApplicationsSap Abap Java DeveloperOracle Apps DbaFunctional Consultant Oracle ApplicationsOracle Applications ConsultantOracle Applications Functional Business AnalystHyperionOracle Hrms Functional ConsultantOracle Financial Systems AnalystSap Erp ConsultantOracle Applications Developer