Search Results exec_dqm_api

Overview

ARH_DQM_PKG (Data Quality Management Package) is a PL/SQL package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema. Its primary business function is to support the Data Quality Management (DQM) framework used to evaluate, score, and deduplicate trading community entities such as parties, party sites, contacts, and contact points. Within the Oracle EBS 12.1.1 and 12.2.2 releases, this package provides the procedural plumbing that allows DQM adapters and third-party data quality providers to execute matching and scoring logic against customer, supplier, and organization records stored in the TCA (Trading Community Architecture) model.

The package defines a record type dsprec and an associated indexed table type dsplist, which are used to hold structured display or result information (state, depth, label, icon, and up to 4000 characters of data). This structure indicates the package is also used to return hierarchical or nested DQM execution results for presentation in the application user interface.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

• AddList — A function that merges or concatenates two dsplist collections, returning a combined list. It supports the accumulation of DQM result sets across multiple processing steps.
• IsNull (overloaded four times) — Returns TRUE when all attributes of a given DQM search record are NULL. Separate overloads accept party search, party site search, contact search, and contact point search record types drawn from the HZ_PARTY_SEARCH package. These functions are used to short-circuit processing when no search criteria have been supplied.
• Exec_Dqm_Api — The core entry point that executes the Data Quality Management application programming interface. It accepts a large set of party-level attributes (line of business, local activity code, business identifier, credit information, organization name, SIC code, employee counts, and similar fields) and submits them for DQM scoring, matching, or cleansing. This is the procedure returned when users search for "exec_dqm_api".
• Exec_Dqm_Dup_API — A companion procedure that executes the DQM duplicate-detection API, used specifically for identifying potential duplicate entities.
• Get_Dqm_Exec_Details — Retrieves details about a prior DQM execution, allowing callers to inspect the results, status, or diagnostics of a matching run.

Tables Accessed

The package references several TCA tables through APPS synonyms:

• HZ_PARTIES and HZ_PARTY_SITES — Core party and party site records being evaluated.
• HZ_ORG_CONTACTS and HZ_CONTACT_POINTS — Contact and communication point data processed during DQM evaluation.
• HZ_RELATIONSHIPS — Party relationship data used in matching and deduplication logic.
• HZ_MATCHED_PARTIES_GT, HZ_MATCHED_CONTACTS_GT, HZ_MATCHED_CPTS_GT — Global temporary tables that hold the intermediate or final matched results produced by the match engine.
• PLITBLM — Oracle's standard PL/SQL integer table type used internally for array processing.

Usage Notes

ARH_DQM_PKG is an internal API classified as OTHER, meaning it is not a formally published public interface. It is documented as referenced by zero other packages, indicating it is typically invoked directly by DQM adapter layers, the Oracle Data Quality Management concurrent programs, or custom extensions that integrate third-party data quality services (such as Dun & Bradstreet, Experian, or similar providers).

In Oracle EBS 12.1.1 and 12.2.2, DQM execution is commonly triggered from the Customers, Suppliers, and Trading Community workbenches, where match and merge operations call the DQM API. Custom PL/SQL code should invoke Exec_Dqm_Api only after populating the relevant HZ search record structures and should use the IsNull overloads to validate inputs before calling. Because the package relies on global temporary tables and TCA structures, direct modification of its logic is not supported; extensions should wrap the API rather than alter it. Support for this package is tied to the Oracle Trading Community Architecture API documentation set.