Results for “reason_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CM_REAS_CDS is a reference (lookup) table owned by the GMF schema within Oracle E-Business Suite's Process Manufacturing Financials module. Its purpose is to store user-defined reason codes that classify why a cost adjustment was performed. Rather than forcing users into a fixed, system-supplied enumeration, Oracle EBS allows each organization to define its own set of reason codes so that cost adjustment activity can be categorized in a way that reflects local business policy, audit requirements, or management reporting conventions. Each row represents one valid reason code that may subsequently be attached to cost adjustment detail lines.

The table sits at the reference-data end of the Process Manufacturing costing model. It is consumed by transaction-level cost adjustment records and, in turn, points outward to the common text header infrastructure that stores descriptive narrative. Because the reason code itself carries the business meaning while the surrounding columns are largely operational bookkeeping, the heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. In modeling terms this suggests treating CM_REAS_CDS as a descriptive satellite keyed by its natural business key, rather than as an independent hub, since it enriches and constrains other cost objects rather than representing a standalone business event.

Key Information Stored

The documented physical schema comprises eleven columns. The most significant are:

• REASON_CODE — the primary key column and the single documented business-key candidate. It is enforced through the unique index CM_REAS_CDS_PK. This is the value users select when recording a cost adjustment reason.
• REASON_DESC — the human-readable description displayed on forms and reports alongside the code.
• TEXT_CODE — a foreign key to CM_TEXT_HDR, linking the reason code to extended text maintained in the common text header infrastructure.
• TRANS_CNT — a transaction counter, typically used for concurrency or reference-usage tracking.
• DELETE_MARK — the standard Oracle EBS soft-delete flag; codes are logically inactivated rather than physically removed.
• SUBLEDGER_IND — an indicator governing whether the reason code participates in subledger accounting treatment.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns recording who created and last modified each row and when.

The surrogate technical key enforced by CM_REAS_CDS_PK is REASON_CODE itself; there is no separate generated sequence column documented. REASON_CODE therefore serves simultaneously as the business key and the physical unique identifier.

Common Use Cases and Queries

Typical usage centers on validating adjustment reason codes, producing reason-code distribution reports, and joining reasons to cost adjustment detail for audit or variance analysis. Because only active (non-deleted) codes should be presented to users, most queries filter on DELETE_MARK.

A representative validation query returns the description for a given code:

• SELECT reason_code, reason_desc FROM gmf.cm_reas_cds WHERE reason_code = :p_code AND NVL(delete_mark, 0) = 0;

A reporting query aggregates adjustment activity by reason by joining to the detail table:

• SELECT r.reason_code, r.reason_desc, COUNT(*) adj_count FROM gmf.cm_reas_cds r, gmf.cm_adjs_dtl d WHERE r.reason_code = d.reason_code GROUP BY r.reason_code, r.reason_desc ORDER BY adj_count DESC;

Where narrative justification is captured, a join to CM_TEXT_HDR via TEXT_CODE retrieves the associated text header for expanded display.

Related Objects

• CM_ADJS_DTL — the primary dependent table. Its REASON_CODE column carries a foreign key to CM_REAS_CDS.REASON_CODE, meaning every cost adjustment detail line references a valid reason code defined here.
• CM_TEXT_HDR — referenced by CM_REAS_CDS.TEXT_CODE; supplies extended descriptive text associated with a reason code.

In practice, applications and concurrent programs within Process Manufacturing Financials that create or report on cost adjustments access CM_REAS_CDS for code validation and display, while the standard Oracle EBS WHO audit columns support change-tracking and security reporting across the object.