Oracle EBS Techno-Functional Consultant: PL/SQL & Interfaces

Khanewal; Punjab; On-site; PKR 1,500,000 - 2,100,000; Full time

Job summary

Octans Digital is seeking an experienced Oracle EBS Techno-Functional Consultant with 5–6 years of hands-on EBS R12.2.x experience. You will analyze business requirements, develop PL/SQL and BI Publisher reports, and implement integrations across financials, procurement, inventory, and order management.

The role involves configuring EBS modules, RICEW components, and ensuring reliable, scalable enterprise solutions. Collaboration with business users and technical teams is essential.

Qualifications

• 5–6 years of hands-on Oracle EBS EBS R12.2.x experience.
• Strong PL/SQL development and SQL optimization skills.
• Functional knowledge of Oracle Financials and integration points.
• Experience in BI Publisher, Oracle Reports, and Oracle APEX.
• Knowledge of REST, SOAP, JSON, XML, and web front-end tech.

Responsibilities

• Analyze business requirements and design Oracle EBS solutions.
• Develop and maintain PL/SQL packages, procedures, functions, and triggers.
• Create and optimize BI Publisher reports, Oracle Reports, and custom apps.
• Implement integrations using REST, SOAP web services, and DB interfaces.
• Develop dashboards and interactive reports using Oracle APEX.
• Configure EBS modules, flexfields, value sets, concurrent programs, responsibilities.
• Troubleshoot RICEW components: reports, interfaces, conversions, extensions, workflows, APIs.
• Collaborate with functional consultants, infra teams, and vendors.
• Support testing, deployment, and production support.
• Document technical solutions, configurations, and processes.

Job description

Octans Digital is seeking an experienced Oracle EBS Techno-Functional Consultant with 5–6 years of hands-on EBS R12.2.x experience. You will analyze business requirements, develop PL/SQL and BI Publisher reports, and implement integrations across financials, procurement, inventory, and order management.

The role involves configuring EBS modules, RICEW components, and ensuring reliable, scalable enterprise solutions. Collaboration with business users and technical teams is essential.