You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Steps to call SQL statement execution in ATP database in OIC from HCM Cloud

    edited Feb 26, 2025 10:33AM in Integration 1 comment

    Summary:

    Steps to call SQL statement execution in ATP database in OIC from HCM Cloud

    Content (please ensure you mask any confidential information):

    Hi Team,

    Greetings!

    We are currently running some DML statements in ATP database in OIC - typically update statements to flip the status from processed to unprocessed- so that next scheduled run of the OIC integration will reprocess the record.

    Is there a way to invoke such DML statements (or PL/SQL procedure defined in ATP database on OIC side) from HCM Cloud by means of submitting a flow and providing the input parameter with the values to be used in the DML operation?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!