Problem Statement: Migrating all EBS modules to Oracle Fusion with HCM being the first one to go. Since financial module will still be on on-prem EBS and business do not want to create Departments in two systems.The issue is that there is no HCM API to create or update department/organization in HCM. We are going … Continue reading Sync EBS Department to HCM Organization without HCM API for POST
Category: REST
Apex 19.2 (ORDS) in tomcat Docker container
Update : 04 February 2020Instead of relying on having server.xml being pass as Docker build image step, I added a few environment variables for tomcat ports and use those environment variables to configured server.xml I got my base image from https://github.com/Dani3lSun/docker-db-apex-dev. His APEX docker image is for someone who wants to tried out APEX without … Continue reading Apex 19.2 (ORDS) in tomcat Docker container
Simple Apex Apps using REST Data Services
Create Module Create Template Create Handler Following query will return RMAN Backup Duration in seconds format for latest RMAN job with backup_runs as ( select operation, status, object_type, start_time, end_time, to_char(start_time,'MM/DD/YYYY HH24:MI:SS') as char_start_time, to_char(end_time,'MM/DD/YYYY HH24:MI:SS') as char_end_time from v$rman_status where operation in ('RMAN','BACKUP') and OBJECT_TYPE like '%DB%' and STATUS = 'COMPLETED' and start_time = … Continue reading Simple Apex Apps using REST Data Services
Oracle Journey 