Search Results ar_cmgt_auto_recommends




Overview
Explore in AI Chat

Overview

The AR_CMGT_AUTO_RECOMMENDS table is an Oracle Receivables (AR) data object that stores the credit recommendations produced by automated credit reviews. It belongs to the Credit Management (CMGT) functional area within Receivables, where automated credit rules evaluate customer accounts, exposure, and payment behavior, then generate a recommendation outcome that can be reviewed and acted upon by credit analysts or applied programmatically. The table resides in the AR schema and is classified as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2.

Within a heuristic Data Vault classification derived from its foreign key structure, this table leans toward a satellite model. Each row describes attributes and outcomes attached to an automated credit rule evaluation rather than acting as an independent business hub or a many-to-many link between two hubs. This modeling suggestion reflects the table's role as a descriptive record of recommendation results, keyed to the underlying rule detail that drove the evaluation.

Key Information Stored

The table is documented with 13 columns. The most significant are:

Common Use Cases and Queries

Credit analysts and reporting developers query this table to review the recommendations generated by automated credit rules, compare recommended versus applied credit limits, and audit which rule details produced a given outcome. A typical join retrieves recommendations alongside their originating rule details:

SELECT r.auto_rule_recommendation_id,
       r.recommendation_name,
       r.credit_type,
       r.recommendation_value1,
       d.auto_rule_details_id
FROM   ar.ar_cmgt_auto_recommends r,
       ar.ar_cmgt_auto_rule_dtls d
WHERE  r.auto_rule_details_id = d.auto_rule_details_id
AND    r.credit_type = :credit_type;

Additional patterns include filtering recommendations by creation date for periodic credit review reports, aggregating by credit_type to measure recommendation volumes, and joining to FND_APPLICATION to confirm application ownership. Because the table is satellite-leaning, reporting typically joins outward to rule details rather than treating it as a standalone dimension.

Related Objects

  • AR_CMGT_AUTO_RULE_DTLS — Referenced via AUTO_RULE_DETAILS_ID; the rule detail driving each recommendation.
  • FND_APPLICATION — Referenced via APPLICATION_ID; the owning application definition.
  • AR_CMGT_AUTO_RULE — Parent rule header, related through rule detail lineage.
  • AR_CUSTOMERS — Customer records evaluated during automated credit review.
  • AR_CMGT_CREDIT_REVIEWS — Credit review processing that consumes recommendation results.
  • AR_CMGT_PROFILE — Credit profile setup governing rule execution.
  • AR_CMGT_AUTO_RECOMMENDS_U1 — Unique index enforcing the primary key.

Collectively, these objects support the automated credit review workflow from rule definition through recommendation, review, and credit decision.