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:
- CREDIT_REQUEST_ID — the surrogate primary key, uniquely identifying each credit request.
- REQUESTOR_TYPE and REQUESTOR_ID — the type and identifier of the party or user initiating the request.
- PARTY_ID, CUST_ACCOUNT_ID, CUST_ACCT_SITE_ID, SITE_USE_ID, and CONTACT_PARTY_ID — the customer identity and site context for the request, with foreign keys to HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL.
- CREDIT_ANALYST_ID — the analyst assigned to review the request.
- LIMIT_AMOUNT and LIMIT_CURRENCY — the credit limit being requested or evaluated.
- TRX_AMOUNT and TRX_CURRENCY — the transaction amount and currency driving the request.
- CREDIT_CLASSIFICATION, CREDIT_TYPE, and SCORE_MODEL_ID — classification and scoring context, with SCORE_MODEL_ID referencing AR_CMGT_SCORES.
- CHECK_LIST_ID — the credit checklist applied, referencing AR_CMGT_CHECK_LISTS.
- STATUS — the workflow status of the credit request.
- APPLICATION_NUMBER, APPLICATION_DATE, and CASE_FOLDER_NUMBER — case and application identifiers.
- REVIEW_TYPE, REVIEW_CYCLE, and CREDIT_REQUEST_TYPE — the review and request categorization.
- PARENT_CREDIT_REQUEST_ID — self-referencing hierarchy for related or follow-on requests.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY — standard WHO audit columns.
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:
- AR_CMGT_GUARANTOR_DATA — joins on GUARANTOR_CREDIT_REQUEST_ID = CREDIT_REQUEST_ID; also references back via CREDIT_REQUEST_ID.
- LNS_PARTICIPANTS — joins on CREDIT_REQUEST_ID, linking credit requests to loan participants.
- AR_CMGT_FINANCIAL_DATA, AR_CMGT_OTHER_DATA, AR_CMGT_COLLATERAL_DATA, AR_CMGT_TRADE_REF_DATA, AR_CMGT_BANK_REF_DATA, AR_CMGT_BANK_REF_ACCTS — all join on CREDIT_REQUEST_ID to provide supporting financial, collateral, and reference evidence.
- AR_CMGT_CASE_FOLDERS, AR_CMGT_HOLD_DETAILS, and AR_CMGT_CF_RECOMMENDS — join on CREDIT_REQUEST_ID for case management, holds, and recommendations.
- HZ_PARTIES — referenced via PARTY_ID and CONTACT_PARTY_ID.
- HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL — referenced via CUST_ACCOUNT_ID, CUST_ACCT_SITE_ID, and SITE_USE_ID.
- AR_CMGT_CHECK_LISTS and AR_CMGT_SCORES — referenced via CHECK_LIST_ID and SCORE_MODEL_ID respectively.
-
The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request.
-
The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request.
-
eTRM - AR Tables and Views 12.1.1
Territory information
-
eTRM - AR Tables and Views 12.2.2
Territory information