Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Left Pad Zeroes to a Number in Assign Activity in OIC — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Left Pad Zeroes to a Number in Assign Activity in OIC

Accepted answer
edited Jul 22, 2020 9:50AM in Integration 3 comments


Left Pad Zeroes to a Number in Assign Activity in OIC (OIC Version:

I see that format-number XSLT function does this job, but it is only available in OIC Mapper and not in Assign activity.

<span class="tag"><xsl:value-of</span><span class="pln"> </span><span class="atn">select</span><span class="pun">=</span><span class="atv">"format-number(123, &#39;0000&#39;)"</span><span class="pln"> </span><span class="tag">/></span>

I also see a KA Fn:format-number Not Available in Assign Activity (Doc ID 2360096.1)

and related Bug 27501164 : fn:format-number is not available in assign activity

Last Comment on Bug states: format-number is a standard XSLT function, not a standard XPath function. Hence, it is only available in mapping, which leverages XSLT.  The function would need to be re-implemented as a custom XPath function at runtime, this goes beyond mapper UI.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!