Search Results ar_cmgt_data_points_pkg
Overview
The APPS.AR_CMGT_DATA_POINTS_PKG package is a core component of the Oracle E-Business Suite Credit Management (Credit Management, or CMgt) module. Its role is to collect and consolidate the analytical "data points" that Oracle Credit Management uses to evaluate a customer's creditworthiness, calculate risk scores, and drive automated credit decisions, holds, and case workflows. In EBS 12.1.1 and 12.2.2, the package operates as an internal engine rather than an end-user API; it bridges the raw transactional and aging data held across Accounts Receivable tables and the structured Credit Management case, checklist, and scoring model. The object resides in the APPS schema and is reported as VALID in ETRM. It is classified as an OTHER API type, meaning it is intended primarily for internal consumption by other Credit Management programs rather than as a published external interface.
Key Procedures and Functions
The documented package exposes two program units:
- GATHER_DATA_POINTS — The primary entry point. This procedure assembles the set of financial and credit metrics (data points) associated with a Credit Management case and persists them for scoring and review. It is the routine that other Credit Management components invoke to refresh the values used in the credit decision process.
- GETFINANCIALDATA — A program unit that retrieves the financial information used to populate or return the computed data points, drawing from the customer's financial and transaction history maintained within Credit Management and Receivables.
Consistent with ETRM documentation practice, no parameter signatures are reproduced here; only the documented names and their purposes are described.
Tables Accessed
The package reads and writes across a broad set of Credit Management and Receivables tables via APPS synonyms, reflecting its role as an aggregation hub:
- Case and folder structures: AR_CMGT_CASE_FOLDERS, AR_CMGT_CASE_FOLDERS_S, AR_CMGT_CASE_FOLDER_NUMBER_S — define the credit case to which data points belong.
- Aging analysis: AR_AGING_BUCKETS, AR_AGING_BUCKET_LINES — supply receivable aging buckets used in risk assessment.
- Credit-specific details: AR_CMGT_CF_DNB_DTLS, AR_CMGT_CF_DTLS, AR_CMGT_CREDIT_REQUESTS, AR_CMGT_CURR_USAGE_GT — carry customer detail, credit requests, and current usage.
- Checklists and setup: AR_CMGT_CHECK_LISTS, AR_CMGT_CHECK_LIST_DTLS, AR_CMGT_SETUP_OPTIONS — drive configuration and scoring rules.
- Output and reference: AR_CMGT_FINANCIAL_DATA, AR_TRX_BAL_SUMMARY, AR_CORRESPONDENCES_ALL — store the resulting financial data and supporting balances and correspondence.
Usage Notes
As an OTHER-classified package, AR_CMGT_DATA_POINTS_PKG is not a public API: customers should not call it directly in custom code without understanding that its behavior may change across patches. It is referenced by three other packages — AR_CMGT_AGING, AR_CMGT_REFRESH_CONC, and AR_CMGT_WF_ENGINE — indicating that it is invoked during aging refresh, concurrent processing, and workflow-driven case evaluation. In practice, data points are refreshed when a Credit Management case is created or re-evaluated, when the aging/refresh concurrent program runs, or when the workflow engine traverses a case. Custom extensions that require the same metrics should ideally read from AR_CMGT_FINANCIAL_DATA after the standard refresh, rather than invoking GATHER_DATA_POINTS directly, to preserve upgrade safety.
-
PACKAGE: APPS.AR_CMGT_DATA_POINTS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_DATA_POINTS_PKG, status:VALID,
-
PACKAGE: APPS.AR_CMGT_DATA_POINTS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_DATA_POINTS_PKG, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CASE_FOLDERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CASE_FOLDERS, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CASE_FOLDERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CASE_FOLDERS, 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: APPS.AR_CMGT_DATA_POINTS_PKG
12.2.2
-
PACKAGE: APPS.AR_CMGT_DATA_POINTS_PKG
12.1.1
-
SYNONYM: APPS.AR_CMGT_FINANCIAL_DATA
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_FINANCIAL_DATA, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CURR_USAGE_GT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CURR_USAGE_GT, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CASE_FOLDERS_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CASE_FOLDERS_S, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CASE_FOLDER_NUMBER_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CASE_FOLDER_NUMBER_S, status:VALID,
-
PACKAGE: APPS.OE_CREDIT_EXPOSURE_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_CREDIT_EXPOSURE_PUB, status:VALID,
-
SYNONYM: APPS.AR_CORRESPONDENCES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CORRESPONDENCES_ALL, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CHECK_LIST_DTLS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CHECK_LIST_DTLS, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CASE_FOLDERS_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CASE_FOLDERS_S, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CURR_USAGE_GT
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CURR_USAGE_GT, status:VALID,
-
SYNONYM: APPS.AR_CORRESPONDENCES_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CORRESPONDENCES_ALL, status:VALID,
-
PACKAGE: APPS.AR_CMGT_SCORING_ENGINE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_SCORING_ENGINE, status:VALID,
-
PACKAGE: APPS.OE_CREDIT_EXPOSURE_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_CREDIT_EXPOSURE_PUB, status:VALID,
-
PACKAGE: APPS.HZ_DNBUI_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_DNBUI_PVT, status:VALID,
-
SYNONYM: APPS.AR_CMGT_FINANCIAL_DATA
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_FINANCIAL_DATA, status:VALID,
-
SYNONYM: APPS.AR_TRX_SUMMARY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_TRX_SUMMARY, status:VALID,
-
SYNONYM: APPS.AR_TRX_SUMMARY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_TRX_SUMMARY, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CHECK_LIST_DTLS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CHECK_LIST_DTLS, status:VALID,
-
PACKAGE: APPS.AR_CMGT_AGING
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_AGING, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CASE_FOLDER_NUMBER_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CASE_FOLDER_NUMBER_S, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CHECK_LISTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CHECK_LISTS, status:VALID,
-
PACKAGE: APPS.OCM_ADD_DATA_POINTS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OCM_ADD_DATA_POINTS, status:VALID,
-
PACKAGE: APPS.HZ_DNBUI_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_DNBUI_PVT, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CF_DNB_DTLS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CF_DNB_DTLS, status:VALID,
-
PACKAGE: APPS.HZ_CREDIT_USAGES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_CREDIT_USAGES_PKG, status:VALID,
-
PACKAGE: APPS.AR_CMGT_CONTROLS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_CONTROLS, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CF_DNB_DTLS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CF_DNB_DTLS, status:VALID,
-
PACKAGE: APPS.AR_CMGT_AGING
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_AGING, status:VALID,
-
PACKAGE: APPS.AR_CMGT_SCORING_ENGINE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_SCORING_ENGINE, status:VALID,
-
PACKAGE: APPS.OCM_ADD_DATA_POINTS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OCM_ADD_DATA_POINTS, status:VALID,
-
PACKAGE BODY: APPS.AR_CMGT_AGING
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_AGING, status:VALID,
-
SYNONYM: APPS.HZ_CREDIT_USAGE_RULE_SETS_B
12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_CREDIT_USAGE_RULE_SETS_B, status:VALID,
-
PACKAGE: APPS.HZ_CREDIT_USAGES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_CREDIT_USAGES_PKG, status:VALID,
-
SYNONYM: APPS.HZ_CREDIT_USAGE_RULE_SETS_B
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_CREDIT_USAGE_RULE_SETS_B, status:VALID,
-
SYNONYM: APPS.AR_CMGT_CHECK_LISTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_CHECK_LISTS, status:VALID,
-
PACKAGE: APPS.AR_CMGT_CONTROLS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_CMGT_CONTROLS, status:VALID,
-
PACKAGE BODY: APPS.AR_CMGT_AGING
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_AGING, status:VALID,
-
SYNONYM: APPS.AR_TRX_BAL_SUMMARY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_TRX_BAL_SUMMARY, status:VALID,
-
SYNONYM: APPS.AR_CMGT_SETUP_OPTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CMGT_SETUP_OPTIONS, status:VALID,
-
SYNONYM: APPS.AR_AGING_BUCKET_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_AGING_BUCKET_LINES, status:VALID,
-
SYNONYM: APPS.AR_TRX_BAL_SUMMARY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_TRX_BAL_SUMMARY, status:VALID,
-
PACKAGE BODY: APPS.AR_CMGT_REFRESH_CONC
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_CMGT_REFRESH_CONC, status:VALID,
-
SYNONYM: APPS.AR_AGING_BUCKET_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_AGING_BUCKET_LINES, status:VALID,