Oracle SCM Techno Functional Consultant

We are seeking an experienced Techno-Functional Consultant specializing in Oracle Fusion Supply Chain Management (SCM) with exposure to Finance modules such as Accounts Payable (AP). The candidate will act as the key functional bridge between business stakeholders and technical teams, supporting data extraction from Oracle Fusion, loading into a staging layer, and helping downstream teams understand and consume the data effectively., ?? Functional Support & Business Engagement

• Work closely with business stakeholders to understand and interpret requirements through a business lens, ensuring clarity before passing to technical teams.
• Provide functional expertise across core Oracle Fusion modules:
• Inventory Management
• Procurement
• Order Management (OM)
• Accounts Payable (AP)
• Help business users articulate their data needs clearly and bridge the gap between what the business asks for and what the data can deliver.
• Act as a go-to functional resource for day-to-day queries from both business and technical teams.

?? Data Extraction & Technical Collaboration

• Support the technical team in navigating Oracle Fusion data structures across SCM and Finance modules, including key tables, views, and data entities such as:
• Inventory transactions, on-hand balances, item master
• Purchase Orders, Receipts, Supplier data
• Sales Orders, Order Lines, Fulfilment data
• AP Invoices, Payments, Supplier Invoices
• Guide the technical team on the most appropriate Oracle Fusion data extraction methods, including:
• OTBI (Oracle Transactional Business Intelligence)
• BIP (Business Intelligence Publisher)
• REST APIs
• FTP-based extracts
• Validate extracted data against Oracle Fusion source to ensure accuracy and completeness before loading into the staging layer.
• Support and review the loading of data into the staging layer, ensuring the data is correctly mapped and traceable back to the source.

?? Data Consumption & Modelling Guidance

• Help analytics and data teams understand the functional meaning of extracted data entities and how they relate to each other across SCM and Finance modules.
• Provide functional context to support data modelling decisions, such as:
• How Inventory transactions relate to financial postings
• How Purchase Orders link to Receipts and AP Invoices (Procure-to-Pay flow)
• How Sales Orders connect to Fulfilment and Revenue (Order-to-Cash flow)
• Advise on how data can be consumed without going into detailed technical design.
• Support teams in understanding key identifiers, hierarchies, and reference data (e.g., Item Categories, Inventory Organizations, Business Units, Cost Centers).

?? Cross-Team Enablement

• Be available to answer functional questions from BI, analytics, and data teams regarding Oracle Fusion SCM and Finance data.
• Conduct informal knowledge-sharing to improve team understanding of module-specific data and business processes.
• Support data validation exercises by providing functional context on expected data behaviour and business rules.

Skill Area

Requirements

Oracle Fusion SCM

Strong hands-on functional knowledge in Inventory, Procurement, Order Management

Oracle Fusion Finance

Working knowledge of Accounts Payable (AP) module and its data

Data Extraction

Familiarity with Oracle Fusion extraction methods - OTBI, BIP, REST APIs

Technical Acumen

Ability to work alongside technical teams, understand SQL queries, data mappings and staging concepts

Business Engagement

Proven ability to listen to business requirements and translate them into clear functional and data needs

Cross-functional Collaboration

Experience working across multiple teams including technical, analytics, and business

Nice-to-Have Skills

• Exposure to Procure-to-Pay (P2P) and Order-to-Cash (O2C) end-to-end processes
• Familiarity with data warehousing or staging layer concepts
• Experience with reporting tools such as Oracle Analytics Cloud (OAC), Power BI, or Tableau
• Knowledge of Oracle Fusion data model and standard reporting subject areas

Soft Skills

• Strong communication skills with the ability to explain complex functional concepts in simple terms
• Comfortable working in a collaborative, multi-team environment
• Pragmatic and solution-oriented approach
• Ability to prioritize and manage multiple requests from different teams simultaneously
• Proactive in flagging data or functional gaps to the relevant stakeholders”