Introduction Both Classic Replicat and Integrated Replicat can abend on this error. This blog will discuss the causes of this abend and how you can resolve it....
Introduction Both Classic Replicat and Integrated Replicat can abend on this error. This blog will discuss the causes of this abend and how you can resolve it. Main Article This error message, Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE, will appear in your replicat report file. To some DBAs, a Domain Index is not something they see or use on a regular basis. This type of error is usually due to one of two scenarios: 1) the index is invalid and needs to...
Introduction Both Classic Replicat and Integrated Replicat can abend on this error. This blog will discuss the causes of this abend and how you can resolve it. Main Article This error message, Error...
As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using...
As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using Oracle DBCS – Oracle Database Cloud Service - one of the good news is that you can use ODI on-premise to do the work. There are 2 ways to connect: either using the native JDBC Driver, either using a specific Driver. In my investigations on how to use ODI in the Cloud I have tested both drivers. Connect to DBCS using...
As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using Oracle DBCS – Oracle Database Cloud...
Introduction While designing SOA services; especially those ones that represent operations around a business object, a common implementation pattern used is...
Introduction While designing SOA services; especially those ones that represent operations around a business object, a common implementation pattern used is upsert. Upsert is an acronym that means the union of "update plus insert". The idea behind is having a unique operation that decides which action to take - either update the existing record or insert a new one - based on information available in the message. Having one operation instead of two, makes the SOA service...
Introduction While designing SOA services; especially those ones that represent operations around a business object, a common implementation pattern used is upsert. Upsert is an acronym that means the...
Introduction Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This...
Introduction Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This article will introduce into the use of ICS for integrating an on-premise E-Business Suite (EBS) instance via Database Adapter. While EBS in recent releases offers a broad set of integration features like SOAP and REST support (i.e. via Integrated SOA Gateway), these interfaces are not available in older versions like...
Introduction Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This article will introduce into the use of ICS...
The Oracle On-Premises Agent (aka, Connectivity Agent) is necessary for Oracle ICS to communicate to on-premise resources without the need for firewall...
The Oracle On-Premises Agent (aka, Connectivity Agent) is necessary for Oracle ICS to communicate to on-premise resources without the need for firewall configurations or VPN. Additional details about the Agent can be found under New Agent Simplifies Cloud to On-premises Integration. The purpose of this A-Team blog is to give a consolidated and simplified flow of what is needed to install the agent and provide a foundation for other blogs (e.g., E-Business Suite Integration...
The Oracle On-Premises Agent (aka, Connectivity Agent) is necessary for Oracle ICS to communicate to on-premise resources without the need for firewall configurations or VPN. Additional details...
Executive Overview SOA Cloud Service (SOACS) can be used to support the B2B commerce requirements of many large corporations. This article discusses a common...
Executive Overview SOA Cloud Service (SOACS) can be used to support the B2B commerce requirements of many large corporations. This article discusses a common use case of EDI processing with Oracle B2B within SOA Cloud Service in a hybrid cloud architecture. The documents are received and sent from on-premise endpoints using SFTP channels configured using SSH tunnels. Solution Approach Overview The overall solution is described in the diagram shown here. An XML file with...
Executive Overview SOA Cloud Service (SOACS) can be used to support the B2B commerce requirements of many large corporations. This article discusses a common use case of EDI processing with Oracle B2B...
In Part 2, we produced the MDS-00054 error. In this final part of the blog, we will find a way to fix the error and recover all running instances from previous...
In Part 2, we produced the MDS-00054 error. In this final part of the blog, we will find a way to fix the error and recover all running instances from previous deployments. Based on the knowledge from Part 1, we can divide the procedure of fixing our problem into four steps. -- Deploy the composite -- Fix running instances -- Fix human workflow -- Fix instance audit trails Deploy the composite Because of the MDS-00054 error, any attempt of redeploying the composite over the...
In Part 2, we produced the MDS-00054 error. In this final part of the blog, we will find a way to fix the error and recover all running instances from previous deployments. Based on the knowledge from...
In Part 1, we looked into MDS and SOAINFRA tables to gain an understanding of data structure related to composite deployment and instance creation. At the end...
In Part 1, we looked into MDS and SOAINFRA tables to gain an understanding of data structure related to composite deployment and instance creation. At the end of Part 1, we can summarize, in the following, the key data pieces created in MDS and SOAINFRA due to deploying, redeploying our test composite and creating two composite instances. MDS: -- SCA label: soa_8ac4edfb-ae15-4e93-a6e2-f62852460064, created for redeployment -- Composite source under default folder...
In Part 1, we looked into MDS and SOAINFRA tables to gain an understanding of data structure related to composite deployment and instance creation. At the end of Part 1, we can summarize, in...
Introduction There is an issue in Oracle SOA Suite Fabric layer in version 11.1.x. and 12.1.3. The issue is documented in Bug# 20517579: "Composites Lost...
Introduction There is an issue in Oracle SOA Suite Fabric layer in version 11.1.x. and 12.1.3. The issue is documented in Bug# 20517579: "Composites Lost Completely after redeployment and server restart". This bug is fixed in version 12.2.1. A few customers have run into this bug. Once this bug is encountered, BPM server usually shows "MDS 00054: The file to be loaded oramds:/deployed-composites/CompositeName_rev1.0/composite.xml does not exist" error during server startup....
Introduction There is an issue in Oracle SOA Suite Fabric layer in version 11.1.x. and 12.1.3. The issue is documented in Bug# 20517579: "Composites Lost Completely after redeployment and...
