Oracle BI Publisher Reports Developer

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.


• Strong 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.

2. 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.

3. 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.

4. 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.

5. 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.

6. 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.

7. 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.