Agile Teams
Integration recipes for efficiency
Key Achievements
5bu3ff6jrd3rkfexehtdzzir8p1hs7-large.webp&w=3840&q=75)
“I’ve worked with many offshore teams, but none of them were as responsible as you.”
Praveen Morusupalli, Engineering Director - OIC
Client
Oracle is an American multinational technology company providing enterprise software, cloud solutions, database technologies, and integrated business platforms used by organizations worldwide.
5bu3ff6jrd3rkfexehtdzzir8p1hs7-small.webp)
1x65vi1wv4rhohf5sklhb5l14bsm94-small.webp)
l0tnjmcbl3m2rc6vcr182ez0m7nk3t-small.webp)
f6xggq81ar5wcxpkcbqg6dpvbxn0ub-small.webp)
bgdwiiabgjqg2ix67txojfiv41kcsr-small.webp)
qrjbtbnbnlsxlht9kv2jfa3y765gmb-small.webp)
Case study
The need
Since 2018, Hotovo has partnered with Oracle on integrations built with Oracle Integration Cloud (OIC). The collaboration focused on streamlining project delivery processes across Oracle’s project management, planning, scheduling, construction collaboration, and project controls solutions.
Oracle needed reusable, production-ready integrations and adapters that simplify data synchronization between systems, reduce manual work, improve consistency across applications, and accelerate customer implementations.
The integrations also had to support complex project environments with different APIs, payload formats, document flows, and scheduling structures, while remaining scalable, reliable, and easy to operate.
Core issue
Many projects were delivered under tight timelines driven by customer go-live dates, major construction projects, or contractual milestones. Integrations had to work reliably across heterogeneous SaaS landscapes with inconsistent APIs, complex data structures, and different payload formats.
The integrated systems often exposed fragmented APIs across multiple modules using both XML and JSON, without unified schema definitions. Complex project scenarios also required advanced data transformations, conditional logic, document handling, and synchronization between planning and execution systems.
At the same time, the integrations needed to remain scalable, reusable, easy to operate, and accessible even for users without deep technical integration knowledge.
Our solution
Hotovo delivered a portfolio of reusable Oracle Integration Cloud recipes, accelerators, and dedicated adapters that simplify cross-application project delivery and automate end-to-end business workflows.
Integration recipes
We developed out-of-the-box integration recipes that customers can activate and configure with minimal effort. These recipes included pre-built mappings, transformations, logging, and error handling.
The delivered integrations enabled:
- Automated flow of approved engineering deliverables into project and construction planning systems
- Synchronization between agile delivery tools and project controls platforms
- Controlled and auditable document transfers between construction collaboration environments
- End-to-end alignment between project planning, scheduling, execution, and reporting systems
The solutions leveraged Oracle platforms such as Oracle Primavera Cloud, Oracle P6 EPPM, Oracle Primavera Unifier, Oracle Fusion PLM, and Oracle Aconex.
Project delivery accelerators
Beyond individual recipes, we created larger integration accelerators focused on synchronizing schedules, costs, resources, and master data across project planning and execution systems.
We also enabled synchronization directly from the business application user interface through simple “sync” actions, removing the need for users to interact directly with OIC configuration.
This significantly reduced deployment complexity and simplified day-to-day operations for business users.
Dedicated Oracle Aconex adapter
To simplify integrations further, we developed and published a dedicated Oracle Integration Cloud adapter for Oracle Aconex.
The adapter abstracts the complexity of multiple inconsistent APIs and provides a unified integration experience by:
- Standardizing authentication and payload handling
- Supporting both XML and JSON APIs
- Managing complex document and file transfer operations automatically
- Generating technical configurations directly within OIC
This allowed customers to integrate Oracle Aconex into their business processes without building and maintaining custom integration code.
Technical implementation
To address complex mapping and transformation requirements, we used:
- Advanced XSLT transformations
- XPath expressions
- User-defined functions
- Grouping and aggregation logic
- JavaScript-based custom logic inside OIC
This enabled sophisticated integrations while remaining aligned with Oracle Integration Cloud best practices.
Key results
- Ongoing successful collaboration with Oracle since 2018
- Delivered reusable integration recipes, accelerators, and adapters for Oracle Integration Cloud
- Automated cross-application project delivery processes across heterogeneous SaaS environments
- Reduced integration build time from weeks to hours or days through reusable integration patterns
- Lowered integration operating costs through payload optimization, batching, and reduced API calls
- Improved data consistency across project planning, scheduling, document management, and execution systems
- Simplified integrations for business users through UI-triggered synchronization and guided adapter experiences
- Delivered production-ready integrations under tight customer go-live timelines
- Successfully supported large-scale project mobilization scenarios with strict delivery windows
- Standardized logging, monitoring, and error handling for improved operational visibility
- Built integrations across Oracle Primavera Cloud, Oracle P6 EPPM, Oracle Primavera Unifier, Oracle Fusion PLM, and Oracle Aconex
Tech stack
- Oracle Integration Cloud (OIC)
- JavaScript
- XSLT
- XPath
- XML / JSON APIs
- Oracle Primavera Cloud
- Oracle P6 EPPM
- Oracle Primavera Unifier
- Oracle Fusion PLM
- Oracle Aconex
Team size
- Integration Developer
- Technical Writer
- QA Engineer
1y8bw9zwfkekqjq4zuqkimrxonh0ju-small.webp&w=3840&q=75)













5bu3ff6jrd3rkfexehtdzzir8p1hs7-small.webp&w=3840&q=75)






