1 person found this helpful
You need to learn SQL, PL/SQL, Oracle Reports, BI Publisher and possibly OBIEE.
If you would like to be Oracle Apps Technical Consultant, SQL, PL/SQL, Forms, Reports, ADF, OAF, Workflow are the things you should be focusing on.
Additionally attend course on Apps Technical as you need to understand how these skills will be used in Oracle Apps.
It depends... were you a developer in the previous system or an end-user? As an end user then whilst you need a sound understanding of the data and ability to understand built-in functions (to diff two dates etc), you shouldn't need to know SQL or PL/SQL if using things like OBIEE dashboards. Even as a dashboard developer you can get away without knowing this so long as the subject areas have been built properly for you by another developer.