1. Key Responsibilities

A. Technical Responsibilities (Primary Focus)

1. Custom Reports Development C Maintenance

- Develop custom reports using Oracle Reports, BI Publisher, XML Publisher, and OTBI.
- Write complex SQL and PL/SQL queries to extract relevant data for reporting.
- Maintain reports related to finance, inventory, procurement and manufacturing.

2. Application Personalization C Extensions

- Perform Oracle Forms Personalization to modify standard Oracle forms without customization.
- Implement custom workflows, alerts, and approvals using AME (Approval Management Engine).

3. Custom Development C Enhancements

- Develop custom PL/SQL scripts, concurrent programs, and workflows.
- Automate reports and workflows to reduce manual efforts.

4. Technical Support C Troubleshooting

- Debug Oracle Reports, PL/SQL scripts, and concurrent programs.
- Troubleshoot performance issues and system errors.
- Provide technical support for system upgrades, patches, and data migration.

B. Functional Responsibilities (Support C Collaboration)

1. Business Process Understanding C Support

- Work closely with finance, procurement, and SCM teams to ensure accurate reporting.
- Ensure ERP compliance with Indian tax laws (GST, TDS, TCS).

2. User Support C Documentation

- Provide technical training to users on reports and processes.
- Maintain technical documentation, system logs, and change requests.





3. System Upgrade C Patch Management

- Support Oracle EBS patches, cloning, and upgrades.
- Work with DBAs for performance optimization and system monitoring.

2. Required Skills s Qualifications

A. Educational C Qualified Background

- Oracle certifications in Oracle EBS, PL/SQL, or related technologies will be preferred.

B. Technical Expertise (Key Focus Areas)

- Custom Reports Development: BI Publisher, Oracle Reports, XML Publisher, OTBI.
- SQL C PL/SQL Programming: Writing efficient queries, stored procedures, and triggers.
- Oracle Forms Personalization C Workflows: OAF, AME, Oracle Workflow Builder.
- Performance Optimization C Debugging: SQL tuning, troubleshooting reports.
- Security C User Roles: Oracle EBS Role-based access control.

C. Functional Knowledge (Support Role)

- Basic understanding of Oracle EBS Finance (AP, AR, GL), SCM (Inventory, Procurement, OM) and Discrete module.
- Awareness of Indian tax compliance (GST, TDS, TCS) in Oracle ERP.
- Knowledge of ERP business processes and best practices.

D. Soft Skills

- Robust analytical and problem-solving skills for debugging ERP issues.
- Excellent communication skills to collaborate with functional users and technical teams.
- Ability to manage multiple priorities and work under tight deadlines.

📌 Oracle EBS Functional Consultant - Immediate Joiners (Ahmedabad)
🏢 PressureJet Systems
📍 Ahmedabad