Results for “ams_categories_v”

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

Overview

AMS_CATEGORIES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, classified under the AMS (Marketing) product family. It returns the marketing categories that are used in marketing deliverables and marketing events. The view consolidates category header attributes with their parent category information in a single denormalized result set, allowing callers to resolve both the category and its hierarchical parent without a separate lookup.

Because marketing categories can carry financial posting attributes, the view is frequently referenced in integration and reporting scenarios that bridge Marketing and Payables. The user search term "accrued_liability_account" maps directly to the ACCRUED_LIABILITY_ACCOUNT column exposed by this view, which is the account used when accruing liabilities associated with marketing activity tied to the category. This makes AMS_CATEGORIES_V a practical source for validation lists and reconciliation queries that inspect the accounting setup of marketing categories.

Underlying Base Objects

The view is defined over two documented base objects:

• AMS_CATEGORIES_VL (VIEW) — the multi-language category entity, referenced twice in the view definition: once as ACAT (the category itself) and once as PCAT (the parent category).
• AMS_UTILITY_PVT (PACKAGE) — invoked through AMS_UTILITY_PVT.GET_LOOKUP_MEANING to resolve the lookup meaning for the ARC_CATEGORY_CREATED_FOR lookup code.

The view performs an outer join between the two AMS_CATEGORIES_VL aliases on the condition ACAT.PARENT_CATEGORY_ID = PCAT.CATEGORY_ID(+). A category with no parent therefore still appears in the result, with the parent columns returning NULL. This structure preserves the full category population while enriching each row with parent context where one exists.

Key Columns

• CATEGORY_ID — primary identifier for the marketing category; used as the join key to the parent alias.
• CATEGORY_NAME / DESCRIPTION — the category's display attributes.
• PARENT_CATEGORY_ID, PARENT_CATEGORY_NAME, PARENT_CATEGORY_DESCRIPTION — resolved parent hierarchy values, null when no parent exists.
• ACCRUED_LIABILITY_ACCOUNT — the accrued liability account associated with the category, relevant to accrual accounting for marketing transactions.
• DED_ADJUSTMENT_ACCOUNT — the account used for deduction adjustments.
• ARC_CATEGORY_CREATED_FOR — the lookup code indicating the purpose for which the category was created.
• CREATED_FOR_MEANING — the decoded lookup meaning, derived via AMS_UTILITY_PVT.GET_LOOKUP_MEANING against the AMS_SYS_ARC_QUALIFIER lookup type.
• ENABLED_FLAG and OBJECT_VERSION_NUMBER — status and optimistic locking control.
• CREATION_DATE — audit timestamp.

Common Use Cases and Queries

Typical scenarios include reconciling marketing categories that hold accrual or deduction account assignments, validating accounting configuration before period close, and populating category selection lists in custom extensions or reports. The following query lists enabled categories together with their accrual and deduction accounts:

• SELECT category_id, category_name, accrued_liability_account, ded_adjustment_account FROM ams_categories_v WHERE enabled_flag = 'Y';
• SELECT category_name, parent_category_name, created_for_meaning FROM ams_categories_v WHERE parent_category_id IS NOT NULL;
• SELECT COUNT(1) FROM ams_categories_v WHERE accrued_liability_account IS NULL AND enabled_flag = 'Y';

The third query supports exception reporting, surfacing enabled categories that lack an accrued liability account — a condition that may indicate incomplete accounting setup. Because the view joins only category metadata, queries remain lightweight and suitable for operational reporting.