Results for “won_amount”

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

Overview

The AS_MC_SALES_CREDITS_DEN table is a multi-currency denormalized table within the Oracle E-Business Suite Sales Foundation (AS) product family. It stores sales credit amounts that have been converted into various reporting currencies, calculated using both daily exchange rates and pseudo period rates. The table is owned by the OSM schema and is documented as VALID in Oracle ETRM for releases 12.1.1 and 12.2.2.

This object plays a supporting role in the sales credit compensation and reporting flow. Where AS_SALES_CREDITS_DENORM captures the transactional sales credit detail in the source currency, AS_MC_SALES_CREDITS_DEN holds the currency-converted equivalents required for global reporting, revenue analysis, and incentive calculations across multiple ledgers and reporting currencies.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests this table functions as a link. It connects the sales credit transaction (via SALES_CREDIT_ID) to currency conversion context objects — conversion type mappings, GL periods, and security groups — establishing relationships rather than acting as a standalone hub or a pure satellite attribute store.

Key Information Stored

The table contains 27 documented columns. The most significant are listed below, distinguishing surrogate key from business-key columns.

• MC_SALES_CREDIT_ID — Surrogate primary key. Backed by unique index AS_MC_SALES_CREDITS_DEN_U1 and constraint AS_MC_SALES_CREDITS_DEN_PK. Also serves as a documented business-key candidate.
• SALES_CREDIT_ID — Foreign key to AS_SALES_CREDITS_DENORM, linking each converted row back to its originating sales credit transaction.
• TO_CURRENCY_CODE / FROM_CURRENCY_CODE — The target and source currencies applied for the conversion.
• CONVERSION_TYPE and CONVERSION_PERIOD_TYPE — Define the exchange rate mechanism; referenced by AS_MC_TYPE_MAPPINGS.
• CONVERSION_PERIOD_SET_NAME and CONVERSION_PERIOD_NAME — Accounting period context, with foreign keys to GL_PERIODS.
• CONVERSION_DATE — The date used to determine the applicable rate for daily-rate conversions.
• TOTAL_AMOUNT, SALES_CREDIT_AMOUNT, WON_AMOUNT, WEIGHTED_AMOUNT — Converted monetary amounts for the sales credit, including weighted and "won" measures used in compensation logic.
• CONVERSION_STATUS_FLAG, CONVERSION_RATE_STATUS, CONVERSION_RATE_FOUND — Flags indicating conversion success, rate availability, and processing outcome.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data access.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program audit columns identifying the process that generated each row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical usage centers on multi-currency sales compensation and revenue reporting. A common pattern joins this table to its parent transaction table to report converted credit amounts per salesperson or period:

SELECT s.sales_credit_id,
       m.to_currency_code,
       m.conversion_period_name,
       m.sales_credit_amount,
       m.weighted_amount
FROM   as_sales_credits_denorm s,
       as_mc_sales_credits_den m
WHERE  s.sales_credit_id = m.sales_credit_id
AND    m.conversion_status_flag = 'Y';

Other scenarios include reconciling failed conversions by filtering on CONVERSION_RATE_FOUND = 'N' or CONVERSION_RATE_STATUS, auditing the impact of a specific concurrent request through REQUEST_ID, and reporting converted pipeline or won amounts by period set for a given reporting currency.

Related Objects

• AS_SALES_CREDITS_DENORM — Parent source of sales credit transactions; joined on SALES_CREDIT_ID.
• AS_MC_TYPE_MAPPINGS — Defines conversion type and period type mappings referenced by CONVERSION_TYPE, CONVERSION_PERIOD_TYPE, and CONVERSION_PERIOD_SET_NAME.
• GL_PERIODS — Provides period validation via CONVERSION_PERIOD_SET_NAME and CONVERSION_PERIOD_NAME.
• FND_SECURITY_GROUPS — Enforces security group partitioning through SECURITY_GROUP_ID.