Leveraging Oracle Integration Cloud (OIC) for Labor Hours and Cost Automation

 Overview

This document outlines a technical solution to automate the extraction of approved labor hours from Oracle HCM Cloud, perform custom labor cost calculations, and load the data into Oracle Projects Cloud using Oracle Integration Cloud (OIC) ,FBDI Adapter . This solution highlights OIC's pivotal role in orchestrating complex integrations and simplifying development through its prebuilt adapters.

---

Objective

• Extract approved labor hours from Oracle HCM Cloud via HCM Extracts and store the data in Oracle ATP (Autonomous Transaction Processing) database.
• Perform custom labor cost calculations on the extracted data within ATP.
• Transfer calculated labor costs into Oracle Projects Cloud by invoking the FBDI Adapter Import Costs job.

---

Key Components of the Integration Flow

1. Extract Approved Labor Hours from Oracle HCM

• HCM Extracts:
  • Extract approved labor hours from Oracle HCM.
  • Load the data into an HCM Extract file and upload it to the UCM server.

2. OIC Integration Flow – Job 1

This OIC flow orchestrates the end-to-end processing of the labor hours data.
Key steps include:

1. Read the latest HCM Extract file from UCM using the Oracle HCM Adapter.
2. Unzip the Extract file to retrieve its contents.
3. Load data into a custom table in Oracle ATP:
   • Use OIC’s ATP Adapter to connect to the database.
   • Map the data fields from the file to the custom table schema.
4. Run a BIP Report using the Oracle BI Publisher Adapter to fetch additional required data from Oracle HCM/Projects.
5. Perform Labor Cost Calculations:
   • Use a combination of OIC's inbuilt transformation capabilities and database procedures to compute labor costs.
6. Prepare an FBDI file for Import Cost:
   • Format the calculated data per Oracle Projects’ Import Cost FBDI template.
7. Call the FBDI Adapter to invoke the Import Cost ESS job in Oracle Projects.

3. OIC Integration Flow – Job 2

This callback job ensures end-to-end monitoring and error handling.
Key steps include:

1. Subscribe to the Import Cost ESS job completion event:
   • Use the ERP Cloud Adapter’s event subscription capability to receive notifications.
2. Validate the ESS Job Status:
   • If successful, mark the corresponding record in ATP as Success.
   • If failed, mark the record as Error and log the details.
3. Send Status Notifications:
   • Use OIC's Email Adapter to send email updates about the job status.

---

Role of Oracle Integration Cloud (OIC)

1. Orchestration and Automation

OIC acts as the central orchestrator, managing data flows between Oracle HCM, ATP, and Oracle Projects seamlessly. It ensures data accuracy, integrity, and consistency across systems.

2. Simplified Development with OIC Adapters

• HCM Adapter: Simplifies interaction with Oracle HCM Cloud by abstracting REST API complexities.
• ATP Adapter: Enables secure and straightforward connectivity with Oracle ATP databases, supporting seamless CRUD operations.
• ERP Cloud Adapter: Eases integration with Oracle Projects Cloud by providing out-of-the-box capabilities to call ESS jobs and handle FBDI processes.
• BI Publisher Adapter: Facilitates report generation and data retrieval without manual scripting.
• Email Adapter: Automates email notifications, reducing the need for custom SMTP configurations.

3. Event-Driven Architecture

OIC’s event-driven capabilities ensure real-time processing and monitoring of critical processes like Import Cost job completion.

---

Benefits of Using OIC

• Reduced Development Time: Prebuilt adapters eliminate the need for complex custom code.
• Enhanced Error Handling: Built-in features like logging, exception handling, and email notifications ensure robust workflows.
• Scalability: OIC’s ability to handle large data volumes and parallel executions makes it ideal for enterprise-grade integrations.
• Flexibility: The drag-and-drop interface and pre-configured connectors make OIC adaptable to changing business requirements.