Skip to main content
Home/All Tools/Oracle Integration (OIC)/Oracle Integration Cloud (OIC) XSLT Map Studio
How to Use & Guide ↓

Oracle Integration Cloud (OIC) XSLT Map Studio

Generated OIC XSLT Map
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:ora="http://schemas.oracle.com/xpath/extension"
    xmlns:ns0="http://xmlns.oracle.com/apps/financials/orders"
    exclude-result-prefixes="xsl ns0">

    <xsl:output method="xml" indent="yes" encoding="UTF-8"/>

    <xsl:template match="/">
        <CreateOrderERPReq>
            <Header>
                <OrderID><xsl:value-of select="/PurchaseOrderReq/Header/ID"/></OrderID>
                <OrderDate><xsl:value-of select="/PurchaseOrderReq/Header/Date"/></OrderDate>
                <Status>SUBMITTED</Status>
            </Header>
            <Lines>
                <xsl:for-each select="/PurchaseOrderReq/LineItems/Item">
                    <LineItem>
                        <LineNumber><xsl:value-of select="position()"/></LineNumber>
                        <ItemSKU><xsl:value-of select="SKU"/></ItemSKU>
                        <Quantity><xsl:value-of select="Qty"/></Quantity>
                        <UnitPrice><xsl:value-of select="Price"/></UnitPrice>
                    </LineItem>
                </xsl:for-each>
            </Lines>
        </CreateOrderERPReq>
    </xsl:template>
</xsl:stylesheet>

Oracle Integration Cloud (OIC) XSLT Map Studio

Essential
4.94•210K Users•100% Client-Side Privacy
Unlimited Free

Generate XSLT 1.0 and 2.0 mapping templates for Oracle Integration Cloud integrations with schema loops and header mappings.

XSLT 2.0 template generatorOIC namespace mappingsFor-each row looping1-click XSL file copy

How to Use Oracle Integration Cloud (OIC) XSLT Map Studio

Follow these simple steps to process your files securely in browser memory.

1Step 1 of 3

Select Source & Target XML Schemas

Choose source payload schema and target OIC endpoint schema.

Pro Tip: OIC maps require explicit xmlns namespace declarations for Fusion ERP endpoints.
2Step 2 of 3

Configure Repeating Line Item Loops

Define repeating group XPath (e.g. /Invoice/InvoiceLines) and field mapping pairs.

Pro Tip: Use <xsl:for-each select="..."> to transform repeating purchase order line items.
3Step 3 of 3

Copy Production XSLT Map Template

Copy generated XSLT code directly into your OIC Integration Map editor or JDeveloper.

Pro Tip: Includes defensive <xsl:if test="normalize-space(...)"> guards against null values.

Who Is Oracle Integration Cloud (OIC) XSLT Map Studio Built For?

Designed for professionals seeking fast, private, and unlimited client-side execution.

Primary Target Audience
🎯Oracle Integration Cloud (OIC) Developers & Fusion Architects
Also Widely Used By
SOA Suite EngineersERP Technical Leads
Typical Real-World Use Cases
  • Generating OIC XSLT 1.0 and 2.0 mapping templates with namespace headers
  • Creating repeating line item for-each loops and conditional xsl:if mappings
  • Building copy-ready XSLT transformations for Oracle Fusion ERP payloads

OIC Namespace Compliant

Pre-configured headers for Oracle Fusion ERP APIs.

Repeating Group for-each Loops

Effortlessly transform invoice and order line arrays.

Defensive Null Value Guards

Includes normalize-space() checks to prevent transformation faults.

Frequently Asked Questions about Oracle Integration Cloud (OIC) XSLT Map Studio

Yes! Toggle between standard XSLT 1.0 (used in classic OIC mappers) and XSLT 2.0 functions (string-join, lower-case).
Top Search Queries for Oracle Integration Cloud (OIC) XSLT Map Studio:
oic xslt generator oracle integration cloudoracle fusion erp xslt mapping templateoic xslt 2.0 repeating line for each generatororacle soa suite xslt mapper in browseroic map code generator free