Index

A

adapters
  address validation link
  preimport address validation link

address corrections link link
address formatting link
  process link

address styles
  description link

address uses
  import interface tables and TCA tables link

address validation link link
   See also batch address validation
   See also real-time address validation
  description link link
  in Bulk Import link

Address Validation program
  description link
  parameters link

addresses
  entering and formatting process link
  entering and real-time validation process link
  formatting link
  import interface tables and TCA tables link
  mapping for Bulk Import link
  validating in batch link
  validating in real time link

as of date
  relationship hierarchy link

attributes
  description link

Automerge
  Registry de-duplication link link

B

batch address validation link
batch de-duplication
  description link

batch duplicate identification
  defining and submitting duplicate identification batches link
  overview link
  process link
  reviewing duplicates and creating merge batches link
  submitting merge batches link

batch IDs
  creating for import batches link

BIR link
   See Business Information Report

Bulk Import link link
   See also Import Batch to TCA Registry
   See also interface tables
  overview link
  process link

Business Information Report (BIR)
  description link
  purchasing link
  viewing link

Business Verification Global Data Product link

C

CDH link
   See Oracle Customer Data Hub (CDH)

CDL link
   See Oracle Customer Data Librarian (CDL)

CDM link
   See Oracle Customer Data Management (CDM)

circular relationships
  description link

classifications
  import interface tables and TCA tables link

combining
  customer merge link

Commercial Credit Score (USA) Global Data Product link
contact link
contact points
  description link
  import interface tables and TCA tables link

contact roles
  import interface tables and TCA tables link

contacts
  description link
  import interface tables and TCA tables link
  merging organization contacts link

Create Import Batch API link
Create Merge Batch program
  description link
  parameter link

credit ratings
  import interface tables and TCA tables link

customer link
customer account link
Customer Account Merge link
   See Customer Merge

customer account sites
  description link
  merging link

customer accounts
  description link
  entering and maintaining link
  merging link
  reports link

Customer Interface
  creating unique customer references link
  data required link
  import program link
  importing customers link
  overview link
  preparing to run link
  sample import link
  source IDs of associated parties link
  tables updated link
  transfer report link
  using with Bulk Import link
  validation rules link

Customer Listing - Detail link
Customer Listing - Summary link
Customer Merge
  description link link
  example with Party Merge link
  execution report link
  merging customers link
  merging different customers link
  merging sites for same customer link
  reviewing merged customers link
  submitting link

Customer Profiles Report link
Customer Relationships Listing link
customers
  description link
  entering and maintaining link
  importing link
  reports link

Customers set of pages
  process flow link
  usage link

D

D&B
  automatically correcting values from link
  batch loading provided files link
  contact information link
  description link
   See also Third Party Data Integration
  investigations link
  mapping of data elements link
  Party Merge impact link
  rationalizing legacy data link
  transferring request list to link
  viewing information link

D&B batch loading
  generating request list link
  loading data into interface tables link
  overview link
  process overview link
  request list link
  transferring request list to D&B link

D&B File Load - Pass 1 program
  parameters link

D&B Flat File Upload Table Creation program
  parameters link

D&B hierarchy
  Enterprise Management GDP link
  examples link
  postimport processes link
  viewing link

D&B Import Adapter request set
  description link
  impact on Import Batch to TCA Registry link
  impact on other data loads link
  parameters link
  prerequisites link

D&B load link
   See D&B batch loading

D&B Rating
  definition link

D-U-N-S Numbers
  definition link
  Enquiry link
  mapped link
  related parties link
  same as related D-U-N-S Number link
  viewing duplicates link

data elements
  description link
  mapping link
  request list for D&B batch loading link

data products
  overview link
  purchasing link

Data Sharing and Security (DSS)
  using for Bulk Import link

data sources
  viewing information from link

Decision Support Global Data Product link
Delinquency Score Global Data Product link
description link
DNB Global Data Products Request report
  description link
  parameters link

DQM Batch Duplicate Identification program
  description link
  reviewing results link

DSS link
   See Data Sharing and Security (DSS)

duplicate checking
  determining merge or transfer link

Duplicate Customer Report link
Duplicate DUNS report
  description link
  parameters link

duplicate identification batches
  defining and submitting link
  reviewing potential duplicates link

duplicate parties
  identifying in TCA Registry link link
  merging link

duplicate party sites
  merging link

E

eLocations Spatial Data Integration
  overview link

Enquiry D-U-N-S Number link
Enterprise Management Global Data Product link
entities
  description link link

error tables
  purging link

errors
  Bulk Import link
  Customer Interface Transfer report link
  Mapping API utility link

examples
  D&B hierarchy link
  Party and Customer Account Merge link
  Party Merge link

execution reports
  Customer Interface Transfer link
  Customer Merge Execution report link

extensions
  merge details link

F

file loads link
financial numbers
  import interface tables and TCA tables link

financial reports
  import interface tables and TCA tables link

Financial Standing Global Data Product link
Flexible Address Formatting
  address formatting link
  real-time address validation link

FND_TERRITORIES table
  entering address link
  entering addresses link

fuzzy keys
  postimport processes link

G

GDP link
   See Global Data Products (GDP)

Generate Request List for DNB Batch Load program
  description link
  parameters link

Generate Time Zone for Locations program
  description link
  parameters link

Generate Time Zone for Phone Numbers program
  description link
  parameters link

Geography Hierarchy
  real-time address validation link

Global Data Products (GDP)
  Business Verification link
  Commercial Credit Score (USA) link
  Decision Support link
  Delinquency Score link
  Enterprise Management link
  Financial Standing link
  Global Failure Risk Score link
  overview link
  Quick Check link
  Vendor Management link
  viewing purchased data elements link
  viewing request and purchase statistics link

Global Failure Risk Score Global Data Product link
group IDs
  correcting Mapping API utility errors link
  Load D&B Data parameter link link
  manually providing link

grouping
  merging customers link

H

hierarchical relationships
  description link

HZ: Allow Import of Records with Disabled Lookups profile option link
HZ: Allow Updates of Address Records During Import profile option link
HZ: Character Value to Indicate NULL During Import profile option link
HZ: Date Value to Indicate NULL During Import profile option link
HZ: Numeric Value to Indicate NULL During Import profile option link
HZ: Use Data Sharing and Security During Import profile option link
HZ: Validate Flexfields During Import profile option link link
HZ_CERTIFICATIONS table
  checking for duplicates link

HZ_CITIZENSHIP table
  checking for duplicates link

HZ_CODE_ASSIGNMENTS table
  corresponding import interface table link
  Data Sharing and Security (DSS) link

HZ_CONTACT_POINTS
  unique IDs for import interface tables link

HZ_CONTACT_POINTS table
  corresponding import interface table link
  Data Sharing and Security (DSS) link
  flexfield validations link link
  Source System Management (SSM) mappings link

HZ_CREDIT_RATINGS table
  corresponding import interface table link

HZ_DNB_SOURCE_DIR directory object link
HZ_EDUCATION table
  checking for duplicates link

HZ_EMPLOYMENT_HISTORY table
  checking for duplicates link

HZ_FINANCIAL_NUMBERS table
  corresponding import interface table link

HZ_FINANCIAL_PROFILE table
  checking for duplicates link

HZ_FINANCIAL_REPORTS table
  checking for duplicates link
  corresponding import interface table link

HZ_IMP_ADDRESSES_INT table
  matching addresses link
  parent and child relationships among interface tables link link
  primary flags link
  tables to import into link

HZ_IMP_ADDRESSUSES_INT table
  parent and child relationships among interface tables link
  primary flags link
  table to import into link

HZ_IMP_CLASSIFICS_INT table
  primary flags link
  table to import into link

HZ_IMP_CONTACTPTS_INT table
  parent and child relationships among interface tables link
  primary flags link
  table to import into link

HZ_IMP_CONTACTROLES_INT table
  parent and child relationships among interface tables link
  table to import into link

HZ_IMP_CONTACTS_INT table
  parent and child relationships among interface tables link
  tables to import into link

HZ_IMP_CREDITRTNGS_INT table
  table to import into link

HZ_IMP_ERRORS table link
HZ_IMP_FINNUMBERS_INT table
  parent and child relationships among interface tables link
  table to import into link

HZ_IMP_FINREPORTS_INT table
  parent and child relationships among interface tables link
  table to import into link

HZ_IMP_PARTIES_INT table
  parent and child relationships among interface tables link
  tables to import into link

HZ_IMP_RELSHIPS_INT table
  tables to import into link

HZ_INDUSTRIAL_REFERENCE table
  checking for duplicates link

HZ_LOCATIONS table
  address formatting link
  corresponding import interface table link
  creating parties with D&B information link
  flexfield validations link link
  updating with spatial data link

HZ_ORG_CONTACT_ROLES table
  corresponding import interface table link

HZ_ORG_CONTACTS table
  corresponding import interface tables link
  Source System Management (SSM) mappings link
  unique IDs for import interface tables link

HZ_ORGANIZATION_INDICATORS table
  checking for duplicates link

HZ_ORGANIZATION_PROFILES table
  corresponding import interface table link
  creating parties with D&B information link

HZ_PARTIES table
  corresponding import interface tables link
  Data Sharing and Security (DSS) link
  flexfield validations link link
  Source System Management (SSM) mappings link
  unique IDs for import interface tables link

HZ_PARTY_INTERFACE table
  loading D&B data link
  loading D&B data using SQL*Loader link
  status values link
  transferring data from link

HZ_PARTY_INTERFACE_ERRORS table link link link link
HZ_PARTY_SITE_USES table
  corresponding import interface table link

HZ_PARTY_SITES table
  corresponding import interface table link
  creating parties with D&B information link
  Data Sharing and Security (DSS) link
  Source System Management (SSM) mappings link
  unique IDs for import interface tables link

HZ_PERSON_INTEREST table
  checking for duplicates link

HZ_PERSON_LANGUAGE table
  checking for duplicates link

HZ_PERSON_PROFILES table
  corresponding import interface table link

HZ_REFERENCES table
  checking for duplicates link

HZ_RELATIONSHIPS table
  corresponding import interface tables link
  Data Sharing and Security (DSS) link
  flexfield validations link link

HZ_SECURITY_ISSUED table
  checking for duplicates link

HZ_WORK_CLASS table
  checking for duplicates link

I

Import Batch De-Duplication report
  description link
  parameter link
  part of Bulk Import process link
  previewing batch de-duplication results link link

Import Batch to TCA Registry program
  creating new parties for D&B rationalized legacy data link
  description link
  importing corrected records link
  importing D&B information link
  parameters link
  prerequisites link
  process link
  when cannot run link

import batches
  batch IDs link
  D&B link
  description link
  purging link

import errors
  resolving link

import validations link
importing
  Customer Interface import program link
  Customer Interface Transfer report link
  customers link link
  sample customer import link

information subtab link
insert through Bulk Import
  description link
  determining link

interface tables
  list of each with corresponding TCA tables link
  loading for Bulk Import link
  parent and child relationships link
  purging link
  unique IDs for Bulk Import link

interfaces
  Customer Interface link link
  Customer Interface Transfer report link

investigations
  requesting link

L

legacy data
  importing link
  rationalizing by D&B and loading link

Load D&B Data program
  description link
  importing corrected D&B data link
  parameters link
  prerequisites link

local activity codes
  validations link

Local Business IDs link
locations
  description link
  generating time zones for link
  overview link

M

mapped D-U-N-S Number link
Mapping API utility
  automatic correction of D&B values link
  correcting errors link
  description link

mapping records
  determining insert or update for Bulk Import link

match rules
  for batch de-duplication link
  for Registry de-duplication link

merge batches
  creating link
  description link
  organization contacts link
  parties link
  party relationships link
  party sites link
  party sites within a party link
  previewing results link
  processing link
  submitting link
  submitting from batch duplicate identification link
  viewing profile information link

merge-from parties
  deleting after merge link
  description link
  viewing profile information link

merge-to parties
  description link
  viewing profile information link

merging
  Customer Merge Execution report link
  customers link
  merging sites for different customers link
  merging sites for the same customer link
  reviewing merged customers link
  submitting customer merge link

N

navigation paths link
null values
  updating with Bulk Import link

O

OCO link
   See Oracle Customers Online (OCO)

online purchasing
  loading corrected D&B data link
  overview link
  process link
  requesting investigations link
  resolving errors and manually importing data link
  searching TCA Registry link
  searching the D&B database link
  selecting data products or BIRs link

open interfaces
  Customer Interface link

Oracle Customer Data Hub (CDH)
  description link

Oracle Customer Data Librarian (CDL)
  description link
  file loads link
  purging parties link
  resolving duplicates from Customer Interface link
  System Duplicate Identification batches link link

Oracle Customer Data Management (CDM) link
Oracle Customers Online (OCO)
  description link
  file loads link

Oracle eLocations link
Oracle Trading Community Architecture (TCA)
  administering and implementing link
  overview link
  using link

Organization Profile entity
  description link

P

Parent Bankruptcy Chapter Conversion link
parties
  description link
  enriching with third party data link
  identifying duplicates link
  import interface tables and TCA tables link
  importing link
  managing relationships among link
  merging link

party link
Party and Customer Merge
  overview link

Party Contacts relationship group link
Party Merge
  example link
  example with Customer Account Merge link
  impact on D&B data link
  merging versus transferring link
  overview link
   See also merge batches
  process link
  source ID impact link

Party Merge process
  description link
  identifying errors link
  parameter link
  program description link
  reviewing log link

party numbers
  maintaining uniqueness during Bulk Import link

party site numbers
  maintaining uniqueness during Bulk Import link

party sites
  description link
  duplicates from Customer Interface link
  merging link link
  merging within a party link

party types
  description link
  in Relationship Manager link

person names
  postimport processes link

Person Profile entity
  description link

personalizable pages
  user link

phone numbers
  generating time zones for link
  postimport processes link

postimport errors
  resolving link

postimport processes link
preimport processes
  description link

primary flags
  description link
  specifying with Bulk Import link

profile options
  HZ: Allow Import of Records with Disabled Lookups link
  HZ: Allow Updates of Address Records During Import link
  HZ: Character Value to Indicate NULL During Import link
  HZ: Date Value to Indicate NULL During Import link
  HZ: Numeric Value to Indicate NULL During Import link
  HZ: Use Data Sharing and Security During Import link
  HZ: Validate Flexfields During Import link link

programs
  Address Validation link
  Create Merge Batch link
  Customer Interface link link
  Customer Merge link
  D&B File Load - Pass 1 link
  D&B Flat File Upload Table Creation link
  DQM Batch Duplicate Identification link
  Generate Request List for DNB Batch Load link
  Generate Time Zone for Locations link
  Generate Time Zone for Phone Numbers link
  Import Batch to TCA Registry link link link link link
  list of link
  Load D&B Data link link
  Party Merge link link
  Spatial Information for Locations Batch Update link
  TCA Import Batch Purge link
  TCA Import Postprocessing link link

Q

Quick Check Global Data Product link

R

rationalized legacy data
  loading link

real-time address validation
  description link
  process link

Registry de-duplication
  description link

Registry IDs
  description link

relationship
  account relationship link
  party relationship link

relationship date ranges
  changing link
  description link

relationship groups
  description link

relationship hierarchies
  D&B hierarchy link
  description link
  viewing link

Relationship Manager
  major features link
  overview link
  process link

relationship phrase and role pairs
  description link

relationship phrase pairs link
   See relationship phrase and role pairs

relationship phrases
  changing link
  description link

relationship role pairs link
   See relationship phrase and role pairs

relationship roles
  description link

relationship types
  description link

relationships
  changing in hierarchy link
  creating link
  editing link
  ending link
  import interface tables and TCA tables link
  merging link
  overview link
  postimport processes link
  searching for parties to manage link
  viewing link
  viewing information for parties link

reports
  Customer Interface Transfer link
  Customer Listing - Detail link
  Customer Listing - Summary link
  Customer Merge Execution report link
  Customer Profiles link
  Customer Relationships Listing link
  DNB Global Data Products Request link
  Duplicate Customer link
  Duplicate DUNS link
  Import Batch De-Duplication link link link link
  list of link
  TCA Import Error link

request sets
  D&B Import Adapter link link link

responsibilities
  Trading Community Manager link link link

S

SIC codes
  validations link

Single Source of Truth (SST)
  displaying third party data link
  making D&B information available for link link
  viewing link

sites/addresses
  account site link
  customer address link
  location link
  party site link

source IDs
  D-U-N-S Numbers link
  description link
  importing associated accounts link
  unique IDs for import interface tables link

Source System Management (SSM)
  determining insert or update for Bulk Import link
  impact on D&B data link
  unique IDs for import interface tables link

spatial data
  acquiring link
  description link

Spatial Information for Locations Batch Update program
  description link
  parameters link

SQL*Loader
  loading D&B file link

SQL/ETL load link
SSM link
   See Source System Management

SST link
   See Single Source of Truth (SST)

staging tables
  purging link

standard navigation paths link
System Duplicate Identification (SDI) batches
  creating from Registry de-duplication link link

T

tables
  FND_TERRITORIES link link
  HZ_CERTIFICATIONS link
  HZ_CITIZENSHIP link
  HZ_CODE_ASSIGNMENTS link link
  HZ_CONTACT_POINTS link link link link link link
  HZ_CREDIT_RATINGS link
  HZ_EDUCATION link
  HZ_EMPLOYMENT_HISTORY link
  HZ_FINANCIAL_NUMBERS link
  HZ_FINANCIAL_PROFILE link
  HZ_FINANCIAL_REPORTS link link
  HZ_IMP_ADDRESSES_INT link link link link link
  HZ_IMP_ADDRESSUSES_INT link link link
  HZ_IMP_CLASSIFICS_INT link link
  HZ_IMP_CONTACTPTS_INT link link link
  HZ_IMP_CONTACTROLES_INT link link
  HZ_IMP_CONTACTS_INT link link
  HZ_IMP_CREDITRTNGS_INT link
  HZ_IMP_ERRORS link
  HZ_IMP_FINNUMBERS_INT link link
  HZ_IMP_FINREPORTS_INT link link
  HZ_IMP_PARTIES_INT link link
  HZ_IMP_RELSHIPS_INT link
  HZ_INDUSTRIAL_REFERENCE link
  HZ_LOCATIONS link link link link link link
  HZ_ORG_CONTACT_ROLES link
  HZ_ORG_CONTACTS link link link
  HZ_ORGANIZATION_INDICATORS link
  HZ_ORGANIZATION_PROFILES link link
  HZ_PARTIES link link link link link link
  HZ_PARTY_INTERFACE link link link link
  HZ_PARTY_INTERFACE_ERRORS link link link link
  HZ_PARTY_SITE_USES link
  HZ_PARTY_SITES link link link link link
  HZ_PERSON_INTEREST link
  HZ_PERSON_LANGUAGE link
  HZ_PERSON_PROFILES link
  HZ_REFERENCES link
  HZ_RELATIONSHIPS link link link link
  HZ_SECURITY_ISSUED link
  HZ_WORK_CLASS link
  updated by Customer Interface link

tax assignments
  postimport processes link

tax validation
  merging addresses link

TCA link
   See Oracle Trading Community Architecture

TCA Import Batch Purge program
  description link
  parameters link

TCA Import Error report
  description link

TCA Import Postprocessing program
  description link
  parameters link
  resolving errors link

TCA Registry
  description link

Third Party Data Integration link link link
   See also D&B
   See also D&B batch loading
   See also online purchasing
  creating parties with D&B information link
  DNB Global Data Products Request report link
  Duplicate DUNS report link
  loading rationalized legacy data link
  overview link
  Source System Management impact link
  viewing information from data sources link

time zones
  generating for locations link
  generating for phone numbers link
  postimport processes link

Trading Community Architecture link
   See Oracle Trading Community Architecture
  user-personalizable pages link

Trading Community Architecture User-Personalizable Pages link
Trading Community Manager responsibility link link link
transferring party sites link

U

unique IDs for interface tables link link
update through Bulk Import
  description link
  determining link

user-personalizable pages
  Trading Community Architecture link

V

validation status codes link
validations
  Bulk Import link
  Customer Interface validation rules link

Vendor Management Global Data Product link