Job
Description
As an experienced BI Developer in Oracle Fusion Procurement, your role will involve: - Designing and developing custom BI Publisher (BIP) reports and OTBI subject areas specifically for Procurement processes like Requisitions, Purchase Orders, Approvals, and Attachments. - Ensuring that BI reports are optimized for Oracle Integration Cloud (OIC) consumption, supporting XML/CSV/JSON outputs. - Mapping and validating Procurement data structures, including headers, lines, distributions, and approver details. - Collaborating closely with the integration team to expose BI report outputs for OIC-based automation and workflows. - Developing a deep understanding of Fusion Procurement REST APIs to retrieve pending approval requests, requisition details, purchase orders, and attachments. - Working with business and functional teams to translate reporting requirements into scalable BI solutions. - Providing support for debugging and troubleshooting data issues across BI, OIC, and Procurement modules. Your skills and experience should include: - Strong proficiency in Oracle Fusion Procurement processes such as Requisitions, Purchase Orders, and Approvals. - Expertise in BI Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), and SQL for Oracle Fusion ERP. - In-depth knowledge of the Fusion Procurement data model, including key tables and fields. - Hands-on experience with Oracle Fusion Procurement REST APIs like /purchaseRequisitions, /recentRequisitions, /purchaseOrders, and /bpm/tasks. - Demonstrated ability to design reports optimized for OIC integration. - Solid understanding of Oracle Integration Cloud (OIC) architecture and the consumption of BI reports. - Proficiency in SQL, XML, and JSON for data extraction and transformation. - Experience working in an enterprise environment with multiple stakeholders from Procurement, IT, and Finance. - Familiarity with 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 thrive in a fast-paced transformation program.,
