AOL, SQL, PL/SQL, Forms, Reports, Workflows (AME), OAF, RICE, Tuning Queries, Migration, Interfaces,User Hooks, XML Publisher, HRMS API’s, FNDLOAD, Alerts, Shell Scripts etc
Functional and Technical Support for Oracle EBS R12.
1: Call the CP, Standard Form, DFF, and KFF in SSHR and oaf region, CP output in Workflow notifications
2: Developed OAF Form using Gantt chart for employee leaves chart with the integration of workflow.
3: Developed OAF Forms with integration of XML Publisher common region/employees drilldown Report.
4: Developed OAF forms to export data into excel, submitted CP in SSHR, Copying Data from One table to another table using ROWSETITERATOR, download/upload files to server or vice versa
5: Displaying popup and scrollbars into table and advance table regions and setting alerts, logs, attachment
6: Usage of callable & prepared statement and disabled browser back button, disabled right click
7: Displaying Data from DB, DML on Data Entry Pages using different regions used in SSHR.
8: Calling One Form to another Form with parameters using session, transaction, hash map and forms parameters. Also extending the functionality using dirty VO, attachment and tab pages functionality, implemented train, Shuttle, Switcher Regions, nested AM etc. OAF Customization deployment cycle
9: Displaying employees info using Date picker, SPEL, PPR etc. displaying master-details regions in SSHR
10: Automatic Search, Inline, Dependent, External LOV and applied row level validations
11: Result and Manual Based Search using query and actions/selections of table region
12: Migration of OAF forms, workflows, Reports and personalization into productions using code pack.
13: Developed supplier service using SVO and SAM and applicant registered using web service
I m experienced and certified looking for a job