Oracle

Supergood | Oracle API

Alex Klarfeld

Alex Klarfeld

— 6 min read
Supergood | Oracle API

Programmatically access Oracle Construction and Engineering project data, documents, mail workflows, and schedules with a stable REST API. Supergood builds and operates production-grade, unofficial Oracle integrations so your team can automate field and office workflows without heavy custom engineering.

Plain English: Oracle’s construction software—especially Aconex and Primavera—helps owners, contractors, and consultants manage collaboration, document control, RFIs/submittals, and detailed schedules across complex projects. An unofficial API lets you programmatically pull project lists, Aconex document registers and mail (RFIs, submittals, transmittals), Primavera WBS and activities, calendars and relationships—and push new records, updates, and attachments back in.

For a tech company integrating with Oracle, this means you can ingest real-time job data to power dashboards, automate RFI and submittal workflows from your product, sync activity progress to Primavera, and enrich your platform with the latest drawing revisions and correspondence. You can also trigger schedule updates from field observations, attach photos and documents, route mail to reviewers, and keep stakeholder systems (ERP, analytics, scheduling) in lockstep.

What is Oracle?

Oracle Construction and Engineering (https://www.oracle.com/construction-engineering/) is a suite of cloud tools for the built environment. Two core products are:

  • Aconex: Collaboration and document control with structured mail threads, transmittals, submittals, workflows, and a versioned document register.
  • Primavera (P6 and Primavera Cloud): Enterprise project planning and scheduling with EPS, WBS, activities, relationships, calendars, baselines, resources, and progress tracking.

Additional solutions often used alongside these include Unifier (cost control and business process workflows) and Textura (payment management), which many owners and GCs rely on for financial rigor and auditability.

Core product areas include:

  • Project Collaboration & Document Control (Aconex: mail, transmittals, submittals, workflows, document register)
  • Scheduling & Planning (Primavera: EPS/WBS, activities, relationships, calendars, baselines, resources)
  • Cost Control & Contract Management (Unifier: budgets, commitments, change orders, pay apps; Textura: subcontractor payments)

Common data entities:

  • Companies, Users, and Permissions
  • Projects (metadata, codes, dates, status)
  • Aconex Mail (RFIs, submittals, transmittals), Reviewers, Due Dates
  • Document Register (document numbers, titles, revisions, disciplines, statuses)
  • Workflows and Ball-in-Court
  • Primavera EPS/WBS, Activities, Relationships, Calendars, Resources, Baselines
  • (Optionally) Unifier Cost Structures: Budgets, Commitments, Change Orders, Payment Applications

The Oracle Integration Challenge

Construction teams rely on Aconex and Primavera daily, but turning portal-first workflows into API-driven automation is non-trivial:

  • Multi-product architecture: Aconex and Primavera have distinct data models, UIs, and entitlements that must be unified.
  • Enterprise security: SSO/MFA and granular role-based permissions complicate headless automation.
  • Workflow complexity: Aconex mail and reviews are sequence-driven and audit-heavy; Primavera schedules are dependency-rich.
  • Large artifacts: High-volume documents and attachments require resilient, chunked upload/download and checksum validation.
  • Auditability: Financials and approvals (where present) demand traceable, compliant change histories.

How Supergood Creates Oracle APIs

Supergood reverse-engineers authenticated browser flows and network interactions to deliver a resilient API endpoint layer for your Oracle tenant(s).

  • Handles username/password, SSO/OAuth, and MFA (SMS, email, TOTP) securely
  • Maintains session continuity with automated refresh and change detection
  • Normalizes responses so you can integrate once and rely on consistent objects across Aconex and Primavera
  • Aligns with customer entitlements and role-based permissions to ensure compliant access

Use Cases

Project Data Sync

  • Mirror projects, companies, and users into your internal systems
  • Keep project metadata current for analytics and reporting
  • Normalize codes, statuses, and dates across Aconex and Primavera

Document Control & Mail Automation (Aconex)

  • Ingest document registers and revisions for drawing dashboards
  • Create RFIs/submittals programmatically with reviewers, due dates, and attachments
  • Track ball-in-court and workflow status for SLA alerts and escalations

Schedule Sync & Progress Updates (Primavera)

  • Pull WBS and activities to power resource planning and timeline views
  • Push percent complete and actual dates from field capture
  • Monitor critical path impacts and trigger follow-ups when thresholds are met

Financials and Approvals (Optional)

  • Normalize commitments and change orders from cost tools to your ERP
  • Generate pay applications with retainage and line-item structures
  • Deliver updates via webhooks or polling while respecting approvals and rate limits

Available Endpoints

Authentication

POST /sessions: Establish a session using credentials. Supergood manages MFA (SMS, email, TOTP) and SSO/OAuth when enabled. Returns a short-lived auth token maintained by the platform.

curl --request POST \
  --url https://api.supergood.ai/integrations/<integration_id>/sessions \
  --header 'Authorization: Basic <Base64 encoded token>' \
  --header 'Content-Type: application/json' \
  --data '{
    "username": "[email protected]",
    "password": "<password>",
    "mfa": { "type": "totp", "code": "123456" }
  }'

Example response

{
  "authToken": "eyJhbGciOi...",
  "expiresIn": 3600,
  "user": {
    "id": "u_9721af",
    "name": "Project Manager",
    "entitlements": ["projects", "aconex_documents", "aconex_mail", "primavera_schedule"]
  }
}

POST /sessions/refresh: Refresh an existing token to keep sessions uninterrupted.

Projects

GET /projects: List projects with filters and summary details across Aconex and Primavera.

Query parameters

  • companyId: string
  • platform: aconex | primavera | any
  • status: active | archived
  • updatedFrom, updatedTo: ISO 8601 timestamps
  • page, pageSize: integers for pagination

Example response

{
  "items": [
    {
      "projectId": "prj_2781c0",
      "name": "North Campus Expansion",
      "projectCode": "NCE-2026-001",
      "status": "active",
      "companyId": "co_88b32e",
      "platforms": ["aconex", "primavera"],
      "address": {
        "line1": "1100 University Ave",
        "city": "Madison",
        "region": "WI",
        "postalCode": "53706",
        "country": "US"
      },
      "startDate": "2026-02-01",
      "endDate": null,
      "updatedAt": "2026-01-20T13:45:00Z"
    }
  ],
  "page": 1,
  "pageSize": 50,
  "total": 1
}

Aconex Mail (RFIs/Submittals/Transmittals)

POST /projects/{projectId}/mail: Create a new Aconex mail thread (e.g., RFI, submittal) with workflow metadata and optional attachments.

curl --request POST \
  --url https://api.supergood.ai/integrations/<integration_id>/projects/prj_2781c0/mail \
  --header 'Authorization: Bearer <authToken>' \
  --header 'Content-Type: application/json' \
  --data '{
    "type": "rfi",
    "subject": "Clarify slab pour sequence",
    "message": "Please confirm sequence and cure durations for podium levels.",
    "dueDate": "2026-02-05",
    "priority": "normal",
    "toUserIds": ["u_45af1d"],
    "ccUserIds": ["u_92b711"],
    "ballInCourtUserId": "u_45af1d",
    "references": {
      "specSection": "03 30 00",
      "documentNumbers": ["S-104", "A-201"]
    },
    "confidential": false,
    "attachments": [
      {"fileName": "sequence_diagram.pdf", "uploadToken": "upl_98dc3a"}
    ],
    "externalReferenceId": "obs-8793"
  }'

Example response

{
  "mailId": "mail_67c21a",
  "mailNumber": 128,
  "type": "rfi",
  "status": "open",
  "createdAt": "2026-01-21T09:12:33Z",
  "externalReferenceId": "obs-8793"
}

Aconex Document Register

GET /projects/{projectId}/documents: List Aconex documents with current revision, discipline, status, and signed download URLs.

Query parameters

  • docType: drawings | specs | models | other
  • discipline: string (e.g., ARCH, STR, MEP)
  • revisionStatus: current | superseded | all
  • updatedFrom, updatedTo: ISO 8601 timestamps
  • page, pageSize: integers for pagination

Example response

{
  "items": [
    {
      "documentNumber": "A-201",
      "title": "Level 02 Floor Plan",
      "revision": "03",
      "discipline": "ARCH",
      "status": "current",
      "workflowState": "approved",
      "file": {
        "fileName": "A-201_rev03.pdf",
        "downloadUrl": "https://signed.supergood.ai/dl/0c9...",
        "sizeBytes": 2854301
      },
      "tags": ["floorplan", "rev03"],
      "updatedAt": "2026-01-21T08:44:11Z"
    }
  ],
  "page": 1,
  "pageSize": 50,
  "total": 237
}

Primavera Schedule Activities

GET /projects/{projectId}/schedule/activities: List Primavera activities with key scheduling fields and optional filters.

Query parameters

  • wbsId: string
  • updatedFrom, updatedTo: ISO 8601 timestamps
  • startFrom, finishTo: dates for range queries
  • page, pageSize: integers for pagination

Example response

{
  "items": [
    {
      "activityId": "act_0f9b21",
      "wbsId": "wbs_1024",
      "name": "Pour Level 02 slab",
      "status": "in_progress",
      "plannedStart": "2026-02-12",
      "plannedFinish": "2026-02-14",
      "actualStart": "2026-02-12",
      "actualFinish": null,
      "percentComplete": 35.0,
      "calendarId": "cal_std",
      "constraints": {
        "startOnOrAfter": "2026-02-10"
      },
      "relationships": {
        "predecessors": ["act_0f9a10"],
        "successors": ["act_0fa010"]
      },
      "updatedAt": "2026-01-22T12:10:03Z"
    }
  ],
  "page": 1,
  "pageSize": 100,
  "total": 412
}

Get full API Specs →

Technical Specifications

  • Authentication: Username/password with MFA (SMS, email, TOTP) and SSO/OAuth where enabled; supports service accounts or customer-managed credentials
  • Response format: JSON with consistent resource schemas and pagination across Aconex and Primavera modules
  • Rate limits: Tuned for enterprise throughput while honoring customer entitlements and usage controls
  • Session management: Automatic reauth and cookie/session rotation with health checks
  • Data freshness: Near real-time retrieval of projects, Aconex mail/documents, and Primavera schedule objects
  • Security: Encrypted transport, scoped tokens, and audit logging; respects Oracle role-based permissions
  • Webhooks: Optional asynchronous delivery for long-running workflows (e.g., mail reviews, schedule approvals)

Performance Characteristics

  • Latency: Sub-second responses for list/detail queries under normal load
  • Throughput: Designed for high-volume document register sync and schedule activity reads
  • Reliability: Retry logic, backoff, and idempotency keys minimize duplicate actions
  • Adaptation: Continuous monitoring for UI/API changes with rapid adapter updates

Getting Started

  1. Schedule Integration Assessment

Book a 30-minute session to confirm your modules, licensing, and authentication model.

  1. Supergood Builds and Validates Your API

We deliver a hardened Oracle adapter tailored to your Aconex and Primavera workflows and entitlements.

  1. Deploy with Monitoring

Go live with continuous monitoring and automatic adjustments as Oracle evolves.

Schedule Integration Call →

Frequently Asked Questions

Q: Which Oracle modules can this integration cover?

Supergood supports workflows across commonly used Oracle Construction modules such as Aconex (Mail, Submittals, Transmittals, Document Register) and Primavera (EPS/WBS, Activities, Calendars, Relationships), subject to your licensing and entitlements. We scope coverage during integration assessment.

Q: How are MFA and SSO handled for automation?

We support username/password + MFA (SMS, email, TOTP) and can operate behind SSO/OAuth when enabled. Sessions are refreshed automatically with secure challenge handling.

Q: Can you sync schedules and progress with our product?

Yes. We normalize Primavera activities (planned/actual dates, percent complete, predecessors/successors, calendars) and can push progress updates sourced from your field workflows.

Q: Are attachments supported for Aconex mail and documents?

Yes. We support downloading artifacts and uploading attachments via signed uploads, with checksum validation and time-limited URLs.

Ready to automate your Oracle workflows?

Supergood can have your Oracle integration live in days with no ongoing engineering maintenance.

Get Started →

Read more