When you import a target definition with a primary key, link the primary key in the source definition to the primary key and GPK column in the target definition. Link the foreign key in the source definition to the foreign key and GFK column in the target definition.

For example, your organization outsources its claim operations. Each claim is associated with the claim detail that contains transaction details, such as product details, price, and, unit of measurement. A claim can have multiple claim lines if it is tied to multiple offers.

Because claims are associated with multiple claim lines, the weekly claim information involves two data sources. One data source contains information about all the claims, such as customer name and claim amount. The other data source contains claim line information for each claim, such as product details.

For this business case, Oracle E-Business Suite provides the Import Claims Interface to import the claims. The Import Claims Interface has the following interface tables:

To identify the details of each claim, a primary key-foreign key relationship exists for both data sources. For example, you can use CLAIM_ID as the primary key for claim and CLAIM_LINE_ID as the primary key for claim lines.

You load claims from your CRM system to Oracle E-Business Suite. To map the primary key-foreign key relation to an open interface, the Designer defines a primary key column in the Open Interface Parameter group of the E-Business Suite target definition. The Designer also defines primary and foreign key columns in other groups of the target definition. These columns define the relationship between different data sources.

The other two groups in the target definition are the data groups that correspond to the interface tables.

The following figure shows an example of a GPK-GFK relationship:

In this example, sources provide input to the open interface. Each source definition corresponds to a group in the target definition. One source definition provides input data to the Open Interface Parameter group. The other two source definitions provide input data to the data groups.

The INTERFACE_CLAIM_ID column is the primary key in the OZF_CLAIM_LINES_INT_ALL source definition. It is linked to the INTERFACE_CLAIM_ID column and to the GFK_OZF_CLAIM_LINES_INT_ALL column of the OZF_CLAIM_LINES_INT_ALL group. The INTERFACE_CLAIM_ID column is the primary key of the OZF_CLAIMS_INT_ALL source definition. It is linked to the INTERFACE_CLAIM_ID column and to the GPK_OZF_CLAIM_LINES_INT_ALL column of the OZF_CLAIMS_INT_ALL group.