[Home] [Help] [Dependency Information]
Object Name: | HZ_IMP_BATCH_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_IMP_BATCH_SUMMARY |
Subobject Name: | |
Status: | VALID |
The HZ_IMP_BATCH_SUMMARY table stores information about import batches which contain a set of records to be imported from the interface tables into the TCA Registry. The table includes information on the processes that the user chooses to perform on the import batch, such as duplicate identification, import preview, actions to take on duplicate records, and so on. The table also stores information about batches of records purged from the interface tables
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_IMP_BATCH_SUMMARY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | Interface batch identifier |
BATCH_NAME | VARCHAR2 | (255) | Yes | Batch name |
DESCRIPTION | VARCHAR2 | (1996) | Batch description | |
EST_NO_OF_RECORDS | NUMBER | Estimated number of records in the batch as entered by the user | ||
ORIGINAL_SYSTEM | VARCHAR2 | (30) | Yes | Original source system for the batch data |
LOAD_TYPE | VARCHAR2 | (30) | Type of load.CSV for CSV file load, DNB for D&B batch load, or SQL load, withvalue entered by the user. | |
BATCH_DEDUP_FLAG | VARCHAR2 | (1) | Y or N indicates whether duplicate identification within the batch will be performed or not. | |
BATCH_DEDUP_MATCH_RULE_ID | NUMBER | (15) | Identifier of the match rule to be used for duplicate identification within the batch | |
BD_ACTION_ON_PARTIES | VARCHAR2 | (30) | Action to take by duplicate identification within the batch for duplicate parties. Validated against lookup HZ_IMP_BATCH_DEDUP_ACTIONS | |
BD_ACTION_ON_ADDRESSES | VARCHAR2 | (30) | Action to take by duplicate identification within the batch for duplicate addresses. Validated against lookup HZ_IMP_BATCH_DEDUP_ACTIONS | |
BD_ACTION_ON_CONTACTS | VARCHAR2 | (30) | Action to take by duplicate identification within the batch for duplicate contacts. Validated against lookup HZ_IMP_BATCH_DEDUP_ACTIONS | |
BD_ACTION_ON_CONTACT_POINTS | VARCHAR2 | (30) | Action to take by duplicate identification within the batch for duplicate contact points. Validated against lookup HZ_IMP_BATCH_DEDUP_ACTIONS | |
ADDR_VAL_FLAG | VARCHAR2 | (1) | Y or N indicates whether address validation will be performed or not. | |
REGISTRY_DEDUP_FLAG | VARCHAR2 | (1) | Y or N indicates whether duplicate identification between the interface tables and the TCA Registry will be performed or not | |
REGISTRY_DEDUP_MATCH_RULE_ID | NUMBER | (15) | Identifier of the match rule to be used for duplicate identification between the interface tables and the TCA Registry | |
REMOVE_DUPS_FLAG | VARCHAR2 | (1) | Y or N indicates whether duplicates will be removed by the duplicate identification between the interface tables and the TCA Registry | |
ERROR_LIMIT | NUMBER | User-definedError limit, after which the batch will fail | ||
VALIDATE_FLEXFIELD_FLAG | VARCHAR2 | (1) | Y or N indicates whether flexfields should be validated during import or not | |
WHAT_IF_FLAG | VARCHAR2 | (1) | Y or N indicates whether or not the user wants to stop the process before the data is loaded into TCA and evaluate the results | |
RD_ACTION_NEW_PARTIES | VARCHAR2 | (30) | Action to perform on new parties loaded into TCA | |
RD_ACTION_EXISTING_PARTIES | VARCHAR2 | (30) | Action to perform for records identified as existing parties in the TCA Registry | |
RD_ACTION_DUP_PARTIES | VARCHAR2 | (30) | Action to take by duplicate identification between the interface tables and the TCA Registry for duplicate parties that cross the automatic merge threshold. Validated against lookup HZ_IMP_REGISTRY_DEDUP_ACTIONS | |
RD_ACTION_POT_DUP_PARTIES | VARCHAR2 | (30) | Action to take by duplicate identification between the interface tables and the TCA Registry for duplicate parties that did not cross the automatic merge threshold. Validated against lookup HZ_IMP_REGISTRY_DEDUP_ACTIONS | |
RD_ACTION_NEW_ADDRS | VARCHAR2 | (30) | Action to take on new addresses loaded into TCA | |
RD_ACTION_EXISTING_ADDRS | VARCHAR2 | (30) | Action to take for records identified as existing addresses in the TCA Registry | |
RD_ACTION_POT_DUP_ADDRS | VARCHAR2 | (30) | Action to take by duplicate identification between the interface tables and the TCA Registry for duplicate addresses that did not cross the automatic merge threshold. Validated against lookup HZ_IMP_REGISTRY_DEDUP_ACTIONS. | |
RD_ACTION_NEW_CONTACTS | VARCHAR2 | (30) | Action to take on new contacts loaded into TCA | |
RD_ACTION_EXISTING_CONTACTS | VARCHAR2 | (30) | Action to take for records t identified as existing contacts in the TCA Registry | |
RD_ACTION_POT_DUP_CONTACTS | VARCHAR2 | (30) | Action to take by duplicate identification between the interface tables and the TCA Registry for duplicate contacts that did not cross the automatic merge threshold. Validated against lookup HZ_IMP_REGISTRY_DEDUP_ACTIONS | |
RD_ACTION_NEW_CPTS | VARCHAR2 | (30) | Action to take on new contact points loaded into TCA | |
RD_ACTION_EXISTING_CPTS | VARCHAR2 | (30) | Action to take for records identified as existing contact points in the TCA Registry | |
RD_ACTION_POT_DUP_CPTS | VARCHAR2 | (30) | Action to take by duplicate identification between the interface tables and the TCA Registry for duplicate contact points that did not cross the automatic merge threshold. Validated against lookup HZ_IMP_REGISTRY_DEDUP_ACTIONS | |
RD_ACTION_NEW_SUPENTS | VARCHAR2 | (30) | Action to take on new records for supporting entities such as Classifications, Relationships, Contact Roles, and Address Uses | |
RD_ACTION_EXISTING_SUPENTS | VARCHAR2 | (30) | Action to take for records identified as existing records in the TCA Registry for supporting entities such as Classifications, Relationships, Contact Roles and Address Uses | |
RD_ACTION_NEW_FINENTS | VARCHAR2 | (30) | Action to take on new records for supporting entities such as Credit Ratings, Financial Reports and Financial Numbers | |
RD_ACTION_EXISTING_FINENTS | VARCHAR2 | (30) | Action to take for records identified as existing records in the TCA Registry for supporting entities such as Credit Ratings, Financial Reports and Financial Numbers | |
BATCH_DEDUP_STATUS | VARCHAR2 | (30) | Status for the duplicate identification within batch concurrent program | |
ADDR_VAL_STATUS | VARCHAR2 | (30) | Status for the address validation concurrent program | |
IMPORT_STATUS | VARCHAR2 | (30) | Status for the data load concurrent program | |
CSV_STATUS | VARCHAR2 | (30) | Status for the CSV load concurrent program | |
BATCH_STATUS | VARCHAR2 | (30) | Overall status of the batch. Active, Purged, or Rejected | |
MAIN_CONC_STATUS | VARCHAR2 | (30) | Status for the central concurrent program. The central concurrent program calls the other concurrent programs above | |
BATCH_DEDUP_REQ_ID | NUMBER | (15) | Request identifier for the duplicate identification within batch concurrent program | |
ADDR_VAL_REQ_ID | NUMBER | (15) | Request identifier for the address validation concurrent program | |
IMPORT_REQ_ID | NUMBER | (15) | Request identifier for the data load concurrent program | |
CSV_LOAD_REQ_ID | NUMBER | (15) | Request identifier for the CSV load concurrent program | |
MAIN_CONC_REQ_ID | NUMBER | (15) | Request identifier for the central concurrent program | |
CSV_LOAD_ID | NUMBER | (15) | CSV File Load Identifier. Foreign Key to IMC_CSV_LOAD_SUMMARY | |
PURGE_DATE | DATE | Date on which the batch was purged | ||
PURGED_BY_USER_ID | NUMBER | (15) | Identifier of the user who purged the batch | |
TOTAL_BATCH_RECORDS | NUMBER | Total records in batch | ||
PARTIES_IN_BATCH | NUMBER | Total parties in batch | ||
ADDRESSES_IN_BATCH | NUMBER | Total addresses in batch | ||
ADDRESSUSES_IN_BATCH | NUMBER | Total address uses in batch | ||
CONTACTPOINTS_IN_BATCH | NUMBER | Total contact points in batch | ||
CONTACTS_IN_BATCH | NUMBER | Total contacts in batch | ||
CONTACTROLES_IN_BATCH | NUMBER | Total contact roles in batch | ||
CODEASSIGNS_IN_BATCH | NUMBER | Total classifications in batch | ||
RELATIONSHIPS_IN_BATCH | NUMBER | Total relationships in batch | ||
CREDITRATINGS_IN_BATCH | NUMBER | Total credit ratings in batch | ||
FINREPORTS_IN_BATCH | NUMBER | Total financials reports in batch | ||
FINNUMBERS_IN_BATCH | NUMBER | Total financial numbers in batch | ||
REMOVED_BY_USER | NUMBER | Number of records removed by user | ||
TOTAL_RECORDS_FOR_IMPORT | NUMBER | Total records for import | ||
DUP_PARTIES_IN_BATCH | NUMBER | Duplicate party records in batch | ||
DUP_ADDRESSES_IN_BATCH | NUMBER | Duplicate address records in batch | ||
DUP_CONTACTPOINTS_IN_BATCH | NUMBER | Duplicate contact point records in batch | ||
DUP_CONTACTS_IN_BATCH | NUMBER | Duplicate contact records in batch | ||
PARTY_DUP_SETS_IN_BATCH | NUMBER | Duplicate sets of parties in batch | ||
ADDRESS_DUP_SETS_IN_BATCH | NUMBER | Duplicate sets of addresses in batch | ||
CONTACTPOINT_DUP_SETS_IN_BATCH | NUMBER | Duplicate sets of contact points in batch | ||
CONTACT_DUP_SETS_IN_BATCH | NUMBER | Duplicate sets of contacts in batch | ||
NEW_UNIQUE_PARTIES | NUMBER | New and unique parties | ||
POTENTIAL_DUP_PARTIES | NUMBER | Potential duplicate parties | ||
DUP_PARTIES | NUMBER | Duplicate parties | ||
EXISTING_PARTIES | NUMBER | Existing parties | ||
NEW_UNIQUE_ADDRESSES | NUMBER | New and unique addresses | ||
POTENTIAL_DUP_ADDRESSES | NUMBER | Potential duplicate addresses | ||
EXISTING_ADDRESSES | NUMBER | Existing addresses | ||
NEW_UNIQUE_CONTACTPOINTS | NUMBER | New and unique contact points | ||
POTENTIAL_DUP_CONTACTPOINTS | NUMBER | Potential duplicate contact points | ||
EXISTING_CONTACTPOINTS | NUMBER | Existing contact points | ||
NEW_UNIQUE_CONTACTS | NUMBER | New and unique contacts | ||
POTENTIAL_DUP_CONTACTS | NUMBER | Potential duplicate contacts | ||
EXISTING_CONTACTS | NUMBER | Existing contacts | ||
NEW_UNIQUE_ADDRESSUSES | NUMBER | New and unique address uses | ||
EXISTING_ADDRESSUSES | NUMBER | Existing address uses | ||
NEW_UNIQUE_CONTACTROLES | NUMBER | New and unique contact roles | ||
EXISTING_CONTACTROLES | NUMBER | Existing contact roles | ||
NEW_UNIQUE_CODEASSIGNS | NUMBER | New and unique classifications | ||
EXISTING_CODEASSIGNS | NUMBER | Existing classifications | ||
NEW_UNIQUE_RELATIONSHIPS | NUMBER | New and unique relationships | ||
EXISTING_RELATIONSHIPS | NUMBER | Existing relationships | ||
NEW_UNIQUE_FINREPORTS | NUMBER | New and unique financial reports | ||
EXISTING_FINREPORTS | NUMBER | Existing financial reports | ||
NEW_UNIQUE_FINNUMBERS | NUMBER | New and unique financial numbers | ||
EXISTING_FINNUMBERS | NUMBER | Existing financial numbers | ||
NEW_UNIQUE_CREDITRATINGS | NUMBER | New and unique credit ratings | ||
EXISTING_CREDITRATINGS | NUMBER | Existing credit ratings | ||
TOTAL_RECORDS_IMPORTED | NUMBER | Total records imported | ||
TOTAL_ERRORS | NUMBER | Total errors | ||
PARTIES_FULLY_IMPORTED | NUMBER | Parties fully imported | ||
PARTIES_PARTIALLY_IMPORTED | NUMBER | Parties partially imported | ||
TOTAL_PERSONS_IMPORTED | NUMBER | Total persons imported | ||
TOTAL_ORGANIZATIONS_IMPORTE | NUMBER | Total organizations imported | ||
TOTAL_INSERTS | NUMBER | Total records inserted | ||
TOTAL_UPDATES | NUMBER | Total records updated | ||
TOTAL_MERGE_REQUESTS | NUMBER | Total records with merge requested | ||
TOTAL_AUTO_MERGED | NUMBER | Total records automatically merged | ||
PARTIES_INSERTED | NUMBER | Total parties inserted | ||
ADDRESSES_INSERTED | NUMBER | Total addresses inserted | ||
ADDRESSUSES_INSERTED | NUMBER | Total address uses inserted | ||
CONTACTPOINTS_INSERTED | NUMBER | Total contact points inserted | ||
CONTACTS_INSERTED | NUMBER | Total contacts inserted | ||
CONTACTROLES_INSERTED | NUMBER | Total contact roles inserted | ||
CODEASSIGNS_INSERTED | NUMBER | Total classifications inserted | ||
RELATIONSHIPS_INSERTED | NUMBER | Total relationships inserted | ||
CREDITRATINGS_INSERTED | NUMBER | Total credit ratings inserted | ||
FINREPORTS_INSERTED | NUMBER | Total financial reports inserted | ||
FINNUMBERS_INSERTED | NUMBER | Total financial numbers inserted | ||
PARTIES_UPDATED | NUMBER | Total parties updated | ||
ADDRESSES_UPDATED | NUMBER | Total addresses updated | ||
ADDRESSUSES_UPDATED | NUMBER | Total address uses updated | ||
CONTACTPOINTS_UPDATED | NUMBER | Total contact points updated | ||
CONTACTS_UPDATED | NUMBER | Total contacts updated | ||
CONTACTROLES_UPDATED | NUMBER | Total contact roles updated | ||
CODEASSIGNS_UPDATED | NUMBER | Total classifications updated | ||
RELATIONSHIPS_UPDATED | NUMBER | Total relationships updated | ||
CREDITRATINGS_UPDATED | NUMBER | Total credit ratings updated | ||
FINREPORTS_UPDATED | NUMBER | Total financial reports updated | ||
FINNUMBERS_UPDATED | NUMBER | Total financial numbers updated | ||
PARTY_MERGE_REQUESTS | NUMBER | Total parties with merge requested | ||
ADDRESS_MERGE_REQUESTS | NUMBER | Total addresses with merge requested | ||
CONTACTPOINT_MERGE_REQUESTS | NUMBER | Total contact points with merge requested | ||
CONTACT_MERGE_REQUESTS | NUMBER | Total contacts with merge requested | ||
PARTIES_AUTO_MERGED | NUMBER | Total parties automatically merged | ||
PARTIES_IMPORTED | NUMBER | Total parties imported | ||
ADDRESSES_IMPORTED | NUMBER | Total addresses imported | ||
ADDRESSUSES_IMPORTED | NUMBER | Total address uses imported | ||
CONTACTPOINTS_IMPORTED | NUMBER | Total contact points imported | ||
CONTACTS_IMPORTED | NUMBER | Total contacts imported | ||
CONTACTROLES_IMPORTED | NUMBER | Total contact roles imported | ||
CODEASSIGNS_IMPORTED | NUMBER | Total classifications imported | ||
RELATIONSHIPS_IMPORTED | NUMBER | Total relationships imported | ||
CREDITRATINGS_IMPORTED | NUMBER | Total credit ratings imported | ||
FINREPORTS_IMPORTED | NUMBER | Total financial reports imported | ||
FINNUMBERS_IMPORTED | NUMBER | Total financial numbers imported | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
REQUEST_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
NUM_PARTIES_PURCHASED | NUMBER | Number of parties purchased for batch loading | ||
AUTOMERGE_FLAG | VARCHAR2 | (1) | Indicates whether batch was run via Automerge. Y for yes, N or null for no |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BATCH_NAME
, DESCRIPTION
, EST_NO_OF_RECORDS
, ORIGINAL_SYSTEM
, LOAD_TYPE
, BATCH_DEDUP_FLAG
, BATCH_DEDUP_MATCH_RULE_ID
, BD_ACTION_ON_PARTIES
, BD_ACTION_ON_ADDRESSES
, BD_ACTION_ON_CONTACTS
, BD_ACTION_ON_CONTACT_POINTS
, ADDR_VAL_FLAG
, REGISTRY_DEDUP_FLAG
, REGISTRY_DEDUP_MATCH_RULE_ID
, REMOVE_DUPS_FLAG
, ERROR_LIMIT
, VALIDATE_FLEXFIELD_FLAG
, WHAT_IF_FLAG
, RD_ACTION_NEW_PARTIES
, RD_ACTION_EXISTING_PARTIES
, RD_ACTION_DUP_PARTIES
, RD_ACTION_POT_DUP_PARTIES
, RD_ACTION_NEW_ADDRS
, RD_ACTION_EXISTING_ADDRS
, RD_ACTION_POT_DUP_ADDRS
, RD_ACTION_NEW_CONTACTS
, RD_ACTION_EXISTING_CONTACTS
, RD_ACTION_POT_DUP_CONTACTS
, RD_ACTION_NEW_CPTS
, RD_ACTION_EXISTING_CPTS
, RD_ACTION_POT_DUP_CPTS
, RD_ACTION_NEW_SUPENTS
, RD_ACTION_EXISTING_SUPENTS
, RD_ACTION_NEW_FINENTS
, RD_ACTION_EXISTING_FINENTS
, BATCH_DEDUP_STATUS
, ADDR_VAL_STATUS
, IMPORT_STATUS
, CSV_STATUS
, BATCH_STATUS
, MAIN_CONC_STATUS
, BATCH_DEDUP_REQ_ID
, ADDR_VAL_REQ_ID
, IMPORT_REQ_ID
, CSV_LOAD_REQ_ID
, MAIN_CONC_REQ_ID
, CSV_LOAD_ID
, PURGE_DATE
, PURGED_BY_USER_ID
, TOTAL_BATCH_RECORDS
, PARTIES_IN_BATCH
, ADDRESSES_IN_BATCH
, ADDRESSUSES_IN_BATCH
, CONTACTPOINTS_IN_BATCH
, CONTACTS_IN_BATCH
, CONTACTROLES_IN_BATCH
, CODEASSIGNS_IN_BATCH
, RELATIONSHIPS_IN_BATCH
, CREDITRATINGS_IN_BATCH
, FINREPORTS_IN_BATCH
, FINNUMBERS_IN_BATCH
, REMOVED_BY_USER
, TOTAL_RECORDS_FOR_IMPORT
, DUP_PARTIES_IN_BATCH
, DUP_ADDRESSES_IN_BATCH
, DUP_CONTACTPOINTS_IN_BATCH
, DUP_CONTACTS_IN_BATCH
, PARTY_DUP_SETS_IN_BATCH
, ADDRESS_DUP_SETS_IN_BATCH
, CONTACTPOINT_DUP_SETS_IN_BATCH
, CONTACT_DUP_SETS_IN_BATCH
, NEW_UNIQUE_PARTIES
, POTENTIAL_DUP_PARTIES
, DUP_PARTIES
, EXISTING_PARTIES
, NEW_UNIQUE_ADDRESSES
, POTENTIAL_DUP_ADDRESSES
, EXISTING_ADDRESSES
, NEW_UNIQUE_CONTACTPOINTS
, POTENTIAL_DUP_CONTACTPOINTS
, EXISTING_CONTACTPOINTS
, NEW_UNIQUE_CONTACTS
, POTENTIAL_DUP_CONTACTS
, EXISTING_CONTACTS
, NEW_UNIQUE_ADDRESSUSES
, EXISTING_ADDRESSUSES
, NEW_UNIQUE_CONTACTROLES
, EXISTING_CONTACTROLES
, NEW_UNIQUE_CODEASSIGNS
, EXISTING_CODEASSIGNS
, NEW_UNIQUE_RELATIONSHIPS
, EXISTING_RELATIONSHIPS
, NEW_UNIQUE_FINREPORTS
, EXISTING_FINREPORTS
, NEW_UNIQUE_FINNUMBERS
, EXISTING_FINNUMBERS
, NEW_UNIQUE_CREDITRATINGS
, EXISTING_CREDITRATINGS
, TOTAL_RECORDS_IMPORTED
, TOTAL_ERRORS
, PARTIES_FULLY_IMPORTED
, PARTIES_PARTIALLY_IMPORTED
, TOTAL_PERSONS_IMPORTED
, TOTAL_ORGANIZATIONS_IMPORTE
, TOTAL_INSERTS
, TOTAL_UPDATES
, TOTAL_MERGE_REQUESTS
, TOTAL_AUTO_MERGED
, PARTIES_INSERTED
, ADDRESSES_INSERTED
, ADDRESSUSES_INSERTED
, CONTACTPOINTS_INSERTED
, CONTACTS_INSERTED
, CONTACTROLES_INSERTED
, CODEASSIGNS_INSERTED
, RELATIONSHIPS_INSERTED
, CREDITRATINGS_INSERTED
, FINREPORTS_INSERTED
, FINNUMBERS_INSERTED
, PARTIES_UPDATED
, ADDRESSES_UPDATED
, ADDRESSUSES_UPDATED
, CONTACTPOINTS_UPDATED
, CONTACTS_UPDATED
, CONTACTROLES_UPDATED
, CODEASSIGNS_UPDATED
, RELATIONSHIPS_UPDATED
, CREDITRATINGS_UPDATED
, FINREPORTS_UPDATED
, FINNUMBERS_UPDATED
, PARTY_MERGE_REQUESTS
, ADDRESS_MERGE_REQUESTS
, CONTACTPOINT_MERGE_REQUESTS
, CONTACT_MERGE_REQUESTS
, PARTIES_AUTO_MERGED
, PARTIES_IMPORTED
, ADDRESSES_IMPORTED
, ADDRESSUSES_IMPORTED
, CONTACTPOINTS_IMPORTED
, CONTACTS_IMPORTED
, CONTACTROLES_IMPORTED
, CODEASSIGNS_IMPORTED
, RELATIONSHIPS_IMPORTED
, CREDITRATINGS_IMPORTED
, FINREPORTS_IMPORTED
, FINNUMBERS_IMPORTED
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, NUM_PARTIES_PURCHASED
, AUTOMERGE_FLAG
FROM AR.HZ_IMP_BATCH_SUMMARY;
AR.HZ_IMP_BATCH_SUMMARY does not reference any database object
AR.HZ_IMP_BATCH_SUMMARY is referenced by following:
|
|
|