Results for “application_number”

28 results




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

Overview

The AR_CMGT_CREDIT_REQUESTS table is a core transaction and master-data object within the Oracle Receivables (AR) module, specifically belonging to the Credit Management (CMGT) functional area. It stores information for each credit request raised against a customer, capturing the full context of a credit evaluation event: the requesting party, the customer account and site, the analyst performing the review, the monetary limits and transaction amounts requested, scoring and classification data, and the workflow status of the request itself. In Oracle E-Business Suite releases 12.1.1 and 12.2.2, this table functions as the central anchor of the Credit Management data model, tying together customer identity, credit scoring, collateral, guarantor, financial, bank reference, and trade reference information.

The table is defined in the AR schema with 55 documented columns and is identified by the primary key AR_CMGT_CREDIT_REQUESTS_PK on the CREDIT_REQUEST_ID column. A unique index, AR_CMGT_CREDIT_REQUESTS_U1, also exists on CREDIT_REQUEST_ID. Under a heuristic Data Vault classification derived from its foreign key structure, the table is satellite-leaning: it carries descriptive, context-dependent attributes about a credit decision while also referencing multiple hubs (parties, customer accounts, sites). It is not a pure hub because it does not define a single business entity in isolation, and it is not a pure link because it holds substantial descriptive payload.

Key Information Stored

The most operationally significant columns include:

Common Use Cases and Queries

Typical usage centers on credit review reporting, approval workflow monitoring, and customer exposure analysis. A common query retrieves all open credit requests for a given customer account:

  • SELECT cr.credit_request_id, cr.status, cr.limit_amount, cr.limit_currency FROM ar.ar_cmgt_credit_requests cr WHERE cr.cust_account_id = :account_id AND cr.status = 'OPEN';

Analysts also join to HZ_PARTIES to resolve the customer name and to AR_CMGT_SCORES to display the score model applied. Reporting on outstanding requests by analyst uses CREDIT_ANALYST_ID and STATUS. Credit exposure dashboards join this table to AR_CMGT_FINANCIAL_DATA, AR_CMGT_COLLATERAL_DATA, and AR_CMGT_BANK_REF_ACCTS via CREDIT_REQUEST_ID to aggregate supporting evidence for each request.

Related Objects

This table sits at the center of a dense relationship network. The following are the most significant related objects and join columns: