Search Results ar_cmgt_collateral_data




Overview
Explore in AI Chat

Overview

The AR_CMGT_COLLATERAL_DATA table is a Receivables (AR) module table within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores detailed information about assets that can be pledged to secure credit available to a company under credit review. In practical terms, this is the collateral registry that supports Credit Management workflows: each row captures a pledgeable asset, its valuation, its appraiser, and its physical location, all tied back to a specific credit request and case folder. The table is owned by the AR schema and carries a VALID status in the ETRM dictionary.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests the table can be treated as an independent structure without a strict hub, link, or satellite dependency in the mined relationship graph, though in practice its foreign keys to credit requests and case folders give it clear association semantics within the Credit Management sub-model.

Key Information Stored

The physical schema documents 19 columns. The most significant are:

The surrogate key is DATAPOINT_ID; the unique index AR_CMGT_COLLATERAL_DATA_U1 serves as the business-key candidate on that column.

Common Use Cases and Queries

Typical scenarios include credit exposure reporting, collateral coverage calculations, and revaluation tracking for assets pledged against credit lines. A common query pattern joins collateral to its credit request and case folder:

  • List all collateral for a credit request: SELECT c.COLLATERAL_DESCRIPTION, c.COLLATERAL_VALUE, c.COLLATERAL_CURRENCY FROM AR_CMGT_COLLATERAL_DATA c WHERE c.CREDIT_REQUEST_ID = :request_id.
  • Aggregate pledged value per credit request to compare against approved credit limits.
  • Identify collateral due for revaluation by comparing VALUATION_DATE against a threshold.
  • Report appraiser activity using APPRAISER_NAME grouped by period.
  • Track collateral by category and location for portfolio concentration analysis.

Related Objects

The principal related objects, derived from documented FK relationships, are:

  • AR_CMGT_CREDIT_REQUESTS — joined on CREDIT_REQUEST_ID; the parent credit request record.
  • AR_CMGT_CASE_FOLDERS — joined on CASE_FOLDER_ID; the credit case folder grouping.
  • AR_CMGT_COLLATERAL_DATA_PK and AR_CMGT_COLLATERAL_DATA_U1 — the primary and unique indexes enforcing DATAPOINT_ID integrity.
  • Credit Management inquiry and reporting views and concurrent programs in the AR module that consume collateral valuation data.

Because the table is classified as standalone in the Data Vault heuristic, related-object depth is limited to the documented foreign keys and the Credit Management entities they reference.