Search Results as_mc_type_mappings




Overview
Explore in AI Chat

Overview

The AS_MC_TYPE_MAPPINGS table is a core reference table within the Oracle E-Business Suite Sales Foundation (AS) module, specifically under the OSM (Oracle Sales Management) schema. Its primary function is to define a critical mapping relationship between different time period classifications and currency conversion types. This mapping is essential for ensuring accurate and consistent financial calculations, particularly for multi-currency transactions in sales operations. The table acts as a configuration hub, enabling the system to correctly associate a given reporting period (like a fiscal quarter or month) with the appropriate method or type of currency conversion required for revenue recognition, commission calculations, or sales credit reporting.

Key Information Stored

The table's structure is defined by a composite primary key, which underscores the uniqueness of the mapping it defines. The key columns are PERIOD_TYPE, CONVERSION_TYPE, and PERIOD_SET_NAME. The PERIOD_TYPE column identifies the classification of the accounting period (e.g., Month, Quarter). The CONVERSION_TYPE column specifies the type of currency conversion rule to be applied for that period. The PERIOD_SET_NAME column links to the specific financial calendar or period set being used by the organization. Together, these columns create a definitive rule that dictates how currency conversions are processed for sales data within a given timeframe and financial calendar.

Common Use Cases and Queries

The primary use case for AS_MC_TYPE_MAPPINGS is to support the denormalization and aggregation of multi-currency sales data. When generating reports on sales credits, revenues, or forecasts across different geographies, the system references this table to apply the correct historical or period-end conversion rates. A common administrative query would retrieve all configured mappings for a specific period set to validate setup. For reporting and data validation, a typical join would link this table to transactional data to verify the conversion logic applied.

  • Retrieving All Mappings: SELECT period_type, conversion_type, period_set_name FROM osm.as_mc_type_mappings;
  • Validating Mapping for a Transaction: Reports or validation scripts often join this table to the AS_MC_SALES_CREDITS_DEN table using the three primary key columns to confirm the conversion type used for a calculated figure.

Related Objects

The AS_MC_TYPE_MAPPINGS table has a direct and crucial relationship with the AS_MC_SALES_CREDITS_DEN table, which stores denormalized sales credit data. A foreign key constraint exists where the columns CONVERSION_PERIOD_TYPE, CONVERSION_TYPE, and CONVERSION_PERIOD_SET_NAME in AS_MC_SALES_CREDITS_DEN reference the primary key columns in AS_MC_TYPE_MAPPINGS. This ensures referential integrity, guaranteeing that every sales credit record with a conversion context points to a valid, pre-defined mapping rule. This relationship is foundational for the multi-currency calculation engine within the Sales Foundation module.