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