Search 800 + Posts

Mar 17, 2024

Connecting SuccessFactors to Oracle Fusion HCM via OIC

Integrating SuccessFactors, an SAP product, with Oracle HCM (Human Capital Management)  can offer a seamless and efficient solution for organizations looking to optimize their human resources processes. 

Our use case : One of our customer is leveraging SuccessFactors for managing its human resources, including employee data, performance evaluations, and talent management processes. However, the company has recently adopted Oracle Fusion HCM for its comprehensive suite of human capital management solutions. To ensure seamless data synchronization between the two platforms and avoid manual data entry, the company has decided to integrate SuccessFactors with Oracle Fusion HCM using Oracle Integration Cloud (OIC). 


The company receives regular updates from SuccessFactors in the form of .csv files containing employee data, and other relevant information. These .csv files need to be automatically ingested into Oracle Fusion HCM to ensure that employee records are up-to-date across both systems.

Process Flow

Implementation Steps

Trigger Event:

SuccessFactors generates a .csv file containing updated employee data, performance evaluations, and move the file to SFTP Server .

File Ingestion:

An OIC scheduled job triggered every 6 hour to monitor a specific folder ( on SFTP Server) where the .csv files from SuccessFactors are deposited and read all the .csv files available in folder .

Data Transformation and Mapping:

Upon detecting the .csv file, OIC extracts the data and performs necessary transformations/mappings/lookups  to ensure compatibility with Oracle Fusion HCM data structures.

Data mapping rules are applied to map fields from the .csv file to corresponding fields in Oracle Fusion HCM ( we have many options available HDL/Adapter /REST apis) , for our implementations we relied on REST APIs for all the validations and Create/Update operations.

Data Validation and Enrichment:

OIC validates the incoming data for accuracy, completeness, and consistency. Any missing or erroneous data is flagged for resolution

Integration with Oracle Fusion HCM:

The transformed and validated data is securely transmitted to Oracle Fusion HCM using OIC's /HCM REST apis. Oracle Fusion HCM receives the data  and execute following scenarios

  1. Once file received from SF and process by OIC , load data into a temp Table and move file to Archive folder 
  2. If Employee not exist in HCM then Create Employee
  3. If employee exists in HCM then Update the employee for 
    1. Name
    2. Email
    3. Work relation ship
    4. Assignment
    5. Assignment DFF
  4. If employee exists in HCM and Process flag is Termination then Terminate the employee
  5. If employee exists in HCM with status Terminated and Data process flag in the file is Rehire , then Rehire the employee
  6. If employee not exists in HCN and process flag = rehire then 
    1. Create Employee
    2. Terminate Employee 
    3. Rehire Employee
  7. Mark the record in TEMP table as Processed or Error.

Error Handling and Logging:

OIC includes robust error handling mechanisms to identify and handle integration errors, such as data format discrepancies or connectivity issues. Apart from that we have added email notification as well as logged errors in custom DB table ( form OIC).

Detailed logging and monitoring capabilities allow administrators to track the status of integration jobs, troubleshoot issues, and ensure smooth operation of the integration process.


Automated Data Synchronization: Eliminates manual data entry and ensures real-time synchronization of employee data between SuccessFactors and Oracle Fusion HCM.

Improved Data Accuracy: Reduces the risk of data errors and inconsistencies by automating data validation and enrichment processes.

Scalability: OIC's flexible and scalable architecture accommodates future growth and evolving integration needs as the company expands its workforce or adopts additional HR systems.

Integrating Oracle Fusion SaaS applications with OIC

 Oracle Integration Cloud (OIC) offers a seamless solution for integrating Oracle Fusion SaaS applications with various other systems, enabling businesses to optimize their operations and drive efficiency. This integration empowers organizations to streamline processes, enhance agility, and unlock the full potential of their Oracle Fusion SaaS investment.

Key benefits of Oracle OIC integration with Oracle Fusion SaaS include:

  1. Unified Ecosystem: Oracle OIC facilitates the seamless integration of Oracle Fusion SaaS applications with on-premises systems, third-party applications, and cloud services, creating a unified ecosystem that eliminates data silos and promotes collaboration.

  2. Efficiency and Productivity: By automating manual tasks and streamlining business processes, Oracle OIC integration with Oracle Fusion SaaS reduces operational complexity, increases productivity, and accelerates time-to-market for new initiatives.

  3. Real-time Data Insights: Integrating Oracle Fusion SaaS with OIC enables businesses to gain real-time visibility into critical data and analytics, empowering informed decision-making, strategic planning, and proactive risk management.

  4. Scalability and Flexibility: With Oracle OIC, organizations can easily scale their integrations as their business grows, ensuring seamless performance and adaptability to evolving business requirements without compromising on security or compliance.

  5. Enhanced Customer Experience: By integrating Oracle Fusion SaaS applications with customer relationship management (CRM) systems and other customer-facing platforms, businesses can deliver personalized experiences, improve customer satisfaction, and drive loyalty.

  6. Cost-effectiveness: Oracle OIC integration with Oracle Fusion SaaS reduces IT infrastructure costs and maintenance overheads associated with managing disparate systems, enabling businesses to achieve a higher return on investment (ROI) and lower total cost of ownership (TCO).

you can some of our work with OIC at

In conclusion, Oracle Integration Cloud (OIC) integration with Oracle Fusion SaaS offers a comprehensive solution for businesses seeking to optimize their operations, drive innovation, and stay competitive in today's dynamic marketplace. By leveraging the power of integration, organizations can unleash the full potential of their Oracle Fusion SaaS investment and achieve transformative business outcomes.

Feb 8, 2024

How to find the reversal journal details of a journal in EBS

 When a journal is reversed, the following fields will be populated in the Original Journal related to the Reversal Journal: ACCRUAL_REV_FLAG, ACCRUAL_REV_STATUS, ACCRUAL_REV_JE_HEADER_ID, ACCRUAL_REV_PERIOD_NAME, ACCRUAL_REV_EFFECTIVE_DATE

Execute below query to identify the reversal journal. The below query will give you the reversed journal header name, header id and period.

    glhr.je_batch_id    "Reversal JE Batch ID",           "Reversal JE Name",
    glhr.je_header_id   "Reversal JE Header ID",
    glhr.period_name    "Reversal JE Period Name"
    gl_je_headers   glho,
    gl_je_headers   glhr
    glho.accrual_rev_je_header_id = glhr.je_header_id
    AND glho.accrual_rev_je_header_id IS NOT NULL
    AND glho.je_header_id = &je_header_id;

Feb 5, 2024

Bulk loading data into Oracle Autonomous Data Warehouse (ADW) using Oracle Integration Cloud (OIC).

This document explores bulk loading data into Oracle Autonomous Data Warehouse (ADW) using Oracle Integration Cloud (OIC). It covers the benefits, steps involved, configuration details, and best practices for a successful implementation.

For technical details please refer my other post at Bulk Load ADW Feature with OIC

Benefits of Bulk Loading with OIC:

  • Performance: Bulk loading significantly improves data loading speed compared to traditional methods like SQL*Loader , Loading data using Read/Write file in OIC or Insert Feature of ADW Database adapter.
  • Security: Utilize OIC's built-in security features and access control for secure data transfer.
  • Automation: Set up scheduled integrations for regular data updates without manual intervention.
  • Scalability: Handle large datasets efficiently with OIC's cloud-based scalability.

Configuration Involved:

  1. Ensure your data is in a supported format (CSV, JSON, etc.).
  2. Structure the data according to your target ADW table schema.
  3. Create OIC Integration , App Driven Orchestration (ADO) or for event-triggered loads or Schedule Based Orchestration (SBO) for regular schedules.
  4. Configure Adapter:
    1. Specify the ADW connection details and target table.
    2. Select the "Invoke Bulk Load from Object Storage" operation.
    3. Provide the Object Storage bucket and file information.
    4. Optionally, configure file format settings.
    5. Configure Table name that you would like to load and column names that you would like to populate.
  5. Test and Deploy:
    • Test the integration thoroughly with test data.
    • Deploy the integration and monitor its performance.

Process Flow :

  1. Once OIC flow triggered it will download data file(s) from SFTP server
  2. Load data file into temp memory
  3. Call ADW adapter , and since we have configure ADW adapter with Operation : "Perform Bulk Data Import Operation" , it will load data file into OCI bucket and then load data into ADW Table