DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.HZ_IMP_DUP_PARTIES

Object Details
Object Name: HZ_IMP_DUP_PARTIES
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_IMP_DUP_PARTIES
Subobject Name:
Status: VALID


This table holds the ID's of the parties that matched the given match rule criteria, along with their scores, and if any party crossed the auto merge threshold and should be auto merged.
The HZ_IMP_DUP_PARTIES table stores the identifiers and scores of parties, being loaded by TCA import, that match an existing party in the TCA Registry using the given Data Quality Management match rule criteria. The table also includes information about any party with scores that exceed the automatic merge threshold, which means that the party should be automatically merged with its duplicates.
The match rule is applied to resolve duplicates within the interface tables, or between the interface tables and the TCA Registry, before you import the records from the interface tables into the TCA Registry.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_IMP_DUP_PARTIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPARTY_ID
ColumnDUP_PARTY_ID
ColumnSCORE
HZ_IMP_DUP_PARTIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPARTY_OSR
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Interface batch identifier
PARTY_OSR VARCHAR2 (255) Yes Source identifier of party in the interface tables
PARTY_OS VARCHAR2 (30) Yes Source system of party in the interface tables
PARTY_ID NUMBER (15) Yes Foreign key to HZ_IMP_PARTIES_SG
DUP_PARTY_ID NUMBER (15) Yes Party identifier of duplicate party in TCA
SCORE NUMBER

Match score
AUTO_MERGE_FLAG VARCHAR2 (1)
Indicates whether the duplicate party will be automatically merged with the winner party. Y. Automatically merge DUP_PARTY_ID with PARTY_ID.S. Create System Duplicate Identification batches.N. Do neither if multiple duplicates are found and one of them is being automatically merged. The others should be marked N. R. Remove the party from the batch.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      PARTY_OSR
,      PARTY_OS
,      PARTY_ID
,      DUP_PARTY_ID
,      SCORE
,      AUTO_MERGE_FLAG
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
FROM AR.HZ_IMP_DUP_PARTIES;

Dependencies

[top of page]

AR.HZ_IMP_DUP_PARTIES does not reference any database object

AR.HZ_IMP_DUP_PARTIES is referenced by following:

SchemaAPPS
SynonymHZ_IMP_DUP_PARTIES