Problem Statement: If you are coming from Oracle EBS background, you will be surprised to find out there isn't a single way to PUSH the data out from Oracle HCM (like EBS business events). Yes, there is Atom feeds but that's for another topic. During our HCM implementation, we have to re-architect our current integrations … Continue reading Calling SOAP Service to run an HCM Extract
Category: Oracle
Sync EBS Department to HCM Organization without HCM API for POST
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
OIC connectivity Agent in Docker
Build Context location /var/lib/docker/docker-images/OIC -rwxr--r-- 1 root root 39 Jan 8 09:14 build.sh -rwxr--r-- 1 root root 68 Jan 8 09:16 run.sh -rwxr--r-- 1 root root 43 Jan 8 09:29 connect.sh -rwxr--r-- 1 root root 438 Jan 8 13:52 Dockerfile drwxr-xr-x 2 root root 123 Jan 8 13:55 files drwxr-xr-x 2 root root 106 Jan … Continue reading OIC connectivity Agent in Docker
Tracking ECC dashboard access
There are two MOS notes pertaining to enabling page tracking in EBS. Log into EBS ->System Administrator -> Oracle Application Manager -> Application Usage -> Configuration Set Web Access to "Yes" then Select "Information Capture Level" as you desired. (I pick "Session Info" only), then move all the "Application" you wish to track under "Track … Continue reading Tracking ECC dashboard access
Enabling Enterprise Command Center
There is an oracle documentation for configuring ECC version 2 for 12.2.My environment is EBS 12.2.5 and there are handful of patches required for ECC.Start adop session then applied in this order,Patch 28780005:R12.ATG_PF.CPatch 28780241:R12.ATG_PF.C - Adapter patchProduct family patchesPatch 28780031:R12.FIN_PF.C - FinancialsPatch 28779987:R12.PRC_PF.C - ProcurementPatch 28780037:R12.SCM_PF.C - Supply Chain Management Additional patchesPatch 29760524:R12.BOM.DPatch 29551003:R12.ICX.DPatch 29551335:R12.AP.CPatch … Continue reading Enabling Enterprise Command Center
EBS database migration leveraging Active Dataguard
Build dataguard Standby instance from Primary databasePrimarySQL> SELECT log_mode FROM v$database;LOG_MODE------------ARCHIVELOG Create standby redo logs on the primary database (in case of switchovers). The standby redo logs should be at least as big as the largest online redo log and there should be one extra group per thread compared the online redo logs.ALTER DATABASE FORCE … Continue reading EBS database migration leveraging Active Dataguard
RMAN – install_driver(Oracle) failed: Attempt to reload DBD/Oracle.pm aborted
Recently I came across this issue while migrating our metrics and targets from Enterprise Manager 12c to Enterprise Manager 13c. Pretty much every backup jobs schedule from EM13c console for this particular node is failing with following error message. install_driver(Oracle) failed: Attempt to reload DBD/Oracle.pm aborted. Compilation failed in require at (eval 15) line 3. … Continue reading RMAN – install_driver(Oracle) failed: Attempt to reload DBD/Oracle.pm aborted
EM 13.2 Linux Repo setup failed
Linux RPM Repository Server Setup failed with generic error message on EM web console. Internal error in EM Patch Advisor CAUSE: A possible bug in EM Patch Advisor. ACTION: Report this issue to Oracle Support. Under /u01/app/oms132/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log 2019-01-08 21:10:53,082 [RJob Step287428] FATAL jobs.GetULNChannels logp.251 - Internal error in EM Patch Advisor CAUSE: A possible bug … Continue reading EM 13.2 Linux Repo setup failed
gDBClone “GOLD” image and Snapshot database creation
PSA: gDBClone utility is developed by Oracle (Ruggero Citton) to simplify database cloning for non-production instances leveraging ACFS snapshots feature. Download gDBClone-3.0.2-92.noarch.rpm (as of 24Aug2018) export PATH=$PATH:/opt/gDBClone tree /opt/gDBClone/ /opt/gDBClone/ ├── gDBClone └── lib ├── gDBClone_AcfsUtils.pm ├── gDBClone_Clone.pm ├── gDBClone_DBConvert.pm ├── gDBClone_GetDBConnection.pm ├── gDBClone_Inventory.pm ├── gDBClone_LoggingAndTracing.pm ├── gDBClone_passwd.jar ├── gDBClone_PFile.pm ├── gDBClone_Queries.pm ├── gDBClone_Snap.pm ├── … Continue reading gDBClone “GOLD” image and Snapshot database creation
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 