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
Author: Bo
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
Dockerize your Enterprise Command Center
The Container Life-Cycle managent for ECC will required splitting the running of envSetup.sh into two parts. First part will just run Step 1 creation of ECC user and ECC schema in EBS database. So technically you don't even need two docker images to do this. You can just quickly set up your ECC environment following … Continue reading Dockerize your Enterprise Command Center
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
EM13c job failed with ORA-20233: Unable to determine OS for :. Error: ORA-01403: no data found
I recently came across this error in our EM13c environment after pushing a couple of ODA hardware plugin to the monitoring agents. Even though configuration for the Plugin looks okay to my knowledge After this plugin was push, all the EM13 jobs (backup, Enterprise -> Job) are all failing with following error messages ORA-20233: Unable … Continue reading EM13c job failed with ORA-20233: Unable to determine OS for :. Error: ORA-01403: no data found
Adding ECC Dashboard to EBS Custom Responsibility
Acquire the menu nameMenu name can be found via Security -> Responsibility -> Define -> Responsibility NameAdd ECC dashboard function to a MenuApplication -> Menu -> User Menu NameCreate Submenu -> ECC - <Responsibility name>Under Submenu add the following functionWIP Command CenterDiscrete ECC Production StatusDiscrete ECC Production QualityDiscrete ECC Outside ProcessingINV Command CenterShipping Dashboard Landing … Continue reading Adding ECC Dashboard to EBS Custom Responsibility
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
Oracle Journey 