Fusion Procurement BI/OIC Developer

Hello everyone,

WE ARE HIRING!! Below is the job description- Kindly share the relevant resumes.

We are seeking a skilled Fusion Procurement BI/OIC Developer to design, develop, and maintain Oracle Fusion Procurement BI reports that can be seamlessly consumed by Oracle Integration Cloud (OIC). The ideal candidate will have a strong understanding of Fusion Procurement tables, fields, and data models, as well as practical expertise in Fusion Procurement REST APIs to support integration scenarios.

Key Responsibilities:

• Design and develop custom BI Publisher (BIP) reports and OTBI subject areas for Procurement (Requisitions, Purchase Orders, Approvals, Attachments, etc.).
• Ensure BI reports are optimized for OIC consumption (XML/CSV/JSON outputs).
• Map and validate Procurement data structures including headers, lines, distributions, and approver details.
• Work closely with the integration team to expose BI report outputs for OIC-based automation and workflows.
• Develop a strong understanding of Fusion Procurement REST APIs to retrieve pending approval requests, requisition details, purchase orders, and attachments.
• Collaborate with business and functional teams to translate reporting requirements into scalable BI solutions.
• Support debugging and troubleshooting of data issues across BI, OIC, and Procurement modules.

Required Skills & Experience

• Strong experience with Oracle Fusion Procurement (Requisitions, Purchase Orders, Approvals).
• Expertise in BI Publisher (BIP), OTBI, and SQL for Oracle Fusion ERP.
• In-depth knowledge of Fusion Procurement data model (key tables and fields).
• Hands-on experience with Oracle Fusion Procurement REST APIs (e.g., /purchaseRequisitions, /recentRequisitions, /purchaseOrders, /bpm/tasks).
• Proven ability to design reports optimized for OIC integration.
• Solid understanding of Oracle Integration Cloud (OIC) architecture and how BI reports are consumed.
• Strong SQL and XML/JSON skills for data extraction and transformation.
• Experience working in an enterprise environment with multiple stakeholders (Procurement, IT, Finance).
• Knowledge of Fusion BPM workflows related to Procurement approvals.
• Experience with security and role-based access for Fusion BI reports.
• Strong problem-solving skills and ability to work in a fast-paced transformation program.

Thanks,

Rachana KH