Modernizing Oracle EBS Inventory, Sourcing, and Financials with Agentic AI¶

Decoupled Multi-Agent System (A2A) integrating Google Cloud GenAI capabilities with Oracle E-Business Suite (EBS) database and application context using oracle/skills and gemini-cli-extensions/oracle.

Architecture overview¶

graph TD
    Client[User / Gemini Chat Client] --> A2A[A2A Discovery Server /src/a2a]
    A2A --> Inv[Inventory Agent /src/agents/inventory_agent.py]
    A2A --> Fin[Financial Agent /src/agents/financial_agent.py]
    A2A --> Sup[Supplier Agent /src/agents/supplier_agent.py]

    Inv --> OracleSkills[Oracle Skills NL-to-SQL Engine]
    Fin --> OracleSkills
    Sup --> OracleSkills

    OracleSkills --> MCP[EBS DB Client /src/mcp/ebs_db_client.py]
    IAP[Google Cloud IAP TCP Tunnel localhost:1521] --> EBS[(Oracle EBS Database)]
    MCP --> IAP

    Sup --> ExternalCatalog[Vendor Catalog API]

System components¶

• A2A Discovery Server (src/a2a/a2a_server.py): Central Agent-to-Agent (A2A) gateway providing cognitive routing, validation, and synthesis.
• MCP Database & Tool Server (src/mcp/mcp_server.py): Model Context Protocol (MCP) server exposing consolidated tool endpoints:
  • /check-stock: Evaluates on-hand inventory levels against thresholds.
  • /get-item-suppliers: Retrieves approved vendor sourcing for an item.
  • /supplier-items: Queries items supplied by a vendor from PO history (PO_HEADERS_ALL, PO_LINES_ALL) and inventory (MTL_SYSTEM_ITEMS_B).
  • /invoice-status: Inspects AP invoice approvals and payment schedules.
  • /calculate-dso: Computes Days Sales Outstanding receivables metrics.
  • /negotiate: Executes multi-turn PO restock price and terms negotiations.
  • /execute: Dispatches general SQL procedures within Oracle EBS context.
• Gemini CLI Extension Engine (src/gemini_cli_extensions/oracle.py): Manages database channels and execution over Oracle EBS endpoints.
• Oracle Skills NL-to-SQL Engine (src/oracle/skills.py): Translates natural language prompts into validated SQL targeting EBS base tables.
• Inventory Agent (src/agents/inventory_agent.py): Queries item availability, on-hand balances, and organization catalogs.
• Financial Agent (src/agents/financial_agent.py): Inspects AP invoices, payment schedules, and DSO liquidity metrics.
• Supplier Agent (src/agents/supplier_agent.py): Drives PO negotiations and vendor item catalog lookups.
• Terraform Infrastructure (terraform/): Automated provisioning for Google Cloud Run microservices, Direct VPC Egress, and Secret Manager.

Environment variables reference¶

Deployment options¶

Method A: Local development and IAP tunneling¶

Establish Identity-Aware Proxy (IAP) TCP tunnels:

# Terminal 1: Oracle Database Listener Tunnel (Port 1521)
gcloud compute start-iap-tunnel oracle-vision 1521 \
  --project=YOUR_PROJECT_ID \
  --zone=YOUR_ZONE \
  --local-host-port=localhost:1521

# Terminal 2: Start local worker agents
source .venv/bin/activate
uvicorn src.a2a.a2a_server:app --port 8080 --reload
uvicorn src.agents.inventory_agent:app --port 8001 --reload
uvicorn src.agents.financial_agent:app --port 8002 --reload
uvicorn src.agents.supplier_agent:app --port 8003 --reload
uvicorn src.mcp.mcp_server:app --port 8000 --reload

Method B: Google Cloud Run deployment¶

Deploy stack using the automated scripts:

# Deploy all microservices and generate Vertex AI assets
./scripts/deploy_stack.sh

# Tear down infrastructure
./scripts/destroy_stack.sh

Configuring agent in Gemini Enterprise console¶

1. Navigate to Gemini Enterprise Apps in Google Cloud Console.
2. Click Create App, enter application details, and select region.
3. Click Agents ➡️ + New Agent ➡️ Import A2A Agent Card.
4. Paste the contents of terraform/a2a_agent_card.json (Display Name: Oracle EBS Autonomous Assistant).
5. Preview and interact with the agent under Agents from your organization.

Accessing the agent across your organization¶

Once published, team members across your organization can interact with the agent without accessing Google Cloud Console:

1. Open Gemini Enterprise in your web browser.
2. Select Agents in the navigation panel.
3. Under Agents from your organization, select Oracle EBS Autonomous Assistant to start a session.

Recommended prompts for testing¶

• Operating Organizations: "Give me the list of organizations." / "Show top 10 orgs."
• Inventory Items by Org Code or ID:
  • "List items for Organization code AD1."
  • "Give me the list of items for Org code PR4."
  • "List items for organization V1."
  • "Show inventory items in organization 204."
• Inventory Stock & Balance:
  • "Check stock for item AS54888 in Organization code V1."
  • "Check stock for item AS54888 in Organization 204."
• Approved Suppliers: "Show me all approved suppliers." / "List suppliers for item AS54888."
• Supplier Items Catalog (MCP Action): "Give me the items for supplier 515."
• AP Invoices: "Show recent AP invoices." / "Inspect status for invoice INV-2024-001."
• Financial Metrics: "Calculate DSO metrics for the current quarter."
• Procurement Negotiations: "Negotiate restock for 500 units of item AS54888 with Acme."

Direct API verification examples¶

1. Check inventory stock threshold (by Org Code or ID)¶

curl -X POST http://localhost:8001/check-stock \
  -H "Content-Type: application/json" \
  -d '{
    "item_code": "AS54888",
    "organization_code": "V1",
    "min_threshold": 10.0
  }'

2. Query approved suppliers for an inventory item¶

curl -X POST http://localhost:8001/item-suppliers \
  -H "Content-Type: application/json" \
  -d '{
    "item_code": "AS54888"
  }'

3. Inspect AP invoice status¶

curl -X POST http://localhost:8002/invoice-status \
  -H "Content-Type: application/json" \
  -d '{
    "invoice_number": "INV-2024-001",
    "vendor_id": 501
  }'

4. Calculate Days Sales Outstanding (DSO)¶

Calculate DSO by querying live Oracle EBS Accounts Receivable tables automatically, or by supplying custom metrics:

Automated live database evaluation:

curl -X POST http://localhost:8002/calculate-dso \
  -H "Content-Type: application/json" \
  -d '{
    "period_days": 90
  }'

Custom metrics evaluation:

curl -X POST http://localhost:8002/calculate-dso \
  -H "Content-Type: application/json" \
  -d '{
    "period_days": 90,
    "total_accounts_receivable": 450000.0,
    "total_credit_sales": 1000000.0
  }'

5. Negotiate supplier purchase order pricing¶

curl -X POST http://localhost:8003/negotiate \
  -H "Content-Type: application/json" \
  -d '{
    "supplier_id": 301,
    "item_id": "AS54888",
    "target_quantity": 150.0,
    "target_unit_price": 45.00,
    "proposed_payment_terms": "Net 30"
  }'

6. Query items supplied by vendor (Worker & MCP Tool Action)¶

# Via Supplier Agent (port 8003)
curl -X POST http://localhost:8003/supplier-items \
  -H "Content-Type: application/json" \
  -d '{
    "supplier_id": 515,
    "limit": 10
  }'

# Via MCP Database & Tool Server (port 8000)
curl -X POST http://localhost:8000/supplier-items \
  -H "Content-Type: application/json" \
  -d '{
    "supplier_id": 515,
    "limit": 10
  }'

Running automated tests¶

Run test suite verification against the integration suite:

./scripts/run_tests.sh