Results for “qa_char_actions”

50+ results




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

Overview

QA_CHAR_ACTIONS is a table in the QA (Quality) schema of Oracle E-Business Suite, documented as VALID in both 12.1.1 and 12.2.2. Its description states that it "defines collection elements and actions assigned to them." In practice, the table acts as the configuration bridge between a Quality collection plan element (a characteristic or collection element) and a corrective or preventive action definition maintained in Oracle Quality. Each row records that a specific action should be associated with a triggered collection element, together with the parameters that govern how a corrective action request (CAR) is generated, owned, and messaged.

The heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. This suggests that, from a dimensional or Data Vault modeling perspective, QA_CHAR_ACTIONS behaves primarily as a descriptive satellite attached to a parent action or trigger hub, rather than as a true many-to-many link hub. This is a modeling suggestion derived from the FK topology, not an Oracle-declared classification.

Key Information Stored

The table contains 16 documented columns. The most significant are summarized below.

Common Use Cases and Queries

Typical usage centers on Quality configuration review and troubleshooting: confirming which actions are attached to a collection element, verifying CAR defaults such as owner and name prefix, and auditing whether Alert actions are wired to a characteristic. A representative query joining the parent action definition:

SELECT ca.char_action_id, ca.car_name_prefix, ca.car_owner, a.action_name
FROM qa.qa_char_actions ca, qa.qa_actions a
WHERE ca.action_id = a.action_id
AND ca.status_code = 'ACTIVE';

To inspect the CAR type and trigger association for reporting:

SELECT ca.char_action_id, t.char_action_trigger_id, ct.car_type_name
FROM qa.qa_char_actions ca, qa.qa_char_action_triggers t, qa.qa_car_types ct
WHERE ca.char_action_trigger_id = t.char_action_trigger_id
AND ca.car_type_id = ct.car_type_id;

Reporting use cases include auditing corrective action configuration coverage, validating that every action trigger has a properly assigned action and CAR type, and tracing downstream generated CAR outputs.

Related Objects

The following objects are most significant to QA_CHAR_ACTIONS based on documented relationship data:

  • QA_ACTIONS — Referenced via QA_CHAR_ACTIONS.ACTION_ID; holds the corrective/preventive action definitions assigned to collection elements.
  • QA_CHAR_ACTION_TRIGGERS — Referenced via CHAR_ACTION_TRIGGER_ID; defines the trigger conditions that fire the assigned action.
  • QA_CAR_TYPES — Referenced via CAR_TYPE_ID; classifies the corrective action request to be generated.
  • QA_CHAR_ACTION_OUTPUTS — References QA_CHAR_ACTIONS via CHAR_ACTION_ID; captures the outputs produced by a triggered char action.

Together these objects form the action-assignment and CAR-generation configuration chain within the Oracle Quality module.