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.