Job Summary We are looking for an experienced Oracle BI Publisher Reports Developer / PL/SQL Engineer with strong expertise in Oracle Fusion Cloud ERP, Oracle E-Business Suite R12, BI Publisher, OTBI, XML Publisher, and Oracle PL/SQL. The candidate will be responsible for designing, developing, optimizing, and supporting enterprise reporting solutions across GL, AP, AR, Procurement, and other Oracle ERP modules. Must-Have Skills Strong experience in Oracle Fusion Cloud ERP reporting, including OTBI, BI Publisher, and reporting security such as roles and data access sets.

Hands-on experience with Oracle E-Business Suite R12 reporting, preferably using BI Publisher/XML Publisher.

Robust knowledge of Oracle PL/SQL, XML Publisher, and BI Publisher.

Ability to design and develop XML Publisher and BI Publisher templates.

Experience working with functional teams to gather requirements and deliver technical solutions for GL, AP, and AR.

Strong SQL skills with experience in query development, optimization, and performance tuning.

Experience developing and maintaining PL/SQL packages, procedures, functions, and triggers, including packages supporting Oracle Integration Cloud interfaces.

Strong understanding of Oracle GL, AP, and AR tables and data structures.

Experience implementing data validation, error handling, data integrity, and performance tuning in PL/SQL solutions.

Ability to prepare technical documentation and provide production support for reports and database objects.

Excellent communication and stakeholder management skills.

Key Responsibilities 1.

Oracle

Fusion & EBS Reporting Design, develop, enhance, and optimize reports using Oracle Fusion OTBI and BI Publisher.

Work with Fusion Analytics Warehouse (FAW) where applicable.

Develop reporting solutions across Oracle Fusion ERP modules including GL,



AP, AR, Procurement, and related modules.

Support reporting requirements across both Oracle Fusion Cloud ERP and Oracle EBS R12 environments.

BI Publisher / XML Publisher

Develop pixel-perfect management, operational, financial, and regulatory reports using BI Publisher.

Design and maintain BI Publisher data models, templates, layouts, bursting, scheduling, and report delivery mechanisms.

Develop and maintain XML Publisher templates and reports for Oracle EBS R12.

Manage report catalogs, folders, permissions, and security.

OTBI & Analytics

Develop ad-hoc analytics and operational reports using OTBI.

Work with relevant OTBI subject areas and reporting structures.

Create and maintain reporting solutions aligned with business requirements.

Perform data analysis and reconciliation across multiple ERP modules.

SQL & PL/SQL Development

Develop complex SQL queries, joins, views, and data extraction logic for reporting.

Optimize queries for high-performance reporting.

Develop and maintain PL/SQL packages, procedures, functions, triggers, and supporting database objects.

Support PL/SQL packages used for Oracle Integration Cloud (OIC) interfaces.

Implement robust exception handling, validation, logging, and data integrity controls.

Cross-Platform Data & Reconciliation

Extract and reconcile data between Oracle Fusion Cloud ERP and legacy Oracle EBS R12.





Investigate and resolve data discrepancies across GL, AP, AR, Procurement, and related modules.

Ensure accurate and consistent reporting across different Oracle platforms.

Functional Collaboration

Work closely with Finance, Accounting, Procurement, and other functional teams to understand reporting requirements.

Translate business requirements into scalable technical reporting solutions.

Participate in requirement gathering, technical design, development, testing, deployment, and production support.

Production Support & Documentation

Troubleshoot report failures, data issues, performance problems, and production incidents.

Perform root-cause analysis and implement permanent fixes.

Maintain technical specifications, report documentation, data mappings, and support documentation.

Ensure reports and database objects meet performance, security, and data-quality standards.

Preferred Skills Experience with Oracle Fusion Financials reporting.

Strong understanding of GL, AP, AR, and Procurement business processes.

Experience with Fusion reporting security and data access.

Knowledge of FAW is an advantage.

Experience with Oracle Integration Cloud (OIC) interfaces is preferred.

Experience in both Oracle Fusion Cloud and EBS R12 environments is highly desirable.

Candidate

Profile 5+ years of relevant experience in Oracle reporting and PL/SQL development.

Strong hands-on experience with BI Publisher + PL/SQL.

Good understanding of Oracle ERP financial modules and underlying tables.

Strong analytical and problem-solving skills.

Excellent verbal and written communication skills.

Ability to work independently and collaborate effectively with functional and technical stakeholders.

Skills: reporting,bi publisher,pl/sql,oracle

📌 Oracle BI Publisher Reports Developer (Hyderabad)
🏢 Zorba AI
📍 Hyderabad