Oracle EBS Techno-Functional Consultant

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

## Oracle EBS Techno-Functional ConsultantFull Job Details#### Job Description**Required Experience:** 5–6 Years## Job DescriptionOctans Digital is seeking an experienced **Oracle EBS Techno-Functional Consultant** with 5–6 years of hands-on experience in Oracle E-Business Suite (EBS) R12.2.x. The ideal candidate should have strong technical development skills and functional knowledge, particularly in Oracle PL/SQL and Oracle Financials.Job Search PlatformThe successful candidate will be responsible for analyzing business requirements, developing customized solutions, supporting Oracle EBS implementations, and ensuring seamless integration across financials, procurement, inventory, and order management modules.Applicants should have practical experience in developing reports, interfaces, and workflows using BI Publisher, Oracle Reports, and Oracle APEX. Knowledge of web technologies, including JavaScript, HTML5, CSS, and AJAX, along with integration technologies such as REST APIs, SOAP, JSON, and XML, is also required.The role involves system configuration, database performance optimization, application security, troubleshooting, and collaboration with business users and technical teams to deliver reliable and scalable enterprise solutions.## Key Responsibilities* Analyze business requirements and design effective Oracle EBS solutions. Compare Broadband* Develop and maintain PL/SQL packages, procedures, functions, and triggers.* Create, maintain, and optimize BI Publisher reports, Oracle Reports, and custom applications.* Implement integrations using REST APIs, SOAP web services, and database interfaces.* Develop web applications, dashboards, interactive reports, and forms using Oracle APEX.* Configure Oracle EBS modules, flexfields, value sets, concurrent programs, request groups, and responsibilities.* Troubleshoot and maintain RICEW components, including reports, interfaces, conversions, extensions, workflows, and APIs.* Optimize SQL queries and perform database performance tuning.* Collaborate with functional consultants, infrastructure teams, and vendors.* Support requirement gathering, technical documentation, unit testing, system integration testing, user acceptance testing, deployment, and production support.* Conduct root cause analysis and resolve application issues promptly.* Document technical solutions, system configurations, and business processes.* Monitor Oracle EBS developments and integration technologies to improve system performance.* Maintain application security and ensure compliance with organizational policies.## Required Skills* Oracle E-Business Suite (EBS) R12.2.x* Oracle PL/SQL and SQL Query Optimization* Oracle Financials* Oracle APEX* BI Publisher (XML Publisher)* Oracle Reports* Oracle Integration Cloud (OIC)* REST APIs and SOAP Web Services* JSON, XML, and AJAX* JavaScript, HTML5, and CSS* Database Performance Tuning* Oracle EBS Configuration and Security* RICEW Components Management* Concurrent Program Troubleshooting* Request Groups and Responsibilities Management* Business Requirements Gathering and Requirement Analysis* Technical and Functional Specifications Preparation* System Integration and Stakeholder Communication## Eligibility Criteria* 5–6 years of relevant professional experience.* Hands-on expertise in Oracle EBS R12.2.x.* Strong technical knowledge of Oracle PL/SQL and Oracle Financials.* Experience in Oracle EBS configuration, reporting, integrations, and troubleshooting.* Good communication and cross-functional coordination skills.**Note:** The original listing does not specify a formal educational qualification.Interested candidates should apply through the official careers portal before the closing date.