Results for “confo_reqd”

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

Overview

XTR_CONFIRMATION_ACTIONS_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents confirmation action setup data used by the Treasury confirmation subsystem, exposing which deal types and action types require dealer confirmation and how those combinations are grouped. The view is a thin projection over its base table and does not perform joins or aggregation, so it behaves as a filtered, read-only presentation of the same rows stored in XTR_CONFIRMATION_ACTIONS. Because confirmation requirements are configuration-driven, this view is typically consumed by concurrent programs, validation logic, and reporting layers that determine whether a trade or deal action must be confirmed before it can proceed.

Underlying Base Objects

The view is defined over a single base object, XTR_CONFIRMATION_ACTIONS, which is accessed through a synonym. The documented view text is a direct column projection:

• SELECT CONFO_ACTION_GROUP, GROUP_DESC, DEAL_TYPE, ACTION_TYPE, CONFO_REQD FROM XTR_CONFIRMATION_ACTIONS

No WHERE clause, DISTINCT, join, or function is applied. Consequently the view returns exactly the rows present in the base table and inherits all of its filtering, security, and indexing characteristics. Any change to the base table, such as an insert of a new confirmation rule or an update to the CONFO_REQD flag, is immediately reflected in the view. The APPS synonym indicates the standard EBS practice of directing application code through the APPS schema rather than referencing the table owner directly.

Key Columns

The view exposes five columns, all sourced from the base table:

• CONFO_ACTION_GROUP — Identifier for the confirmation action group. Groups collect related confirmation rule entries so that a set of deal and action combinations can be managed and referenced as a unit.
• GROUP_DESC — Descriptive text for the confirmation action group. This is the column most relevant to users searching on "group_desc", since it provides the human-readable label for the group identifier and is commonly used in list-of-values queries, reports, and lookup screens.
• DEAL_TYPE — The Treasury deal type to which the rule applies, distinguishing instruments such as foreign exchange, money market, or other Treasury deal categories.
• ACTION_TYPE — The action performed against the deal for which confirmation may be required.
• CONFO_REQD — Flag indicating whether dealer confirmation is required for the given deal type and action type combination. This drives whether the confirmation workflow is triggered.

Common Use Cases and Queries

The view supports setup validation, confirmation processing, and reporting. A frequent requirement is resolving a group identifier to its description, which is why the "group_desc" column attracts attention. Typical queries include retrieving all rules for a specific group, listing every deal and action combination that requires confirmation, and joining the view to deal data to decide whether a confirmation step should be initiated.

• Retrieve all rules for a group:
  SELECT confo_action_group, group_desc, deal_type, action_type, confo_reqd FROM xtr_confirmation_actions_v WHERE confo_action_group = :p_group;
• List combinations requiring confirmation:
  SELECT deal_type, action_type, group_desc FROM xtr_confirmation_actions_v WHERE confo_reqd = 'Y' ORDER BY deal_type, action_type;
• Look up a group description by identifier:
  SELECT DISTINCT group_desc FROM xtr_confirmation_actions_v WHERE confo_action_group = :p_group;

Because the view contains only configuration rows, it does not store transaction-level confirmation records; those reside in other Treasury confirmation objects. The view is best treated as a reference source for determining, at run time, whether confirmation is mandated for a given deal and action combination.