Search Results ar_cmgt_guarantor_data




Overview
Explore in AI Chat

Overview

The AR_CMGT_GUARANTOR_DATA table is a core data repository within the Oracle E-Business Suite Receivables (AR) module, specifically supporting the Credit Management functionality. It serves the critical role of storing master information about guarantors—third-party entities who provide a legal guarantee for a customer's credit obligations. This table is essential for managing credit risk, as it formally records the parties who are contractually obligated to fulfill a debt if the primary customer defaults. Its existence is integral to the credit evaluation and approval workflows in versions 12.1.1 and 12.2.2, enabling a structured audit trail of guarantee relationships tied to specific credit requests.

Key Information Stored

The table's structure is designed to link guarantor information to the broader credit management framework. The primary key, DATAPOINT_ID, uniquely identifies each guarantor record. The most significant foreign key columns define its relationships: GUARANTOR_CREDIT_REQUEST_ID links the guarantor to a specific application in the AR_CMGT_CREDIT_REQUESTS table. The PARTY_ID column stores the identifier for the guarantor entity itself from the Trading Community Architecture (TCA) registry (HZ_PARTIES), while CONTACT_PARTY_ID can store the identifier for a specific contact person at the guarantor organization, also from HZ_PARTIES. Additional columns, implied by its purpose, would typically store data such as the guarantee amount, effective dates, status, and the percentage of liability covered.

Common Use Cases and Queries

This table is primarily accessed during credit analysis, audit reporting, and guarantee lifecycle management. A common operational query retrieves all active guarantors for a specific customer or credit request to assess aggregate covered risk. For reporting, analysts may join this table to HZ_PARTIES and AR_CMGT_CREDIT_REQUESTS to generate lists of guarantees by guarantor name, customer, or expiration date. A typical SQL pattern for due diligence reporting would be:

  • SELECT hzp.party_name guarantor_name, accr.request_number, acgd.*
  • FROM ar_cmgt_guarantor_data acgd,
  • hz_parties hzp,
  • ar_cmgt_credit_requests accr
  • WHERE acgd.party_id = hzp.party_id
  • AND acgd.guarantor_credit_request_id = accr.credit_request_id
  • AND accr.customer_id = :p_cust_id;

Data from this table is also critical when generating legal documents for guarantees and during collections processes if a guaranteed debt becomes delinquent.

Related Objects

The AR_CMGT_GUARANTOR_DATA table has defined dependencies within the Credit Management schema. Its primary relationship is with the AR_CMGT_CREDIT_REQUESTS table, which holds the master record for the credit application the guarantee supports. It is fundamentally linked to the Trading Community Architecture via two foreign keys to the HZ_PARTIES table, which provides the definitive source for party (organization or person) details. While not listed in the provided metadata, this table is likely referenced by various Credit Management views (e.g., AR_CMGT_GUARANTORS_V) that present aggregated data for forms and reports, and it is manipulated through dedicated PL/SQL APIs in the AR_CMGT package family to ensure business rule validation.

  • Table: AR_CMGT_GUARANTOR_DATA 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_GUARANTOR_DATA,  object_name:AR_CMGT_GUARANTOR_DATA,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_GUARANTOR_DATA table stores information about an entity who is legally responsible for fulfilling a credit obligation if the primary party, the company under credit review, fails to pay its debt. ,  implementation_dba_data: AR.AR_CMGT_GUARANTOR_DATA , 

  • Table: AR_CMGT_GUARANTOR_DATA 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_GUARANTOR_DATA,  object_name:AR_CMGT_GUARANTOR_DATA,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_GUARANTOR_DATA table stores information about an entity who is legally responsible for fulfilling a credit obligation if the primary party, the company under credit review, fails to pay its debt. ,  implementation_dba_data: AR.AR_CMGT_GUARANTOR_DATA , 

  • Table: AR_CMGT_CREDIT_REQUESTS 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_CREDIT_REQUESTS,  object_name:AR_CMGT_CREDIT_REQUESTS,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request. ,  implementation_dba_data: AR.AR_CMGT_CREDIT_REQUESTS , 

  • Table: AR_CMGT_CREDIT_REQUESTS 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CMGT_CREDIT_REQUESTS,  object_name:AR_CMGT_CREDIT_REQUESTS,  status:VALID,  product: AR - Receivables ,  description: The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request. ,  implementation_dba_data: AR.AR_CMGT_CREDIT_REQUESTS , 

  • Table: HZ_PARTIES 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_PARTIES,  object_name:HZ_PARTIES,  status:VALID,  product: AR - Receivables ,  description: Information about parties such as organizations, people, and groups ,  implementation_dba_data: AR.HZ_PARTIES , 

  • Table: HZ_PARTIES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_PARTIES,  object_name:HZ_PARTIES,  status:VALID,  product: AR - Receivables ,  description: Information about parties such as organizations, people, and groups ,  implementation_dba_data: AR.HZ_PARTIES ,