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.
- CHAR_ACTION_ID — The surrogate primary key, enforced by QA_CHAR_ACTIONS_PK and also the sole unique business-key candidate via QA_CHAR_ACTIONS_U1. It uniquely identifies each collection-element-to-action assignment.
- CHAR_ACTION_TRIGGER_ID — Foreign key to QA_CHAR_ACTION_TRIGGERS, linking the action assignment to the trigger condition that fires it.
- ACTION_ID — Foreign key to QA_ACTIONS, identifying the corrective or preventive action definition assigned to the element.
- CAR_TYPE_ID — Foreign key to QA_CAR_TYPES, specifying the corrective action request type to be created when the action fires.
- CAR_NAME_PREFIX — Prefix used when generating CAR names or numbers.
- CAR_OWNER — The owner assigned to the resulting corrective action request.
- MESSAGE — Notification or alert text associated with the action.
- STATUS_CODE and STATUS_ID — Status identifiers controlling whether the assignment is active or otherwise.
- ALR_ACTION_SET_ID and ALR_ACTION_ID — References to Oracle Alert action set and action identifiers, enabling Alert-driven notification behavior.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row.
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.
-
Defines collection elements and actions assigned to them
-
Defines collection elements and actions assigned to them
-
TABLE: QA.QA_CHAR_ACTIONS 12.2.2
-
TABLE: QA.QA_CHAR_ACTIONS 12.1.1
-
VIEW: QA.QA_CHAR_ACTIONS# 12.2.2
-
View: QABV_COLELMACTN 12.1.1
- Retrofitted
-
View: QAFV_COLELMACTN 12.2.2
- Retrofitted
APPS.QAFV_COLELMACTN·↳ QA_ACTIONS·↳ QA_CHAR_ACTIONS·Explore QA module →
-
View: QAFV_COLELMACTN 12.1.1
- Retrofitted
APPS.QAFV_COLELMACTN·↳ QA_ACTIONS·↳ QA_CHAR_ACTIONS·Explore QA module →
-
Shows output tokens defined for actions
APPS.QA_CHAR_ACTION_OUTPUTS_V·↳ QA_ACTIONS·↳ QA_CHARS·↳ QA_CHAR_ACTIONS·Explore QA module →
-
Shows output tokens defined for actions
APPS.QA_CHAR_ACTION_OUTPUTS_V·↳ QA_ACTIONS·↳ QA_CHARS·↳ QA_CHAR_ACTIONS·Explore QA module →
-
Stores mapping between tokens and collection elements
-
Stores mapping between tokens and collection elements
-
View: QABV_COLELMACTN 12.2.2
- Retrofitted
-
VIEW: APPS.QAFV_COLELMACTN 12.2.2
-
View: QA_CHAR_ACTIONS_V 12.2.2
shows collection elements and actions
APPS.QA_CHAR_ACTIONS_V·↳ QA_ACTIONS·↳ QA_CHARS·↳ QA_CHAR_ACTIONS·Explore QA module →
-
View: QA_CHAR_ACTIONS_V 12.1.1
shows collection elements and actions
APPS.QA_CHAR_ACTIONS_V·↳ QA_ACTIONS·↳ QA_CHARS·↳ QA_CHAR_ACTIONS·Explore QA module →
-
VIEW: APPS.QABV_COLELMACTN 12.1.1
-
VIEW: APPS.QABV_COLELMACTN 12.2.2
-
VIEW: APPS.QAFV_COLELMACTN 12.1.1
-
VIEW: APPS.QA_CHAR_ACTIONS_V 12.2.2
-
VIEW: APPS.QA_CHAR_ACTIONS_V 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
VIEW: QA.QA_CHAR_ACTIONS# 12.2.2
-
PACKAGE: APPS.QLTCPDFB 12.2.2
-
PACKAGE: APPS.QLTCPDFB 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.QABV_COLELMACTN 12.1.1
-
VIEW: APPS.QABV_COLELMACTN 12.2.2
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.QAFV_COLELMACTN 12.1.1
-
VIEW: APPS.QAFV_COLELMACTN 12.2.2
-
VIEW: APPS.QA_CHAR_ACTIONS_V 12.1.1
-
VIEW: APPS.QA_CHAR_ACTIONS_V 12.2.2