Enterprise Data Manager Guide

6.4.3 HotFix 1
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3

Back Next

Specifying Translation Columns (Independent Archive)

Translation Columns, specified here are meant for Data Archive job executions containing Independent Archive.

In case of Independent Archive, Constraints as well as Data is exported, whereas for Database archive, only the Transaction Data is backed up to the History database.

A Column in a Table is a candidate for Translation when data needs to be extracted from a second Table based on a Referential integrity constraint.

Also, there might be circumstances where data is extracted from the first and a third Table based on similar Foreign key constraints, linking the first with second, and second with third Table. In such a case, the Column in the second Table is De-referenced to make way for displaying a Column in the third Table.

Column Translation occurs when two Tables participate in a JOIN. Columns are De-Referenced to include Constraints when more than two Tables are involved in data extraction through a JOIN query.

De-Referencing can be achieved from the “Columns” tab of the Details Pane for a Table.

The steps involved in specifying a Translation Column are summarized below:

Select the checkbox under “Translation” for that Column.

Application Version: “Oracle Apps 11.5.10”

Application Module: “AP Payables”

Entity: “AP_INV_APRVL_HIST_ALL”

Table: “AP_ENCUMBRANCE_LINES_ALL”

Name	Type	Private	Nullable	Translation
ENCUMBRANCE_TYPE_ID	NUMBER	False	False	True

When the Column
is selected for Translation
, the following information is displayed in its sub-pane:

Table Column	Constraint	Where Clause	Parent Table Alias	Ref Table Alias	Display Column	De-Reference
ENCUMBRANCE_TYPE_ID	AP_ENCUMBRANCE_LINES_FK3 (GL_ENCUMBRANCE_TYPES)		A	B	ENCUMBRANCE_TYPE	False

In case a third Table
is included in the JOIN, then the De
-Reference
checkbox beside the Column
(“ENCUMBERANCE_TYPE” in this example) must be checked and used to link it to a third Table
. The Column
for a De
-Reference
must also participate in a Referential Integrity constraint.

Rename Saved Search

Table of Contents

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Specifying Translation Columns (Independent Archive)

Specifying Translation Columns (Independent Archive)