| D&B’s Master Data Management services offer Oracle clients the ability to create a comprehensive data management strategy, leveraging standard integration with D&B. Depending on the stage of the Oracle E-Business Suite or Customer Data Hub implementation or upgrade, D&B can offer services that significantly improve the effectiveness and efficiency of the client’s project. Before the project starts: Data Model / Design Assistance - Oracle’s Trading Community Architecture (TCA) in the E-Business Suite and Customer Data Hub supports a “one-to-one” data model more effectively than the “one-to-many” data model embedded in the Release 10.7 and Release 11.0 versions of Oracle (for more information, please see Oracle’s TCA Best Practices white paper on Oracle MetaLink). This is a challenge for customers – to somehow “split” their customers. If the customer sends all of the addresses that they want created as parties in Oracle 11i to D&B, then when the D&B data is loaded into Oracle, the recommended one-to-one structure will automatically be created. Duplicate Identification and Management - Clients can more easily leverage Oracle’s Data Quality Management tools, which enable users to identify duplicates based on match rules. The DQM tools are much more effective when used with the D&B DUNS Number. Once duplicates are identified, they can be merged, while preserving transactions associated with the duplicate party or account. Relationship / Corporate Hierarchies - Oracle’s TCA and CDH infrastructure offers clients the ability to create relationships between business entities (organization parties). The challenge is to identify and maintain these party relationships within Oracle. D&B’s corporate hierarchy offers the solution. During batch or real-time enrichment with D&B data, relationships are created at the party level automatically, if clients license corporate linkage from D&B. After “Go Live”: Enhanced Information for Decision-Making - Oracle 11i offers clients the ability to search for and retrieve D&B data directly into Oracle. Clients use this feature to create Parties in Oracle automatically using D&B’s standardized and enriched information. Information available includes corporate hierarchies, risk scoring, financial information and a variety of demographic data. There are 170 D&B fields available. Customers can load this data all at once in batch mode or record-by-record through the D&B Data Integration Toolkit which Oracle has built into Oracle 11i. Access to D&B is available in Oracle TCA and the Customer Data Hub, through the Customers Online, Customer Data Librarian, Credit Management and Accounts Receivable modules. Data Maintenance - Oracle’s recommended best practice suggests that clients create processes to refresh information periodically to address duplicates, fill in incomplete or missing information, or reflect changing information on their clients. D&B provides clients an automated way to maintain up-to-date information on customers and prospects, as well as an efficient way to identify and manage duplicates. |
Batch load D&B data into CDH or TCA through Bulk Import Transact in real time with D&B to retrieve and store D&B data within E-Business Suite Identify duplicates within DQM using D&B's DUNS Number Leverage D&B's corporate linkage within Oracle's Relationship Manager to display corporate hierarchies Create new parties using D&B's standardized name and address information Leverage D&B information to drive scoring models and decisions within Credit Management Leverage D&B hierarchies within CRM to identify corporate opportunities Refresh party content with D&B data to ensure completeness, cleanliness and comprehensiveness of trading partner data
