Job Summary

Senior Oracle EBS technical developer to build, test and support the Romanian SAF-T (D406) extract from Oracle E-Business Suite, covering the monthly/quarterly General file, the annual Assets file, and the on-request Stocks file, through to a file that passes ANAFs DUK Integrator validator.

Job Details

- Role: Functional Consultant - Oracle EBS Apps Technical Lead

- Years of Exp: 7 - 10 Years

- Location: Hyderabad, Chennai, Bangalore

- Work Mode: Hybrid

- Availability: Immediate

Resumes can be directly shared with Saloni.

Essential Technical Skills

Oracle SQL (advanced)

- Analytic functions, complex joins across GL/AP/AR/FA/INV

- Native XML generation:

- Query tuning against high-volume transactional tables; explain plans, indexing strategy, partitioning awareness. SAF-T files routinely run to hundreds of MB, so performance is not a nice-to-have

PL/SQL (advanced)

- Packaged procedures registered as concurrent programs

- Bulk Collect, FORALL, ref cursors, pipelined functions

- Staging-table architecture (extract stage validate generate), restartability, error logging
- utl_file and large CLOB/file handling

BI Publisher / XML Publisher in EBS

- Data templates (SQL-driven XML data definitions, group hierarchies, lexical parameters) - this matters more than RTF layout skills here
- eText and XSL-FO templates; understanding when BIP is the wrong tool for a very large XML and a PL/SQL generator is better

- Scalable mode, XML output size limits, bursting, template registration via XML Publisher Administrator

EBS applications technical (AOL/FND)

- Concurrent programs, executables, value sets, request sets, profile options





- Multi-org / MOAC handling, ledger and legal entity setup

- Custom top / CEMLI standards, patching and instance refresh implications

EBS data model knowledge

- GL

- AP

- AR

- FA

- INV

- E-Business Tax

XML and schema work

- Reading and working directly against the ANAF XSD (SAF-T schema 2.0): namespaces, strict element sequencing, data types, cardinality

- Validating generated XML against the XSD outside EBS; interpreting validator errors

- XSLT practical for post-transformation

Typical Responsibilities

- Gap analysis between the ANAF schema and available EBS data; identifying where data simply isnt captured today

- Designing and building the extract: staging model, mapping tables, generation, validation

- Building maintainable mapping tables so finance can update account and tax code mappings without a code change

- Getting files through DUKIntegrator cleanly and resolving validator errors

- Performance tuning to fit the extract inside the month-end window

- SIT/UAT support, reconciliation to TB and VAT returns, documentation and handover

- Ongoing support against a hard monthly deadline (last calendar day of the month following the period)

Required Skills

- SQL/PLSQL Performance Tuning

- Oracle EBS Technical - Financials

- XML/XSLT

- Oracle EBS

- Oracle EBS BI Publisher

- Oracle PL/SQL

- Oracle SQL

- EBS Finance

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Principal Consultant - Oracle EBS Apps Technical Lead (Hyderabad)
🏢 Winfo Consulting
📍 Hyderabad