23/23
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