Search Results ar_cmgt_check_lists

Overview

The AR_CMGT_CHECK_LISTS table in the Oracle Receivables (AR) module of Oracle E-Business Suite 12.1.1 and 12.2.2 stores the credit policy definitions maintained by an organization within the Credit Management subsystem. Each row in the table represents a discrete credit checklist, which defines the specific data points, review requirements, and evaluation criteria applied to a given type of credit review. Credit analysts, collections personnel, and automated credit processes reference these checklists to ensure that every credit evaluation consistently captures the information mandated by the organization's internal credit policy.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as a standalone data vault entity. In practice this reflects the fact that AR_CMGT_CHECK_LISTS is a reference or master data table that is not itself subordinated to a larger parent record, but which is instead referenced by other transactional or workflow tables within the Credit Management schema. This classification should be treated as a modeling suggestion rather than a strict constraint, since the table does participate in relationships through its SCORE_MODEL_ID foreign key.

Key Information Stored

The table is anchored by the surrogate primary key CHECK_LIST_ID, which is enforced by the unique index AR_CMGT_CHECK_LISTS_U1 (also defined as AR_CMGT_CHECK_LISTS_PK). The remaining columns capture the business definition of the checklist:

CHECK_LIST_NAME – the user-facing identifier for the checklist.
DESCRIPTION and NOTES – free-form explanatory text about the checklist's purpose.
START_DATE and END_DATE – the effective date range during which the checklist is active.
CREDIT_POLICY_STATEMENT – the narrative statement of the credit policy embodied by the checklist.
CREDIT_CLASSIFICATION – the customer credit classification to which the checklist applies.
REVIEW_TYPE – the category of credit review governed by the checklist.
SCORE_MODEL_ID – a foreign key reference to AR_CMGT_SCORES, linking the checklist to a scoring model.
SUBMIT_FLAG and USER_DEFINED_FLAG – status indicators controlling submission behavior and identifying user-defined versus seeded checklists.
INCLUDE_ALL_CURRENCIES – controls whether the checklist applies across all currencies.
Standard WHO columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting requirements involve identifying active checklists for a given review type, resolving the associated score model, and enumerating the credit requests that consumed a specific checklist. A representative query joins checklists to their credit requests:

SELECT cl.CHECK_LIST_NAME, cr.CREDIT_REQUEST_ID FROM AR_CMGT_CHECK_LISTS cl, AR_CMGT_CREDIT_REQUESTS cr WHERE cl.CHECK_LIST_ID = cr.CHECK_LIST_ID AND SYSDATE BETWEEN cl.START_DATE AND cl.END_DATE;
Joining AR_CMGT_CHECK_LISTS to AR_CMGT_SCORES on SCORE_MODEL_ID to report which scoring model backs each checklist.
Filtering by USER_DEFINED_FLAG to distinguish seeded credit policies from organization-specific ones.

Related Objects

AR_CMGT_CHECK_LISTS is referenced by the following primary objects, which should be used in joins when tracing the lifecycle of a credit review:

AR_CMGT_CREDIT_REQUESTS – references AR_CMGT_CHECK_LISTS.CHECK_LIST_ID.
AR_CMGT_CASE_FOLDERS – references AR_CMGT_CHECK_LISTS.CHECK_LIST_ID.
AR_CMGT_SCORES – the parent of SCORE_MODEL_ID, referenced by AR_CMGT_CHECK_LISTS.

Table: AR_CMGT_CHECK_LISTS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CMGT_CHECK_LISTS, object_name:AR_CMGT_CHECK_LISTS, status:VALID, product: AR - Receivables , description: The AR_CMGT_CHECK_LISTS table stores information about your organizations credit policies. Each checklist defines what data points and requirements exist for different types of credit reviews. , implementation_dba_data: AR.AR_CMGT_CHECK_LISTS ,
Table: AR_CMGT_CHECK_LISTS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CMGT_CHECK_LISTS, object_name:AR_CMGT_CHECK_LISTS, status:VALID, product: AR - Receivables , description: The AR_CMGT_CHECK_LISTS table stores information about your organizations credit policies. Each checklist defines what data points and requirements exist for different types of credit reviews. , implementation_dba_data: AR.AR_CMGT_CHECK_LISTS ,
VIEW: AR.AR_CMGT_CHECK_LISTS# 12.2.2
owner:AR, object_type:VIEW, object_name:AR_CMGT_CHECK_LISTS#, status:VALID,
SYNONYM: APPS.AR_CMGT_CHECK_LISTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CHECK_LISTS, status:VALID,
SYNONYM: APPS.AR_CMGT_CHECK_LISTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CHECK_LISTS, status:VALID,
VIEW: AR.AR_CMGT_CHECK_LISTS# 12.2.2
APPS.AR_CMGT_REVIEW_CONC SQL Statements 12.1.1
APPS.AR_CMGT_REVIEW_CONC SQL Statements 12.2.2
TABLE: AR.AR_CMGT_CHECK_LISTS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CMGT_CHECK_LISTS, object_name:AR_CMGT_CHECK_LISTS, status:VALID,
TABLE: AR.AR_CMGT_CHECK_LISTS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CMGT_CHECK_LISTS, object_name:AR_CMGT_CHECK_LISTS, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_CREDIT_REQUEST_API 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_CREDIT_REQUEST_API, status:VALID,
PACKAGE BODY: APPS.OCM_DATA_POINTS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OCM_DATA_POINTS_PUB, status:VALID,
PACKAGE BODY: APPS.OCM_DATA_POINTS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OCM_DATA_POINTS_PUB, status:VALID,
APPS.OCM_DATA_POINTS_PUB SQL Statements 12.2.2
PACKAGE BODY: APPS.AR_CMGT_CREDIT_REQUEST_API 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_CREDIT_REQUEST_API, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_REVIEW_CONC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_REVIEW_CONC, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_REVIEW_CONC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_REVIEW_CONC, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_UTIL, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_UTIL, status:VALID,
APPS.OCM_DATA_POINTS_PUB SQL Statements 12.1.1
PACKAGE BODY: APPS.AR_CMGT_WF_ENGINE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_WF_ENGINE, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_DATA_POINTS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_DATA_POINTS_PKG, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_DATA_POINTS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_DATA_POINTS_PKG, status:VALID,
PACKAGE BODY: APPS.AR_CMGT_WF_ENGINE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_WF_ENGINE, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.AR_CMGT_UTIL SQL Statements 12.2.2
APPS.AR_CMGT_UTIL SQL Statements 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.AR_CMGT_CREDIT_REQUEST_API SQL Statements 12.1.1
APPS.AR_CMGT_CREDIT_REQUEST_API SQL Statements 12.2.2
PACKAGE BODY: APPS.AR_CMGT_REVIEW_CONC 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.AR_CMGT_REVIEW_CONC 12.1.1
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.OCM_DATA_POINTS_PUB 12.2.2
PACKAGE BODY: APPS.OCM_DATA_POINTS_PUB 12.1.1
12.2.2 FND Design Data 12.2.2
APPS.OCM_DATA_POINTS_PUB dependencies on AR_CMGT_CHECK_LISTS 12.1.1
APPS.AR_CMGT_REVIEW_CONC dependencies on AR_CMGT_CHECK_LISTS 12.2.2
APPS.AR_CMGT_REVIEW_CONC dependencies on AR_CMGT_CHECK_LISTS 12.1.1
APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on AR_CMGT_CHECK_LISTS 12.2.2
APPS.OCM_DATA_POINTS_PUB dependencies on AR_CMGT_CHECK_LISTS 12.2.2
APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CHECK_LISTS 12.2.2
APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CHECK_LISTS 12.1.1
APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on AR_CMGT_CHECK_LISTS 12.1.1