> This page is for Agent Handler. > For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://docs.merge.dev/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.merge.dev/_mcp/server. # Oracle SCM **Authentication:** OAuth or basic authentication. See [Magic Link](/merge-agent-handler/features/magic-link) for the runtime auth flow, or [Application credentials](/merge-agent-handler/admin-setup/add-oauth-credentials) to bring your own OAuth app. ## Sample use cases * List purchase orders pending approval longer than 5 days. * Pull inventory levels at the LA warehouse for SKUs below reorder point. * Find shipments delayed more than 3 days from their expected arrival. ## Available Tools #### list\_draft\_purchase\_orders List draft purchase orders from Oracle SCM. Returns paginated list of POs in draft/incomplete status. Use limit/offse... #### get\_draft\_purchase\_order Get a single draft purchase order by POHeaderId. Returns full details including supplier, lines, and amounts. Use lis... #### create\_draft\_purchase\_order Create a new draft purchase order. Requires procurement\_bu and supplier name. The PO is created in INCOMPLETE status ... #### update\_draft\_purchase\_order Update a draft purchase order. Only POs in INCOMPLETE status can be updated. Use list\_draft\_purchase\_orders to find v... #### delete\_draft\_purchase\_order Delete a draft purchase order permanently. Only POs in INCOMPLETE status can be deleted. This action cannot be undone. #### submit\_draft\_purchase\_order Submit a draft purchase order for approval. The PO must be in INCOMPLETE status with all required fields populated. U... #### list\_inventory\_organizations List inventory organizations from Oracle SCM. Returns paginated list with organization code, name, status, and locati... #### get\_inventory\_organization Get a single inventory organization by OrganizationId. Returns full details including code, name, status, location, a... #### create\_inventory\_organization Create a new inventory organization in Oracle SCM. Requires organization\_code and organization\_name. Use list\_invento... #### update\_inventory\_organization Update an existing inventory organization. Use list\_inventory\_organizations to find valid IDs. #### list\_purchase\_orders List purchase orders from Oracle SCM. Returns paginated list with order number, status, supplier, amounts, and dates.... #### get\_purchase\_order Get a single purchase order by POHeaderId. Returns full PO details including lines summary, supplier, amounts, and st... #### get\_purchase\_order\_lines Get line items for a purchase order. Returns item details, quantities, prices, and status for each line. Use list\_pur... #### close\_purchase\_order Close a purchase order. Only OPEN purchase orders can be closed. Use list\_purchase\_orders to find open POs. #### cancel\_purchase\_order Cancel a purchase order. This action cannot be undone. Use list\_purchase\_orders to verify the PO status before cancel... #### list\_sales\_orders List sales orders from Oracle SCM Order Hub. Returns paginated list with order number, status, customer, and amounts.... #### get\_sales\_order Get a single sales order by OrderKey (HeaderId or SourceSystem:TransactionId). Returns full order details including l... #### create\_sales\_order Create a new sales order in Oracle SCM Order Hub. Requires source\_transaction\_system and source\_transaction\_id. Optio... #### update\_sales\_order Update a sales order. Use list\_sales\_orders to find the OrderKey. Only editable orders can be updated (check IsHeader... #### delete\_sales\_order Delete a sales order permanently. This action cannot be undone. Use list\_sales\_orders to verify the order before dele... #### list\_suppliers List suppliers from Oracle SCM. Returns paginated list with supplier name, number, status, and type. Use limit/offset... #### get\_supplier Get a single supplier by SupplierId. Returns full details including name, number, status, DUNS number, and contact in... #### list\_transfer\_orders List transfer orders from Oracle SCM. Returns paginated list with header number, status, business unit, and total pri... #### get\_transfer\_order Get a single transfer order by HeaderId. Returns full details including lines, status, and business unit. Use list\_tr... #### update\_transfer\_order Update a transfer order header fields (e.g. MessageText). Most transfer order mutations happen at the line level. Use... #### list\_work\_orders List manufacturing work orders from Oracle SCM. Returns paginated list with work order number, status, item, and quan... #### get\_work\_order Get a single work order by WorkOrderId. Returns full details including operations, materials, and status. Use list\_wo... #### create\_work\_order Create a new manufacturing work order. Requires organization\_code, work\_order\_type, and item\_number. Use list\_invento... #### update\_work\_order Update a manufacturing work order. Use list\_work\_orders to find valid IDs.