Results for “hz_role_responsibility”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HZ_ROLE_RESPONSIBILITY is an Oracle E-Business Suite table owned by the AR (Receivables) schema. It stores the responsibilities associated with parties in relation to the roles those parties play within customer accounts. In the TCA (Trading Community Architecture) model, a customer account may have multiple roles — such as bill-to, ship-to, or contact — and each role can carry one or more defined responsibilities. This table provides the persistence layer for that relationship, enabling EBS to track which responsibilities apply to a given account role.

The object is classified as VALID in both 12.1.1 and 12.2.2 releases, and forms part of the broader HZ_ (Trading Community) family of tables even though it is physically owned by the AR schema. Its design follows the standard EBS multi-org and audit conventions, embedding WHO columns, DFF attribute columns, and concurrency control columns. Based on the foreign key structure — a single reference to HZ_CUST_ACCOUNT_ROLES via CUST_ACCOUNT_ROLE_ID — the heuristic Data Vault classification is satellite-leaning, suggesting it is best modeled as a satellite entity attached to the customer account role hub.

Key Information Stored

The table contains 34 documented columns. The most significant are:

• RESPONSIBILITY_ID — Surrogate primary key, enforced by the unique index HZ_ROLE_RESPONSIBILITY_U1 and constraint HZ_ROLE_RESPONSIBILITY_PK.
• CUST_ACCOUNT_ROLE_ID — Foreign key to HZ_CUST_ACCOUNT_ROLES; the parent account-role assignment to which this responsibility belongs.
• RESPONSIBILITY_TYPE — Classifies the nature of the responsibility held (for example bill-to, ship-to, or contact-related designations).
• PRIMARY_FLAG — Indicates whether this responsibility is the primary one for the associated role.
• ORIG_SYSTEM_REFERENCE — The originating system's identifier, supporting data migration and multi-source consolidation.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the TCA APIs for concurrent update control.
• APPLICATION_ID — Identifies the application context that owns or created the row.
• CREATED_BY_MODULE — Records the module that originated the record, aiding traceability.
• WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — Standard audit information.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context for batch-created rows.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield storage, allowing client-specific extensions.

The surrogate key RESPONSIBILITY_ID is the sole documented unique business-key candidate.

Common Use Cases and Queries

Typical usage revolves around retrieving the responsibilities attached to a customer or account role, verifying which responsibility is primary, and integrating with downstream billing or shipping logic. A representative query joins back to the parent role table:

• SELECT r.responsibility_id, r.responsibility_type, r.primary_flag FROM hz_role_responsibility r WHERE r.cust_account_role_id = :role_id;
• Listing all responsibilities for a customer via a three-way join through HZ_CUST_ACCOUNT_ROLES and HZ_CUST_ACCOUNTS.
• Auditing rows created by a specific concurrent program using REQUEST_ID or PROGRAM_ID.
• Extracting descriptive flexfield values via ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for custom reporting.
• Data-migration reconciliation keyed on ORIG_SYSTEM_REFERENCE.

Related Objects

The most significant related objects, based on the documented foreign keys and the TCA schema:

• HZ_CUST_ACCOUNT_ROLES — Parent table; joined on CUST_ACCOUNT_ROLE_ID.
• HZ_CUST_ACCOUNTS — Grandparent account entity reached through the role table.
• HZ_PARTIES — The party playing the role, accessed via the role-parent chain.
• HZ_CUST_ACCT_ROLES_V / HZ_CUST_ACCOUNTS_V — Public views typically queried for reporting.
• HZ_CUST_ACCOUNT_ROLE_RESP_V — A view commonly exposing this table's data.
• TCA APIs (HZ_CUST_ACCOUNT_ROLE_V2PUB) — Used to create and maintain role responsibilities programmatically.