Oracle Fusion ERP RICE: How To Create and use NodeSet from a delimited String or Vice-Versa in OIC Integrations

In many cases in our Integrations we get node set and we want to convert it to a delimited string Or we get delimited string and we want to convert to Node Set to iterate.

For the above requirements, We can use below two functions:

oraext:create-delimited-string()
oraext:create-nodeset-from-delimited-string()

Let us take each of these Functions in detail.

oraext:create-delimited-string()

This function allows us to convert a nodeset to delimited string of our choice.

The syntax is like below:

oraext:create-delimited-string (nodeSetValue, delimiter)

Let us take example where we extract requisitions which provides us the requisitions as nodes in xml.

We want to convert the requisition numbers to string list with a delimiter value so that we can send this in IN clause to our BIP Data model query or to any API call.

Below are the screenshots for the same:

Here we are using an assign var to create requisition number list with '!' delimiter:

In the runtime the reqn nodes will get assigned as list as shown in below screenshot.

oraext:create-nodeset-from-delimited-string()

Not Let us take example where we receive a delimited string and we want to iterate over each value in the string.For this we can use "oraext:create-nodeset-from-delimited-string()"

The syntax for the above function is:

oraext:create-nodeset-from-delimited-string (qName, delimitedString, delimiter)

Let us take example where we get company codes csv list as input to our integrations. We need to iterate over each company to get corresponding ledger and submit import journals in Oracle Fusion.

We can use a stage write operation to store the node set and then read the file.

We can use simple csv schema.

Now in the mapper we should use like below having for each on nodeset:

We can use the function like below :

oraext:create-nodeset-from-delimited-string ("dummy", $g_Company, "," )

oraext:create-nodeset-from-delimited-string ("{http://xmlns.oracle.com/DelimitedStringDemo}Company", $g_Company, "," )

For the company value we should use current() as shown in below screenshot.

Below is how it looks like when we open the mapper in code mode :

<xsl:template match="/" xml:id="id_11">
              <nstrgmpr:Write xml:id="id_12">
                    <ns27:CompanySet>
                          <xsl:for-each select="oraext:create-nodeset-from-delimited-string ("dummy", $g_Company, "," )">
                                <ns27:Company xml:id="id_47">
                                      <ns27:Company xml:id="id_48">
                                            <xsl:value-of xml:id="id_49" select="current()"/>
                                      </ns27:Company>
                                </ns27:Company>
                          </xsl:for-each>
                    </ns27:CompanySet>
              </nstrgmpr:Write>
        </xsl:template>

After writing this to the file we can read them as nodes.

Let us see how it works in runtime:

We got the company list as below:

Now using the above function we will convert it to nodeset.

Now let us see the read response for this file: The read file will also have same csv schema as write file.

Oracle Fusion ERP RICE

Monday, November 6, 2023

How To Create and use NodeSet from a delimited String or Vice-Versa in OIC Integrations

No comments:

Post a Comment