Enterprise Data Manager Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 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 the case of Independent Archive, constraints and data are exported. 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 must be extracted from a second table based on a referential integrity constraint.

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.

You can perform de-referencing from the

Columns

tab of the Details pane for a table.

The following steps are involved in specifying a Translation Column:

Select the check box 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:

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

If a third table is included in the JOIN, the

De-Reference

check box 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.

Business Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Specifying Translation Columns (Independent Archive)

Specifying Translation Columns (Independent Archive)