Oracle API
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 doc
What is Oracle?
Oracle Construction and 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
Getting Started
- Schedule Integration Assessment
Book a 30-minute session to confirm your modules, licensing, and authentication model.
- Supergood Builds and Validates Your API
We deliver a hardened Oracle adapter tailored to your Aconex and Primavera workflows and entitlements.
- Deploy with Monitoring
Go live with continuous monitoring and automatic adjustments as Oracle evolves.
API Endpoints
Authentication
/sessionsEstablish 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.
Authentication
/sessions/refreshRefresh an existing token to keep sessions uninterrupted.
Projects
/projectsList projects with filters and summary details across Aconex and Primavera.
Aconex Mail (RFIs/Submittals/Transmittals)
/projects/{projectId}/mailCreate a new Aconex mail thread (e.g., RFI, submittal) with workflow metadata and optional attachments.
Aconex Document Register
/projects/{projectId}/documentsList Aconex documents with current revision, discipline, status, and signed download URLs.
Primavera Schedule Activities
/projects/{projectId}/schedule/activitiesList Primavera activities with key scheduling fields and optional filters.
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
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)
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
Frequently asked questions
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.
We support username/password + MFA (SMS, email, TOTP) and can operate behind SSO/OAuth when enabled. Sessions are refreshed automatically with secure challenge handling.
Yes. We normalize Primavera activities (planned/actual dates, percent complete, predecessors/successors, calendars) and can push progress updates sourced from your field workflows.
Yes. We support downloading artifacts and uploading attachments via signed uploads, with checksum validation and time-limited URLs.