Search Results ar_cmgt_collateral_data_u1

Overview

The AR.AR_CMGT_COLLATERAL_DATA table is a transactional data object within the Oracle E-Business Suite Receivables (AR) module, specifically part of the Credit Management (CMGT) subsystem introduced to support credit review and collateral tracking workflows. The table stores detailed information about assets that can be pledged to secure credit extended to a company under credit review. Common collateral types include real estate, stock and bonds, and equipment. In the event that the company fails to meet its financial obligations, the pledged collateral may be seized to reduce the outstanding debt. Each row represents a discrete collateral data point associated with a specific credit request and, where applicable, a case folder.

From a Data Vault modeling perspective, the ETRM metadata classifies this table heuristically as standalone. In practice, however, the presence of surrogate and business-key columns alongside descriptive attributes suggests that AR_CMGT_COLLATERAL_DATA functions most naturally as a satellite attached to the credit request hub, with the credit request identifier acting as the parent business key. Analysts designing downstream warehouses around this object should consider that interpretation when mapping source-to-target lineage.

Key Information Stored

The table is owned by the AR schema, resides in the APPS_TS_TX_DATA tablespace, and contains nineteen documented columns. The most significant include:

• DATAPOINT_ID — A NUMBER(15) surrogate primary key uniquely identifying each collateral data point. It is also the column behind the unique index AR_CMGT_COLLATERAL_DATA_U1, making it the strongest candidate for a business-key surrogate in this table.
• CREDIT_REQUEST_ID — A NUMBER(15) foreign key identifying the credit request for which collateral information is reported. It is indexed non-uniquely via AR_CMGT_COLLATERAL_DATA_N1.
• CASE_FOLDER_ID — A NUMBER(15) foreign key linking the collateral row to the associated case folder used for displaying the value in the credit analyst's folder view.
• COLLATERAL_DESCRIPTION — VARCHAR2(100) describing the pledged asset.
• COLLATERAL_CATEGORY — VARCHAR2(30) classifying the collateral (for example, real estate, securities, or equipment).
• COLLATERAL_VALUE and COLLATERAL_CURRENCY — The monetary amount assigned to the collateral and the currency in which it is denominated.
• VALUATION_TYPE, VALUATION_DATE, and PREV_VALUATION_DATE — The method, most recent valuation date, and prior valuation date for the asset.
• APPRAISER_NAME and APPRAISER_PHONE_NUMBER — Contact details for the party who appraised the collateral.
• COLLATERAL_LOCATION and NOTES — Free-text descriptors for the physical location of the asset and additional commentary.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide auditability.

Common Use Cases and Queries

Credit analysts and developers query this table most often to report collateral coverage against outstanding credit exposure. A typical pattern joins the collateral rows back to their parent credit request:

• Listing all collateral associated with a credit request: SELECT c.COLLATERAL_DESCRIPTION, c.COLLATERAL_CATEGORY, c.COLLATERAL_VALUE FROM AR.AR_CMGT_COLLATERAL_DATA c WHERE c.CREDIT_REQUEST_ID = :request_id;
• Aggregating total pledged value per credit request to compare against approved exposure: SELECT CREDIT_REQUEST_ID, SUM(COLLATERAL_VALUE) FROM AR.AR_CMGT_COLLATERAL_DATA GROUP BY CREDIT_REQUEST_ID;
• Identifying stale valuations by examining VALUATION_DATE against a threshold date.
• Audit reconstruction using CREATED_BY / LAST_UPDATED_BY joined to FND_USER for change tracking.

Related Objects

Foreign key relationships established in the metadata tie this table to two parent objects:

• AR.AR_CMGT_CREDIT_REQUESTS — joined via CREDIT_REQUEST_ID; the primary parent of the collateral detail.
• AR.AR_CMGT_CASE_FOLDERS — joined via CASE_FOLDER_ID; links collateral to the analyst's case workspace.
• FND_USER — indirect lookup for CREATED_BY and LAST_UPDATED_BY audit columns.
• FND_LOGINS — indirect lookup for LAST_UPDATE_LOGIN.
• AR_CMGT_COLLATERAL_DATA_U1 — the unique index on DATAPOINT_ID, essential to query plans that retrieve a single collateral row.