Results for “ams_dm_org_profit_v”

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

Overview

The view AMS_DM_ORG_PROFIT_V is an Oracle E-Business Suite database object owned by the APPS schema and registered under the AMS – Marketing product family. In both Oracle EBS 12.1.1 and 12.2.2 it carries a documented status of VALID, meaning the object compiles successfully and can be queried, but its functional purpose is deliberately absent. The ETRM metadata states plainly that the view is “Not used” and is “stubbed out with dummy column.” This is a placeholder object rather than a functional reporting or integration artifact.

Within Oracle EBS, the AMS schema contains numerous data-mart and marketing intelligence objects. Some of these were reserved during design or upgrade cycles to satisfy naming conventions, dependency references, or anticipated future functionality. AMS_DM_ORG_PROFIT_V falls into this category. Its presence does not expose organizational profitability data, despite the suggestive name, and it should not be used in reporting, extracts, or interfaces as a source of marketing or financial information.

Underlying Base Objects

The documented view text is minimal and unambiguous:

• SELECT DUMMY FROM DUAL

The only referenced base object recorded in the ETRM metadata is DUAL, accessed through its public synonym. DUAL is the standard Oracle single-row, single-column pseudo-table used for expression evaluation and constant selection. It contains no application data.

Because the definition resolves entirely to DUAL, the view has no dependency on any AMS transactional or marketing tables such as campaign, list, or organization master data. No joins, filters, or aggregations against application tables are present. Consequently, the view neither reflects nor derives from any operational EBS data, and its result set is static and content-free.

Key Columns

The view exposes a single column, documented as follows:

• PARTY_ID — Despite its name, this column does not return a party identifier from any EBS entity. It maps to the DUMMY column of DUAL, which is defined as a VARCHAR2(1) containing the literal value 'X'. The column name is a naming placeholder only; it carries no reference to HZ_PARTIES, HZ_CUST_ACCOUNTS, or any related party model.

There are no other documented columns. Any query returns exactly one row, with PARTY_ID equal to 'X'. Developers should not assume the column is numeric, indexed, or joinable, and should not attempt to cast or compare it against real party identifiers.

Common Use Cases and Queries

There is no legitimate business use case for this view. It is not consumed by standard Oracle EBS marketing reports, concurrent programs, or interfaces, and Oracle does not document it as a supported data source. Its existence is best understood as an internal stub retained for object-name consistency and dependency safety.

For completeness, the only technically valid query mirrors the view definition:

• SELECT party_id FROM apps.ams_dm_org_profit_v; — returns a single row containing 'X'.

Typical consequences of misusing the object include misleading output in custom reports and failed joins. A query such as SELECT * FROM apps.ams_dm_org_profit_v WHERE party_id = 12345; returns no rows because the value is character 'X', not a number.

When building organizational profitability or marketing analytics in Oracle EBS 12.1.1 or 12.2.2, developers should source data from the actual AMS and Oracle Marketing tables and the standard party model rather than from this placeholder. Attempting to extend or repurpose the view is unsupported and should be avoided.