Wednesday, May 20, 2015

ETEXT Templates Example–How to define/Use CONCATENATION

In this post, let us see an example with CONCATENATION COMMAND

XML Input:


ETEXT Template





From Oracle Documentation

Define Concatenation Command

Use the define concatenation command to concatenate child-level extract elements for use in parent-level fields. For example, use this command to concatenate invoice number and due date for all the invoices belonging to a payment for use in a payment-level field.

The define concatenation command has three subcommands: base level, element, and delimiter.

Base Level Subcommand

The base level subcommand specifies the child level for the operation. For each parent-level instance, the concatenation operation loops through the child-level instances to generate the concatenated string.

Item Subcommand

The item subcommand specifies the operation used to generate each item. An item is a child-level expression that will be concatenated together to generate the concatenation string.

Delimiter Subcommand

The delimiter subcommand specifies the delimiter to separate the concatenated items in the string.

2 Responses to “ETEXT Templates Example–How to define/Use CONCATENATION”

Unknown said...
October 8, 2016 at 12:21 AM

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

Jone Martin said...
November 26, 2021 at 11:18 AM

Its informative blog. E-text launched different templates that use in database management. Likewise, I am give you offer to make your house beautiful through Remodeling Services Riverside CA. When you will need, we are available.

Post a Comment


The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.