Search Results ar_cmgt_setup_options




Overview
Explore in AI Chat

Overview

The AR_CMGT_SETUP_OPTIONS table is a configuration repository within the Oracle Receivables (AR) module that stores the parameters used to customize Oracle Credit Management. Residing in the AR schema and remaining valid across Oracle E-Business Suite releases 12.1.1 and 12.2.2, this table typically holds a single row of setup values that govern how credit review processes, scoring, aging analysis, and appeal handling behave for an operating unit or a shared configuration. Because Credit Management drives credit limit recommendations, scoring, and credit review workflow decisions, the options captured here materially influence downstream credit decisions and customer exposure management.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is standalone. In practical terms, this suggests the table behaves much like a reference or configuration set rather than a transaction hub or link, since it does not accumulate high volumes of event records but instead maintains a controlled set of setup attributes. Modeling it as a satellite or reference table keyed to the Credit Management configuration context is a reasonable suggestion.

Key Information Stored

The documented physical schema for 12.2.2 comprises 13 columns. The most significant are:

The audit columns follow the standard WHO-column convention. No explicit surrogate primary key column is documented in the excerpt, though the configuration nature of the table implies a controlled, low-cardinality key. AGING_BUCKET_ID is the sole documented foreign key and is the primary business-key candidate for joining to aging definitions.

Common Use Cases and Queries

Typical uses include retrieving current Credit Management configuration for reconciliation, validating that the correct aging bucket and credit classification are in force, and reporting on default exchange rate and appeal authorization settings. A representative query joins the setup to the aging bucket definition:

  • SELECT s.PERIOD, s.CER_DSO_DAYS, s.DEFAULT_CREDIT_CLASSIFICATION, a.BUCKET_NAME FROM AR.AR_CMGT_SETUP_OPTIONS s, AR.AR_AGING_BUCKETS a WHERE s.AGING_BUCKET_ID = a.AGING_BUCKET_ID;
  • Audit queries selecting LAST_UPDATE_DATE, LAST_UPDATED_BY, and CREATION_DATE to trace configuration changes over time.
  • Reporting queries exposing APPEAL_AUTHORIZE_DAYS and DEFAULT_EXCHANGE_RATE_TYPE for credit policy compliance reviews.

Related Objects

The most significant related objects are:

  • AR_AGING_BUCKETS — Joined via AGING_BUCKET_ID; supplies the aging bucket definition referenced by the setup.
  • AR_CMGT_SETUP_OPTIONS (configuration foundation) — Consumed by Credit Management scoring and review processes.
  • Credit Management scoring and credit review objects that read these options to drive default credit classification and DSO calculations.
  • Customer and credit profile tables influenced by DEFAULT_CREDIT_CLASSIFICATION.
  • Receipt and matching rule objects associated with MATCH_RULE_ID and AUTO_APPLICATION_NUM_FLAG.

Because the table is standalone in the documented FK structure, its principal dependency is the aging bucket reference, and it functions as a configuration anchor read by Credit Management processes rather than a transactional driver.