Results for “wf_amv_chn_roles”

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

Overview

WF_AMV_CHN_ROLES is a dictionary view owned by the APPS schema in Oracle E-Business Suite, classified under the FND – Application Object Library product. Its documented purpose is to serve as a Bulk Sync Directory Service Role View for Orig System AMV_CHN. In practical terms, the view presents channel definitions maintained by the Oracle Marketing (AMV) module in a canonical, directory-service-oriented format so that the Workflow Directory Services bulk synchronization process can treat those channels as addressable roles.

Oracle Workflow maintains a directory of roles — users, groups, and other addressable entities — that can be resolved during notification processing and routing. The bulk synchronization framework consumes adapter views that conform to a fixed column contract, allowing external or product-specific sources of role data to be loaded into the WF_LOCAL_ROLES and related directory tables. WF_AMV_CHN_ROLES is one such adapter view; it exposes channel records from Oracle Marketing as pseudo-roles identified by the originating system tag AMV_CHN.

Because the view is read by the synchronization engine rather than maintained directly, it has no DML surface and should be treated as a reporting and integration read-only object. It exists in both Oracle EBS 12.1.1 and 12.2.2 with the same definition and status VALID.

Underlying Base Objects

The view is defined over three synonyms that resolve to base tables in the APPS schema:

• AMV_C_CHANNELS_B — the base table holding channel header rows, including CHANNEL_ID and STATUS.
• AMV_C_CHANNELS_TL — the translation table holding language-specific channel names, joined on CHANNEL_ID and LANGUAGE.
• FND_LANGUAGES — the language and territory reference table, used to filter the row set to the session language.

The view text joins AMV_C_CHANNELS_B to AMV_C_CHANNELS_TL on CHANNEL_ID, then to FND_LANGUAGES on LANGUAGE_CODE, filtered by FNDL.LANGUAGE_CODE = USERENV('LANG'). This NLS-aware join ensures only the channel name in the current session language is returned, avoiding duplicate rows per translated language.

Key Columns

The projection follows the standard bulk synchronization role contract. Notable columns include:

• NAME — synthesized as 'AMV_CHN'||':'||CHANNEL_ID, producing a globally unique role name prefixed by the originating system.
• DISPLAY_NAME and DESCRIPTION — both populated from CHT.CHANNEL_NAME.
• NOTIFICATION_PREFERENCE — a literal 'QUERY', indicating how notifications should resolve the role.
• LANGUAGE and TERRITORY — taken from FND_LANGUAGES (NLS_LANGUAGE, NLS_TERRITORY).
• EMAIL_ADDRESS, FAX, SECURITY_GROUP_ID, EXPIRATION_DATE — returned as NULL.
• ORIG_SYSTEM — the literal 'AMV_CHN'; ORIG_SYSTEM_ID — CHB.CHANNEL_ID.
• START_DATE — NULL; STATUS — carried from CHB.STATUS.
• USER_FLAG — 'N', marking these as non-user roles; PARTITION_ID — literal 6.

Common Use Cases and Queries

Typical uses include auditing which channels will be synchronized as directory roles, verifying NLS name resolution, and troubleshooting sync failures by comparing view output with WF_LOCAL_ROLES. Because AMV_C_CHANNELS_TL can hold multiple translations, the session language filter is the most common source of unexpected result counts. The following queries illustrate standard access patterns:

• SELECT name, display_name, status FROM wf_amv_chn_roles ORDER BY name; — lists all channels as they will be registered.
• SELECT orig_system_id, display_name FROM wf_amv_chn_roles WHERE status = 'A'; — retrieves only active channels.
• SELECT COUNT(*) FROM wf_amv_chn_roles; — compares view cardinality against AMV_C_CHANNELS_B to detect translation-induced duplicates.
• SELECT r.name FROM wf_amv_chn_roles r WHERE NOT EXISTS (SELECT 1 FROM wf_local_roles l WHERE l.name = r.name); — identifies channels pending synchronization into the workflow directory.

All queries should be executed against the APPS schema with appropriate read privileges; no DML is permitted.