Oracle SOA Blogs- Sandeep

The ampersand escape sequence "&" in a Database Record/XML Payload is being converted to '&' by the BPEL composite.  This results in the XSLT transformation code throwing an oracle.xml.parser.v2.XMLParseException error/exception when the parseEscapedXML method is invoked against the data. The parseEscapedXML method was deprecated in in 12C and should not longer be used. It has been replaced by the new method oraext:parseXML. There is a know bug in the oraext:parseXML method that was address in patch 21377740. The fixes that were made in 21377740 where incorporated into the  12.2.1.0.0 GA release, thus there no patch needed  for the issue.   Note: No backport fix for 12.1.3 was released

Hi, In some case where we are sending data to a file and their may case data contain EOL itself which will be a data issue to other system which process file. In such cases we have to handle EOL in XSLT only. <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet version="1.0" xmlns:ns0="http://xmlns.oracle.com/pcbpel/adapter/db/top/Load_PROJ_SCM_V_Data"                 xmlns:oraxsl="http://www.oracle.com/XSL/Transform/java"                 ">   <oracle-xsl-mapper:schema>     <!--SPECIFICATION OF MAP SOURCES AND TARGETS, DO NOT MODIFY.-->     <oracle-xsl-mapper:mapSources>       <oracle-xsl-mapper:source type="WSDL">             </oracle-xsl-mapper:target>     </oracle-xsl-mapper:mapTargets>     <!--GENERATED BY ORACLE XSL MAPPER 12.1.3.0.0(XSLT Build 140529.0700.0211) AT [TUE MAY 21 03:13:57 EDT 2019].-->   </oracle-xsl-mapper:schema>   <

Write an XSLT template for string replace function and call this template whenever string replacement is required. Create your own Custom XPath function for String replacement that can be imported in JDeveloper and used across the whole developer team. Harness the capabilities of using Java classes in XSLT. This is the simplest method and I'll explain this in just 2 steps, attributed to its simplicity. Create a namespace in XSLT for the Java String class to be used (let's prefix this as  :strClass). Use replaceAll() function of the String class referenced above as highlighted under. And the job is done. <xsl:stylesheet version="1.0"   xmlns:xsl="http://www.w3.org/1999/XSL/Transform"   xmlns:strClass="http://www.oracle.com/XSL/Transform/java/java.lang.String">   <xsl:template match="/">     <xsl:value-of select="strClass:replaceAll($input, 'hello', 'HELLO')"/>   </xsl:template&g

JCA Properties for Oracle File and FTP Adapters: ConcurrentThreshold:  The maximum number of translation activities that can be allowed to execute in parallel for a particular outbound scenario. The translation step during the outbound operation is CPU-intensive and must be guarded because it might cause other applications or threads to starve. The maximum value is  100 . Lenient :  If set to  true , then the Orcle File Adapter does not complain if it does not have enough permission to read or write to the inbound directory. The default value of this property is  false . NumberMessages :  This property is used for outbound batching. The outgoing file is created when the number of messages condition is met. The parameter is of type  int and is not mandatory. The default value is  1 . Recursive :  If this property is set to  true , then the adapter can process all the sub-directories under the main input directory recursively. ThreadCount:  If this property is avail

Hi Everyone, Recently i come with a requirement about Hadoop Hive integration in Oracle SOA, For same i wrote a blog which you can find on below link. https://oraclesoaosbbpmapi.blogspot.com/2019/03/hadoop-hive-data-base-fetching-records.html After successfully configuring hive in weblogic, We faced a new issue which is about connection. Before going deep about issue and solution let's see how HIVE DB manage connection on server side. when ever we make a data base connection for HIVE DB, it create an internal session and generates a session id which is valid for a specific period of time which is configured on server level. After that period of time Hive create a new session id and process the query. How weblogic data source manage connection: When we create a data source in weblogic, We define a connection pool size by which we can use existing connections which are not in use by any other resource by which weblogic minimize the connection cost. Issue due to

Hi, Today we are going to configure UMS adapter in SOA to download mail attachment & push it on file/FTP location. ·          Click on Email Driver properties. ·         In EM FMW Control, open the User Messaging Service node in the navigator and select the usermessagingdriver-email for the relevant managed server. From the context menu, select Email Driver Properties. When there no configuration yet, you will create a new one. If you already configured the SOA Suite for outbound mail traffic, you can edit that configuration for the inbound direction. ·          Click on create ·          In the property overview, there are some properties to set: Press the OK button at the top of the page to apply all configuration changes. The Email Receiving protocol for GMail is IMAP. The Incoming Mail Server is imap.gmail.com. The port should be set to 993 and GMail wants to communicate over SSL, so the checkbox should be checked. The