Oracle Fusion MCP server

Overview

This tool pack gives an agent access to Oracle Fusion Cloud Applications, covering HCM for workers, absences, and time cards; SCM and ERP for purchase orders, requisitions, invoices, payments, GL journals, inventory, and sales orders; and the BPM approvals inbox for reviewing, approving, and rejecting workflow tasks. All tools authenticate as the named user, keeping access secure and auditable.

For setup instructions, see SnapLogic MCP Server quickstart.

Example Prompts

• Approve task 12345
• Approve the requisition approval in my inbox with the note 'budget confirmed'
• Go ahead and approve that expense report task
• Approve all three of the invoice tasks you just listed
• File an expense report for my trip to Munich
• Create an expense claim for person 100024 with a 240 EUR hotel line
• Submit expenses for the customer dinner last Thursday
• Raise an expense report in GBP for the London conference
• Raise a requisition for 5 laptops for the US business unit
• Create a purchase requisition for office chairs, description 'Q3 office refresh'

Tools

Set up the MCP Server tools

1. Download oracle-fusion_tools.zip.
2. In SnapLogic Designer, open the target project space (or create one), then choose Import Project / Import Pipelines and select the downloaded oracle-fusion_tools.zip. Designer unpacks each pipeline into the project.
3. Attach the required account to the connectivity snaps (see Connection Setup).
4. Expose the project as an MCP server — each pipeline becomes a tool named after its label. New to this? Start with the MCP quickstart, then use the MCP Server Pipeline Builder to generate the server from the imported pipelines.

Configure account

Attach an API Suite account (OAuth 2.0 or Bearer token) to the HTTP Client snap in Designer after import.

These pipelines ship without credentials by design — attach a valid account in Designer before the tools will execute.

See the SnapLogic account documentation for this connector: API Suite Account Configuration.

OracleFusionApproveTask

Approves a BPM workflow task by ID, with an optional comment. Use OracleFusionListApprovals first to find the task ID, then call this tool to record the approval.

* Required parameter.

Try asking:

• Approve task 12345
• Approve the requisition approval in my inbox with the note 'budget confirmed'
• Go ahead and approve that expense report task
• Approve all three of the invoice tasks you just listed

OracleFusionAuth

Authenticates to Oracle Fusion and obtains an access token for a named user. Other tools in this pack use the resulting token to call the Fusion APIs on behalf of that user.

OracleFusionCreateExpenseReport

Creates an expense report in Oracle Fusion for a named person and business unit, with a purpose, currency, and expense lines. Use it when a user wants to file expenses.

* Required parameter.

Try asking:

• File an expense report for my trip to Munich
• Create an expense claim for person 100024 with a 240 EUR hotel line
• Submit expenses for the customer dinner last Thursday
• Raise an expense report in GBP for the London conference

OracleFusionCreateRequisition

Creates a purchase requisition in Oracle Fusion with a description, business unit, and line items. Use it when the user wants to request a purchase.

* Required parameter.

Try asking:

• Raise a requisition for 5 laptops for the US business unit
• Create a purchase requisition for office chairs, description 'Q3 office refresh'
• Submit a requisition for 200 licences of the analytics tool
• Request a new monitor through procurement for the London BU

OracleFusionGetAbsences

Lists Oracle HCM absence records that overlap a date window, optionally filtered to one person. Use it for time-off checks, coverage planning, or to see who was away in a given period.

* Required parameter.

Try asking:

• What time off does person 100024 have booked between 1 July and 31 August?
• Show me all absences in the company for next month
• Was Jane on leave during the week of 14 April?
• List the 20 most recent absences starting this quarter

OracleFusionGetDirectReports

Lists the workers who report directly to a given manager, identified by person number. Use it to answer team-composition questions or to fan out per-employee queries across a manager's team.

* Required parameter.

Try asking:

• Who reports to person number 100024?
• Show me Jane's direct reports
• How many people are on this manager's team?
• List the first 10 direct reports for manager 100311

OracleFusionGetExpenseReports

Lists Oracle Fusion expense reports filtered by status, person, and business unit. Use it to see what a person has claimed or to review reports awaiting approval.

* Required parameter.

Try asking:

• What expense reports has person 100024 submitted?
• Show me all submitted expense claims for the US business unit
• Which expense reports are still awaiting approval?
• Pull my most recent expense reports

OracleFusionGetGLBalances

Reads Oracle Fusion ledger balances for a specified ledger and accounting period, optionally narrowed by chart-of-accounts segments. Use it for period-close balance checks and account-level roll-ups.

* Required parameter.

Try asking:

• What's the balance in the US Primary Ledger for Jun-26?
• Show me account 4000 balances for last period
• Pull ledger balances for the UK ledger, cost centre 200, in May-26
• Give me the Jun-26 balances for our primary ledger

OracleFusionGetGLJournals

Lists Oracle Fusion general-ledger journals by status and accounting period, with journal lines included. Use it to inspect what was posted in a period or to pull line detail for a close or audit.

* Required parameter.

Try asking:

• Show me the journals posted in Jun-26
• What unposted journals do we have?
• Pull the posted journals for last month with their lines
• List the 25 most recent posted journals

OracleFusionGetInventoryBalance

Checks on-hand inventory balance for a specific item in a specific inventory organization. Use it to answer availability questions before promising a ship date.

* Required parameter.

Try asking:

• How much of item AS54888 do we have in the Seattle warehouse?
• Check stock for part number 1004567 in org M1
• Do we have any of this item on hand in the Dublin org?
• What's the on-hand balance for AS54888 in M2?

OracleFusionGetPO

Fetches a purchase order by order number, with its lines included. Use it when the user asks about a specific PO; for deeper line detail, follow up with OracleFusionGetPOLines.

* Required parameter.

Try asking:

• Show me purchase order PO-100234
• What's on PO 5500123?
• Pull up that purchase order and its lines
• Look up order number 1004567 in procurement

OracleFusionGetPOLines

Lists the lines of a purchase order, addressed by the PO header ID. Use it when you need to page through line detail or when a PO has more lines than the header call returns.

* Required parameter.

Try asking:

• Show me the lines on purchase order header 300000123456
• What items are on that PO?
• List the next 25 lines of this purchase order
• Break down that purchase order line by line

OracleFusionGetPayments

Retrieves Oracle Fusion payment records by payment number or payee name, optionally filtered by status. Use it to confirm whether a supplier was paid or to look up a specific payment.

* Required parameter.

Try asking:

• Was Acme Industrial paid last month?
• Look up payment number 4501234
• Show me the most recent payments to Contoso
• List all payments still in a pending status

OracleFusionGetReceivablesInvoices

Lists customer invoices from Oracle Fusion Receivables, filtered by status and optionally by customer name, sorted by due date. Use it for collections questions such as who owes what and what is coming due.

* Required parameter.

Try asking:

• What invoices are open for Globex?
• Show me our open receivables sorted by due date
• Which customer invoices are due soonest?
• List the next 25 open AR invoices

OracleFusionGetRequisitions

Looks up purchase requisitions by number or by status, returning the most recent first. Use it to check the status of a specific requisition or to survey what is currently in a given state.

* Required parameter.

Try asking:

• What's the status of requisition REQ-10045?
• Show me all approved requisitions
• List requisitions still pending approval
• Pull the 10 most recent approved requisitions

OracleFusionGetSalesOrder

Fetches a sales order from Oracle Fusion Order Management by order number, with its lines included. Use it for order-status questions; pair it with OracleFusionGetShipments to track fulfilment.

* Required parameter.

Try asking:

• Show me sales order 50012345
• What's on customer order SO-99812?
• Pull up that sales order and its lines
• Look up order number 12345 in order management

OracleFusionGetShipments

Lists Oracle Fusion shipments and their lines, addressed by shipment number or source order number. Use it to trace fulfilment for a sales order or to inspect a named shipment.

* Required parameter.

Try asking:

• Has order 50012345 shipped yet?
• Show me shipment 1000456 and its lines
• What shipments went out against sales order SO-99812?
• Track the delivery for that customer order

OracleFusionGetTimeRecords

Retrieves recorded time cards for a named person over a date range. Use it to review what hours someone booked before approving, or to total time for a period.

* Required parameter.

Try asking:

• Show me person 100024's timesheet for the week of 7 July
• How many hours did Jane record in June?
• Pull the time records for employee 100311 between 1 and 15 August
• What did this person book last pay period?

OracleFusionListApprovals

Lists the BPM workflow tasks assigned to the caller, optionally filtered by status or keyword. Run this first in an approvals workflow to find the task IDs needed by the approve and reject tools.

* Required parameter.

Try asking:

• What's waiting for my approval?
• Show me my pending approval tasks
• Do I have any approvals mentioning 'laptop'?
• List my completed approval tasks
• Show the next 25 items in my approvals inbox

OracleFusionListPayablesInvoices

Lists supplier invoices from Oracle Fusion Payables, filtered by approval status, supplier, and business unit. Use it for payables triage, such as finding unapproved invoices or outstanding amounts for a supplier.

* Required parameter.

Try asking:

• What supplier invoices are waiting for approval?
• Show me all Acme invoices in payables
• List approved AP invoices for the US business unit
• How many invoices are still in INITIATED status?

OracleFusionLookupSupplier

Searches the Oracle Fusion supplier master by name prefix, with supplier sites included. Use it to look up a supplier's ID and status, or to check whether a vendor is on file.

* Required parameter.

Try asking:

• Is Acme Industrial set up as a supplier?
• Look up suppliers starting with 'Nordic'
• What's the supplier number for Contoso?
• Show me that vendor's supplier sites

OracleFusionLookupWorker

Looks up a worker in Oracle HCM by email, person number, or name prefix. Use it to resolve a name into a person number before calling other HCM tools that require one.

* Required parameter.

Try asking:

• Who is [email protected] in Fusion?
• Look up the worker record for person number 100024
• Find employees whose name starts with Anders
• Get me Priya Raman's person number

OracleFusionRejectTask

Rejects a BPM workflow task by ID, with an optional comment. Use it when the user declines a task that appears in their approvals inbox.

* Required parameter.

Try asking:

• Reject task 12345
• Turn down that expense report with the comment 'missing receipts'
• Reject the purchase requisition approval in my inbox
• Decline that task and say the budget isn't available

OracleFusionSubmitAbsence

Books a new absence in Oracle HCM for a named person, with absence type, dates, and an optional comment. Use it when a user wants to record or request leave.

* Required parameter.

Try asking:

• Book vacation for person 100024 from 12 to 16 August
• Submit sick leave for me for today
• Request two days of personal leave next Thursday and Friday with the comment 'family event'
• Log parental leave for person 100311 starting 1 September through 30 November

OracleFusionSubmitTimeRecord

Submits a time card for a named person in Oracle HCM, covering a date range and a set of time entries. Use it when a user wants to file a timesheet.

* Required parameter.

Try asking:

• Submit my timesheet for last week: 8 hours a day Monday to Friday
• File a time card for person 100024 covering 1-15 August
• Book 6 hours to project work on Tuesday and submit the week
• Record this week's hours for employee 100311 and submit them