Oracle EBS Techno-Functional Consultant
Posted Updated
Description
We are looking for an experienced Oracle EBS Techno-Functional Consultant specializing in Oracle Projects (Project Costing, Project Billing, and Project Management), to support and maintain enterprise Oracle EBS applications. The ideal candidate will have a strong blend of functional expertise in project accounting processes and technical skills to independently troubleshoot, customize, and enhance the application, ensuring smooth day-to-day operations in a production support environment.
Key Responsibilities
Functional
- Provide L2/L3 production support for Oracle Projects (PA) module, covering Project Costing (PC), Project Billing (PB), and Project Management (PM) processes.
- Act as the primary point of contact for Project Managers, Finance, and Delivery teams, leading root-cause analysis and resolution for complex incidents.
- Configure and maintain PA setups: Project Types, Project Templates, Task Structures, Costing/Billing Rules, Burden/Overhead structures, Rate Schedules, Agreements, and Funding.
- Support integration points between Oracle Projects and other modules (GL, AP, AR, HR/OTL, PO, FA) for cost/labor/expenditure flows.
- Troubleshoot issues related to Cost Distribution, Cross-Charge/Inter-company billing, Revenue Recognition, Invoice Generation, and Project-GL/AR interfaces.
- Support project close, period close, and cross-period adjustment processes; resolve exceptions in cost/revenue/billing distribution.
- Manage transaction import failures (Cost Collector, Transaction Import), unprocessed transactions, and expenditure batch errors.
- Prepare functional design documents (FDD/MD-050) and test cases (test scripts, UAT support) for enhancements/patches.
- Ensure compliance with SLA/OLA for ticket resolution (incidents, service requests, minor enhancements).
- Support statutory/regulatory and client-specific billing/revenue recognition compliance requirements.
Technical
- Analyze and resolve complex issues related to interfaces (Transaction Import, Cost Collector, Labor/Usage/Expense Report Interfaces), conversions, and custom reports impacting Projects.
- Develop/debug PL/SQL procedures, packages, and triggers for PA-related customizations and data fixes.
- Work on Oracle Workflow (Project/Budget/Invoice approval workflows), Oracle Alerts, and Application Object Library (AOL) objects.
- Support and troubleshoot BI Publisher (BIP)/XML Publisher reports, project status reports, billing/invoice formats, and custom PA reports.
- Perform back-end data fixes/updates (with due approvals) for stuck transactions, failed cost distributions, or interface errors.
- Coordinate with DBA/Infra teams for patches, cloning, and environment refresh activities impacting Projects module.
- Prepare and maintain Technical Design Documents (TDD/MD-070) for custom objects and interfaces.
- Mentor junior consultants on technical troubleshooting and PA functional processes.
Support Process & Governance
- Log, track, and manage tickets via ITSM tools (Zendesk, Remedy, JIRA, etc.).
- Participate in on-call/rotational support.
- Adhere to and help enforce change management (CR) and incident management processes.
- Provide RCA (Root Cause Analysis) documentation for recurring/critical issues.
- Drive knowledge base (KB) documentation and continuous process improvement initiatives.
Skills
Sign in to read and join the discussion.