About the xref:populateXRefRow1M Function

Two values in an end system can correspond to a single value in another system. In such a scenario, you should use the xref:populateXRefRow1M function to populate a cross reference column with a value. For example, as shown in Table 44-13, the SAP_001 and SAP_0011 values refer to one value of the EBS and SBL applications. To populate columns such as SAP, you can use the xref:populateXRefRow1M function.

Table 44-13 Cross Reference Table with Multiple Column Values

SAP EBS SBL

SAP	EBS	SBL
`SAP_001` `SAP_0011`	`EBS_1001`	`SBL001`
`SAP_002`	`EBS_1002`	`SBL002`

SAP_001

SAP_0011

EBS_1001

SBL001

SAP_002

EBS_1002

SBL002

The syntax of the xref:populateXRefRow1M function is shown in the following example:

xref:populateXRefRow1M(xrefLocation as string, xrefReferenceColumnName as string,
 xrefReferenceValue as string, xrefColumnName as string, xrefValue as string, mode
 as string) as string

Parameters

xrefLocation: The cross reference URI.
xrefReferenceColumnName: The name of the reference column.
xrefReferenceValue: The value corresponding to the reference column name.
xrefColumnName: The name of the column to be populated.
xrefValue: The value to be populated in the column.
mode: The mode in which the xref:populateXRefRow function populates the column. You can specify either of the following values: ADD or LINK. Table 44-14 describes these modes:

Table 44-14 xref:populateXRefRow1M Function Modes

Mode Description Exception Reasons

Mode	Description	Exception Reasons
`ADD`	Adds the reference value and the value to be added. For example, the following mode: xref:populateXRefRow1M("customers.xref"," EBS","EBS_1002", "SAP","SAP_0011","ADD") Adds the reference value `EBS_1002` in the reference column `EBS` and the value `SAP_0011` in the `SAP` column.	Exceptions can occur for the following reasons: The specified cross reference table is not found. The specified columns are not found. The values provided are empty. The value being added is not unique across that column for that table. The reference value exists.
`LINK`	Adds the cross reference value corresponding to the existing reference value. For example, the following mode: xref:populateXRefRow1M("customers.xref"," EBS","EBS_1002", "SAP","SAP_002","LINK") Links the value `SAP_002` in the `SAP` column to the `EBS_1002` value in the `EBS` column.	Exceptions can occur for the following reasons: The specified cross reference table is not found. The specified columns are not found. The values provided are empty. The reference value is not found. The value being added is not unique across the column for that table.

ADD

Adds the reference value and the value to be added.

For example, the following mode:

xref:populateXRefRow1M("customers.xref","
EBS","EBS_1002", "SAP","SAP_0011","ADD")

Adds the reference value EBS_1002 in the reference column EBS and the value SAP_0011 in the SAP column.

Exceptions can occur for the following reasons:

The specified cross reference table is not found.
The specified columns are not found.
The values provided are empty.
The value being added is not unique across that column for that table.
The reference value exists.

LINK

Adds the cross reference value corresponding to the existing reference value.

For example, the following mode:

xref:populateXRefRow1M("customers.xref","
EBS","EBS_1002", "SAP","SAP_002","LINK")

Links the value SAP_002 in the SAP column to the EBS_1002 value in the EBS column.

Exceptions can occur for the following reasons:

The specified cross reference table is not found.
The specified columns are not found.
The values provided are empty.
The reference value is not found.
The value being added is not unique across the column for that table.

Table 44-15 describes the xref:populateXRefRow1M function modes and exception conditions for these modes.

Table 44-15 xref:populateXRefRow1M Function Results with Different Modes

Mode Reference Value Value to be Added Result

Mode	Reference Value	Value to be Added	Result
`ADD`	`Absent` `Present` `Present`	`Absent` `Absent` `Present`	Success Exception Exception
`LINK`	`Absent` `Present` `Present`	`Absent` `Absent` `Present`	Exception Success Exception

ADD

Absent

Present

Absent

Present

Success

Exception

LINK

Absent

Present

Absent

Present

Exception

Success

Exception