Results for “as_mc_type_mappings”

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

Overview

AS_MC_TYPE_MAPPINGS is a configuration table owned by the OSM schema within the AS (Sales Foundation) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It defines the mapping relationship between a period and a conversion type, and as such acts as a lookup that drives how multichannel sales credit conversion logic is resolved at runtime. The table is a foundational reference object rather than a transactional table: it holds setup data that other Sales Foundation entities consult when converting or translating sales credit information across periods.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object is hub-leaning. Its primary key, AS_MC_TYPE_MAPPINGS_PK, is composed of three columns: PERIOD_TYPE, CONVERSION_TYPE, and PERIOD_SET_NAME. Because the table presents a stable set of business keys with descriptive attributes rather than a many-to-many association between distinct hubs, treating it as a hub (with associated descriptive attributes) is a reasonable modeling suggestion. It is referenced by dependent credit tables and itself references a security grouping table.

Key Information Stored

The table contains twelve documented columns. The most significant are the three key columns that form the composite primary key and business key:

• PERIOD_SET_NAME — identifies the accounting period set to which the mapping applies; part of the composite primary key and also part of the unique index.
• PERIOD_TYPE — the period type used in the mapping (for example, a fiscal or calendar period classification); part of the composite primary key.
• CONVERSION_TYPE — the target conversion type that the period maps to; the third component of the primary key.
• DESCRIPTION — free-text description of the mapping for administrative and reporting clarity.
• UPDATEABLE_FLAG — indicates whether the mapping record may be modified.
• DELETEABLE_FLAG — indicates whether the mapping record may be deleted.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing row-level security and multi-organization access control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns capturing who created and last modified each row and when.

The surrogate-style composite primary key is AS_MC_TYPE_MAPPINGS_PK (PERIOD_TYPE, CONVERSION_TYPE, PERIOD_SET_NAME). A separate unique index, AS_MC_TYPE_MAPPINGS_U1, covers (PERIOD_SET_NAME, PERIOD_TYPE), representing an additional business-key candidate and preventing duplicate period/period-set combinations.

Common Use Cases and Queries

The primary use case is resolving which conversion type applies to a given period set and period type when processing sales credit conversion for multichannel sales. Reporting and validation queries typically join this table to the dependent credit detail table.

• Retrieve all mappings for a period set: SELECT period_type, conversion_type, description FROM as_mc_type_mappings WHERE period_set_name = :p_set;
• Validate that a conversion type exists before posting: SELECT 1 FROM as_mc_type_mappings WHERE period_set_name = :p_set AND period_type = :p_type AND conversion_type = :c_type;
• Join to dependent credits: SELECT d.*, m.conversion_type FROM as_mc_sales_credits_den d, as_mc_type_mappings m WHERE d.conversion_period_type = m.period_type AND d.conversion_type = m.conversion_type AND d.conversion_period_set_name = m.period_set_name;
• List rows modifiable by administrators using UPDATEABLE_FLAG and DELETEABLE_FLAG.
• Restrict results by security group using SECURITY_GROUP_ID for multi-org reporting.

Related Objects

The following objects are most significant in relation to AS_MC_TYPE_MAPPINGS:

• AS_MC_SALES_CREDITS_DEN — the primary dependent table. It references this table through three columns: CONVERSION_PERIOD_TYPE, CONVERSION_TYPE, and CONVERSION_PERIOD_SET_NAME, matching the composite key of AS_MC_TYPE_MAPPINGS.
• FND_SECURITY_GROUPS — referenced by AS_MC_TYPE_MAPPINGS.SECURITY_GROUP_ID, providing row-level security partitioning.
• AS_MC_TYPE_MAPPINGS_PK — the composite primary key constraint (PERIOD_TYPE, CONVERSION_TYPE, PERIOD_SET_NAME).
• AS_MC_TYPE_MAPPINGS_U1 — the unique business-key index on (PERIOD_SET_NAME, PERIOD_TYPE).
• Sales Foundation setup and multichannel credit conversion programs that read this mapping during period-close and credit-conversion processing.

Because the table is small and setup-oriented, DBAs should treat changes as configuration rather than transactional data and audit updates through the standard EBS audit columns.