Role Overview
We are looking for an Oracle ERP Technical Integration Consultant to develop and customize integrations between Oracle ERP environments and a third-party e-Invoicing platform.
The role primarily involves extracting relevant invoice and financial information, implementing ERP-specific interfaces, transforming ERP data into the required format, and supporting end-to-end integration, including invoice status updates and error handling.
The consultant should be capable of working with Oracle Fusion Cloud ERP and/or Oracle E-Business Suite, depending on customer environments.
Key Responsibilities
- Analyze existing Oracle ERP implementation, configurations, data structures, and available integration interfaces.
- Identify and extract relevant financial information, including customer invoices, tax details, credit notes, debit notes, and associated accounting data.
- Develop and customize integrations using Oracle Fusion Cloud REST/SOAP APIs or Oracle EBS-specific integration methods.
- Develop PL/SQL packages, procedures, and interface components for Oracle EBS environments where applicable.
- Work with Oracle standard APIs, supported interface tables, concurrent programs, and established integration frameworks.
- Map and transform Oracle ERP data into the required e-Invoicing platform data structure.
- Implement integration workflows for invoice submission, acknowledgements, processing status updates, and error responses.
- Develop mechanisms for logging, exception management, retry processing, and reconciliation.
- Work with Oracle Integration Cloud (OIC) when required, without making middleware a mandatory dependency.
- Coordinate with Oracle Finance functional consultants to validate invoice lifecycle, taxation, accounting, and reconciliation requirements.
- Assist with integration security, authentication, API connectivity, troubleshooting, testing, and deployment.
- Produce technical specifications, mapping documents, testing evidence, and handover documentation.
Required Technical Skills
- Strong technical experience in Oracle Fusion Cloud ERP and/or Oracle EBS.
- Experience integrating Oracle Financials, Accounts Receivable, and billing-related processes.
- Proficiency in Oracle REST/SOAP APIs and Oracle ERP integration techniques.
- Good understanding of SQL, PL/SQL, and Oracle EBS integration development where applicable.
- Understanding of Oracle Fusion integration capabilities, including scheduled data extracts and supported data import/export mechanisms.
- Experience handling JSON, XML, CSV, and data transformation.
- Knowledge of authentication, certificates, API security, and connectivity configuration.
- Hands-on experience with integration debugging, logging, validation, and error handling.
- Ability to work independently with functional and infrastructure teams.
Preferred Qualifications
- Experience with e-Invoicing, digital tax reporting, or compliance integration.
- Exposure to Oracle Integration Cloud (OIC).
- Experience with Oracle BI Publisher extracts and relevant Fusion ERP reporting interfaces.
- Familiarity with GCC e-Invoicing regulations.
- Experience integrating third-party financial or compliance platforms.
Expected Deliverables
- Oracle-specific integration design and technical specifications.
- Required Oracle integration interfaces, scripts, and configurations.
- Invoice and tax data mapping and transformation.
- Tested end-to-end integration with the e-Invoicing platform.
- Invoice processing status and error-handling integration.
- Deployment, troubleshooting, and knowledge-transfer documentation.
Experience: 4–7 years
Engagement Type: Project-Based / Contract, with potential for long-term engagement
Technology: Oracle Fusion Cloud ERP, Oracle E-Business Suite (EBS), PL/SQL, REST/SOAP APIs
Engagement: Project based
Timeline: 1 to 4 months
Visa: Will be provided
Accommodation: Will be provided
Ticket: 1 return ticket will be provided based on the project timeline