OIC, Oracle SOA, OSB, Weblogic

Hi ALL, Today i want to share some thing very interesting thing about XSLT execution in weblogic server.. For XSLT, those DEV/TEST/UAT/PROD server references in source/target are not harmful as these will be treated as comments by the XML parser while doing the transformations at the run-time. But these commented lines should be required while opening that XSLT in transformation because, jdeveloper studio will get the source/target details from the commented lines only.

how to call a preference value in XSLT in SOA? Solution: Function to retrieve the preference : http://www.xenta.nl/blog/2009/10/28/oracle-soa-suite-11g-setting-and-getting-preferences/ Create a new xsl mapping and let the 'first' parameter be some messageType variable (for example the inputVariable, or some other variable you use for your main input). In the xslt add between the "<xsl:stylesheet>"-tag and the "<xsl:template match=".">"-tag something like  "<xsl:param name="myPref" />" Your xsl is ready to receive the extra input parameter. Now in your bpel process do something like this       <copy>         <from expression="ora:doXSLTransformForDoc('xsl/myxslt.xsl', $inputVariable.input, 'myPref', ora:getPreference(myPref))"/>         <to variable="myresult"/>       </copy>    or first assign ora:getPreference(myPre

We have a inbound file adapter. It will read the files from one source location. If inbound file adapter was down for some time. After some time it is up running, meanwhile list of files will be placed in inbound source folder. The requirement here is, the file adapter has to read the files in the order in which the files written. (means, in FIFO order) How to fulfill the requirement via file adapter. Solution: We can use the ListSorter File Adapter Configuration property to sort based on timestamp. Basically a dd the following property to the inbound JCA file: <property name="ListSorter" value="oracle.tip.adapter.file.inbound.listing.TimestampSorterAscending"/> <property name="SingleThreadModel" value="true"/> More info see section 4.2.6 in http://docs.oracle.com/cd/E23943_01/integration.1111/e10231/adptr_file.htm

I got a requirement in SOA 11.1.1.6--- From a webservice call to db insert XSLT,  i have 10 elements at source side and 11 elements at target side. From source to target first 10 mappings are done. Now requirement is, for the 11th element in target- we need pass a sequence number to the targeted database, means---(sequence number has to be generated for every execution of XSLT)  How to do the last point??? Solution:  We can pass the sequence number in the 11th element using oraext:sequence-next-val("Sequence name as a string", "Datasource as a string") function.