Results for “xdp_wi_parameters”

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

Overview

XDP_WI_PARAMETERS is a Provisioning (XDP) module table in the Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the parameter definitions and associated behavioural properties for each work item processed by the XDP work item engine. In EBS provisioning flows, a work item represents a discrete unit of work — an approval task, a service activation step, a fulfilment action — and each work item typically requires one or more input or output parameters. XDP_WI_PARAMETERS is the repository where those parameters are declared, validated, evaluated, sequenced, and defaulted.

From a dimensional modelling perspective, the documented foreign key structure suggests a satellite-leaning classification: the table is keyed on the parent work item (WORKITEM_ID, PARAMETER_NAME) and carries descriptive attributes such as default values, evaluation sequence, validation procedures, and audit flags. It is best treated as a child satellite of XDP_WORKITEMS rather than an independent hub, although the unique index including ZD_EDITION_NAME introduces edition-aware behaviour in 12.2.2.

Key Information Stored

The table contains 19 documented columns. The most significant are:

• WORKITEM_ID — foreign key to XDP_WORKITEMS; identifies the parent work item this parameter belongs to.
• PARAMETER_NAME — the business name of the parameter; combined with WORKITEM_ID and ZD_EDITION_NAME this forms the unique index XDP_WI_PARAMETERS_U1.
• WI_PARAMETER_ID — surrogate identifier for the parameter row.
• EVALUATION_MODE and EVALUATION_SEQ — control how and in what order the parameter is evaluated during work item processing.
• EVALUATION_PROCEDURE — foreign key to XDP_PROC_BODY; the PL/SQL body invoked to compute the parameter value.
• VALIDATION_PROCEDURE — foreign key to XDP_PROC_BODY; the PL/SQL body used to validate a supplied value.
• VALUE_LOOKUP_SQL and DEFAULT_VALUE — supply the query used to populate list-of-values behaviour and the default value assigned when none is supplied.
• REQUIRED_FLAG — indicates whether the parameter must be supplied before the work item can complete.
• LOG_IN_AUDIT_TRAIL_FLAG — determines whether changes to the parameter value are written to the audit trail.
• DISPLAY_SEQ — ordering used when rendering parameters in the UI.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, used for multi-org / security group filtering.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• ZD_EDITION_NAME — editioning column introduced for EBS 12.2 online patching.

Common Use Cases and Queries

Typical reporting and diagnostic patterns include listing all parameters defined for a given work item, identifying required parameters, and auditing which parameters use custom evaluation or validation logic.

• List parameters for a work item:
  SELECT parameter_name, default_value, required_flag, display_seq FROM xdp.xdp_wi_parameters WHERE workitem_id = :p_id ORDER BY display_seq;
• Find parameters backed by custom PL/SQL:
  SELECT workitem_id, parameter_name, evaluation_procedure, validation_procedure FROM xdp.xdp_wi_parameters WHERE evaluation_procedure IS NOT NULL OR validation_procedure IS NOT NULL;
• Verify which parameters are audited:
  SELECT workitem_id, parameter_name FROM xdp.xdp_wi_parameters WHERE log_in_audit_trail_flag = 'Y';
• Join to XDP_WORKITEMS to report parameter counts per work item.
• Join EVALUATION_PROCEDURE to XDP_PROC_BODY to resolve procedure names for documentation.

These queries are commonly used during implementation, upgrade regression testing (particularly post-12.2 editioning), and when troubleshooting failed work items in provisioning flows.

Related Objects

• XDP_WORKITEMS — parent table; XDP_WI_PARAMETERS.WORKITEM_ID references it.
• XDP_WORKLIST_DETAILS — references back to XDP_WI_PARAMETERS on WORKITEM_ID and PARAMETER_NAME, storing per-instance parameter values resolved at runtime.
• XDP_PROC_BODY — referenced twice, via EVALUATION_PROCEDURE and VALIDATION_PROCEDURE, providing the PL/SQL bodies used to compute and validate parameter values.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for security group scoping.
• XDP_WI_PARAMETERS_PK — primary key constraint on (WORKITEM_ID, PARAMETER_NAME).
• XDP_WI_PARAMETERS_U1 — unique index on (WORKITEM_ID, PARAMETER_NAME, ZD_EDITION_NAME), the edition-aware business key in 12.2.2.