ERP SCM Technical

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.