A
Transformations

This appendix provides a list of the Oracle Applications InterConnect transformations.

Copy Fields

Copy the source field(s) into the destination field(s).

Parameters:

None

Copy Object

Copy the source object into the destination object

Parameters:

None

Concat Fields

Concatenate the source field(s) and copy it into the destination field

Parameters:

prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

Expand Fields

Expand the source field into the destination fields.

Parameters:

delimiter

The delimiter or string of characters around which the source field should be broken up.

Set Constant

Copy a constant into the destination fields.

Parameters:

constant

The constant to be copied.

True Conditional Lookup XRef

Lookup the source field in a cross reference table. If condition is satisfied, copy it into the destination field.

Parameters:

condition	The condition for this parameter.
table	The cross reference table.
pass through	When there is no corresponding cross reference, and this parameter is true, the destination field is set to the source field. If this parameter is false, the destination field is set to null.

True Conditional Lookup DVM

Lookup the source field in a domain value map table. If condition is satisfied, copy it into the destination field.

Parameters:

condition	The condition for this parameter.
table	The domain value map table.
pass through	When there is no corresponding domain value map and this parameter is set to true, the destination field is set to the source field. If this parameter is set to false, the destinations field is set to null.

Conditional Copy

Copy the source field(s) into the destination field(s) if expression is satisfied.

Parameters:

expression	The expression.
only copy on true	If this parameter is set to true and the expression evaluates to false, nothing is copied. If this parameter is set to false and the expression evaluates to false, the second input object is copied.

True Conditional Copy

Copy the source field(s) into the destination field(s) if condition is satisfied.

Parameters:

condition

The condition for this parameter.

True Conditional Concat

Concatenate the source field(s) into the destination field if the condition is satisfied.

Parameters:

condition	The condition for this parameter.
prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

True Conditional To Number

Convert the sign, value, and precision source fields into a number and copy it into the destination field if condition is satisfied.

Parameters:

condition	The condition for this parameter.
int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.
DVM	An optional domain value map to lookup decimal point character.

False Conditional Copy

Copy the source field(s) into the destination field(s) if condition is NOT satisfied.

Parameters:

condition

The condition for this parameter.

False Conditional Concat

Concatenate the source field(s) into the destination field if the condition is NOT satisfied.

Parameters:

condition	The condition for this parameter.
prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

False Conditional To Number

Convert the sign, value, and precision source fields into a number and copy it into the destination field if condition is NOT satisfied.

Parameters:

condition	The condition for this parameter.
int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.
DVM	An optional domain value map to lookup decimal point character.

To Number

Convert the sign, value, and precision source fields into a number and copy it into the destination field.

Parameters:

int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.
DVM	An optional domain value map to lookup decimal point character.

`

Copy a substring of the source field into the destination field.

Parameters:

begin index	The index at which the substring begins.
length	An optional length of the substring.

Char Replace

Replace characters in the source field and copy it into the destination field.

Parameters:

targets	The string of characters to replace.
replacements	The string of replacement characters.

String Replace

Replace each occurrence of a string in the source field and copy it into the destination field.

Parameters:

targets	The string of characters to replace.
replacements	The string of replacement characters.

LTrim

Delete source field characters starting from the left until a character from the set is found and copy the remaining string into the destination field.

Parameters:

characters

The string of characters to seek that stop the deletion.

RTrim

Delete source field characters starting from the right until a character from the set is found and copy the remaining string into the destination field.

Parameters:

characters

The string of characters to seek that stop the deletion.

LPad

Pad source field starting from the left for a given length and copy it into the destination field.

Parameters:

length	The padding length.
character	An optional character to pad with, default is <space>.

RPad

Pad source field starting from the right for a given length and copy it into the destination field.

Parameters:

length	The padding length.
character	An optional character to pad with, default is <space>.

Lookup XRef

Lookup the source field in a cross reference table and copy it into the destination field.

Parameters:

table	The cross reference table.
pass through	When there is no corresponding cross reference and this parameter is set to true, the destination field is set to the source field. If this parameter is set to false, the destination field is set to null.

Delete XRef

Delete the source field from a cross reference table.

Parameters:

table

The cross reference table.

Lookup DVM

Lookup the source field in a domain value map table and copy it into the destination field.

Parameters:

table	The cross reference table.
pass through	When there is no corresponding domain value map and this parameter is set to true, the destination field is set to the source field. If this parameter is set to false, the destination field is set to null.

Truncate

Truncate source field starting from the right for a given length and copy it into the destination field.

Parameters:

length

The length to truncate.

Increment

Increment a counter and copy the incremented value into the destination field.

Parameters:

start value	The initial counter value.
counter	Give this counter a name to distinguish it from other counters that may be at different values at a given time and may have a different step size.
step size	The increment size.