Results for “edr_xml_map_code”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
EDR_WFEVENT_XMLMAP_V is a public view owned by the APPS schema in Oracle E-Business Suite, carrying the FND Design Data identifier EDR.EDR_WFEVENT_XMLMAP_V. It is classified in the E-Business Suite Technical Reference Manual (ETRM) as a view "which may be useful for custom reporting or other data requirements." Its functional purpose is narrow and well defined: it exposes a cross-reference between the ERES (E-Business Suite electronic records and signatures) workflow event name and the corresponding XML Gateway map code. In EBS releases 12.1.1 and 12.2.2, this view is marked VALID and remains available in the standard APPS schema.
The view is relevant wherever ERES event subscriptions must be married to Oracle XML Gateway message definitions. Rather than joining workflow event metadata to XML Gateway map metadata manually, developers and integrators can query this view directly, which is particularly useful for auditing which business events carry an XML map code and for troubleshooting message generation where a subscription exists but no map code is resolvable. The search term "xml_mapcode" corresponds directly to the XML_MAPCODE column exposed by this view.
Underlying Base Objects
EDR_WFEVENT_XMLMAP_V is not a table; it is a stored query defined over the following documented base objects in the APPS schema:
- WF_EVENTS_VL (view) — the Workflow event definition view, supplying the event display name and event name values surfaced by the view.
- WF_EVENT_SUBSCRIPTIONS (synonym) — the Workflow event subscription entity, used to associate events with their subscriptions and related rules.
- WF_CORE (package) — the core Workflow engine package, whose functions are invoked to resolve event details.
- EDR_INDEXED_XML_UTIL (package) — the ERES utility package responsible for indexed XML handling; this package is the source of the XML map code resolution logic.
Consistent with its classification, the view is not referenced by any other database object; it sits at the top of its dependency chain as a read-only reporting artifact. It does not own data and does not participate in transactional processing.
Key Columns
The view exposes four columns, each documented in the ETRM metadata:
- OWNER_APPLICATION — VARCHAR2(30). The application that owns the workflow event, allowing results to be partitioned by product or module.
- EVENT_DISPLAY_NAME — VARCHAR2(80). The user-facing label for the event, suitable for display in reports and diagnostic output.
- EVENT_NAME — VARCHAR2(240). The internal Workflow event name, which is the key used by subscriptions and by the Workflow Business Events system.
- XML_MAPCODE — VARCHAR2(4000). The XML Gateway map code associated with the event. This is the column a user searching for "xml_mapcode" is seeking; it provides the mapping identifier required by XML Gateway to transform and transmit the event payload.
Common Use Cases and Queries
The predominant use cases are reporting on the ERES-to-XML Gateway cross-reference, verifying that an event has a configured map code before enabling an outbound integration, and auditing map codes after an upgrade or patch. The view can also support custom reporting on event subscriptions where the standard ERES or Workflow user interfaces do not expose the map code directly.
A basic query mirrors the documented query text:
SELECT OWNER_APPLICATION, EVENT_DISPLAY_NAME, EVENT_NAME, XML_MAPCODE FROM APPS.EDR_WFEVENT_XMLMAP_V;- To filter by application:
SELECT EVENT_NAME, XML_MAPCODE FROM APPS.EDR_WFEVENT_XMLMAP_V WHERE OWNER_APPLICATION = '&app_name'; - To locate a specific map code:
SELECT EVENT_DISPLAY_NAME, EVENT_NAME FROM APPS.EDR_WFEVENT_XMLMAP_V WHERE XML_MAPCODE = '&mapcode'; - To identify events lacking a map code:
SELECT EVENT_NAME FROM APPS.EDR_WFEVENT_XMLMAP_V WHERE XML_MAPCODE IS NULL;
Because the view is read-only and defined over Workflow and ERES utility objects, queries should be issued with the APPS schema or a suitably privileged custom user, typically with read-only access in production environments.
-
View: EDR_WFEVENT_XMLMAP_V 12.2.2
View containing X-ref of ERES event name and its XML gateway map code
APPS.EDR_WFEVENT_XMLMAP_V·↳ EDR_INDEXED_XML_UTIL·↳ WF_CORE·↳ WF_EVENTS_VL·Explore EDR module →
-
View: EDR_WFEVENT_XMLMAP_V 12.1.1
View containing X-ref of ERES event name and its XML gateway map code
APPS.EDR_WFEVENT_XMLMAP_V·↳ EDR_INDEXED_XML_UTIL·↳ WF_CORE·↳ WF_EVENTS_VL·Explore EDR module →
-
PACKAGE: APPS.GME_ERES_PKG 12.1.1
-
PACKAGE: APPS.GME_ERES_PKG 12.2.2