Results for “ar_cmgt_cf_dtls”

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

Overview

AR_CMGT_CF_DTLS is a Receivables (AR) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas. Its functional purpose is to persist the individual data points and corresponding values that a user has selected for display within a case folder. Case folders are a Collections and Credit Management construct in Oracle Receivables, used by credit and collections agents to assemble a curated "case" for an account or customer — pulling together balances, aging, contact history, disputes, and other relevant facts into a single working view. AR_CMGT_CF_DTLS is the physical storage layer for that curated content: each row represents one data point rendered in a case folder, together with its captured value and related scoring or checklist metadata.

From a modeling perspective, the heuristic Data Vault classification supplied in the metadata is standalone. This suggestion indicates that the table does not participate in a clean hub-and-link pattern in the delivered schema — it is a dependent, attribute-bearing structure whose rows exist relative to a parent case folder rather than as an independently identified business entity. Treating it as a satellite attached to a case folder hub would be the most natural interpretation if a Data Vault model were being constructed over AR data.

Key Information Stored

The table is defined with 15 columns in the documented 12.2.2 physical schema. The most operationally significant are described below.

• CASE_FOLDER_ID — Identifies the parent case folder to which the detail row belongs. This column is part of the composite primary key.
• DATA_POINT_ID — Identifies the specific data point (the metric, attribute, or fact) being displayed. This is the second component of the composite primary key.
• CASE_FOLDER_DETAIL_ID — A surrogate identifier for the detail row, enforced as unique by the unique index AR_CMGT_CF_DTLS_U1. This is the strongest business-key candidate documented.
• DATA_POINT_VALUE — The actual captured value for the data point within the case folder context.
• DATA_POINT_VALUE_ID — A reference to the underlying value entity, where applicable.
• SCORE — A numeric score associated with the data point, supporting scoring and risk-assessment scenarios.
• INCLUDED_IN_CHECKLIST — A flag indicating whether the data point forms part of the case folder checklist.
• SEQUENCE_NUMBER — Controls the display order of data points within the folder.
• PARENT_DATA_POINT_ID and PARENT_CF_DETAIL_ID — Self-referencing columns that establish hierarchical relationships between data points, enabling nested or parent-child display of case folder content.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row.

The composite primary key AR_CMGT_CF_DTLS_PK is formed by (CASE_FOLDER_ID, DATA_POINT_ID), while the unique key AR_CMGT_CF_DTLS_U1 is defined on CASE_FOLDER_DETAIL_ID.

Common Use Cases and Queries

The dominant access pattern is a fetch of all detail rows for a given case folder, ordered by sequence. A representative query is:

SELECT case_folder_detail_id,
       data_point_id,
       data_point_value,
       score,
       included_in_checklist,
       sequence_number
FROM   ar.ar_cmgt_cf_dtls
WHERE  case_folder_id = :p_case_folder_id
ORDER  BY sequence_number;

Hierarchical traversal of parent-child data points can be achieved with a CONNECT BY query using PARENT_DATA_POINT_ID. Reporting scenarios include analysis of scoring distributions across case folders (aggregating SCORE by CASE_FOLDER_ID), identification of checklists where specific data points are excluded via INCLUDED_IN_CHECKLIST, and reconciliation of point values at a point in time. The audit columns support change-tracking extracts for compliance and internal control reporting.

Related Objects

• AR_CMGT_CASE_FOLDERS — The parent case folder table; joins on CASE_FOLDER_ID.
• AR_CMGT_DATA_POINTS — Stores the definitions of data points; joins on DATA_POINT_ID.
• AR_CMGT_DATA_POINT_VALUES — Holds the value records referenced by DATA_POINT_VALUE_ID.
• AR_CMGT_CF_DTLS (self-reference) — Parent-child linkage via PARENT_CF_DETAIL_ID and PARENT_DATA_POINT_ID.
• AR_CMGT_CF_DTLS_PK / AR_CMGT_CF_DTLS_U1 — The primary and unique indexes enforcing row identity.
• Collections and Credit Management UI views and concurrent programs that render case folder content depend on this table through the above relationships.