Posts

Showing posts from May, 2026

Hierarchical Queries - Department and Workers

            Query to Extract Department Trees in Oracle Cloud HCM                    SELECT /*+ materialize */                DISTINCT *         FROM (                SELECT   (                         SELECT haoufv_p.name                         FROM hr_all_organization_units_f_vl haoufv_p                         WHERE haoufv_p.organization_id = potnv.parent_organization_id                               AND TRUNC(SYSDATE) BETWEEN haoufv_p.effective_start_date    ...
Image
           Deploying an AI agent on Redwood Page                                    1.     N avigate to the AI Agent Studio from the Tools Menu             2.    Select any available delivered AI agent and Copy it to be used by    your business.                         3.     Run it to see all the Profiles and Config are good.         4.     Publish the AI Agent              5.       Navigate to My Client Groups -> Guided Journeys      6.       Create New Journey      7.       Create Draf...