Oracle EBS Quality Reports

7 ready-to-run SQL reports for Oracle E-Business Suite Quality, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Quality tables in these reports are qa_plans, mtl_parameters, org_access_view, qa_chars, qa_plan_chars, qa_plan_char_value_lookups.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Quality SQL Reports

Report Description
QA Collection Plan Actions Lists every action rule defined against an Oracle Quality collection plan - the trigger condition that fires the rule, the action it runs, the element it…
QA Collection Plan Element Values Lists the allowed values behind every list-validated Oracle Quality collection element - the entries an operator can pick when entering quality results, and…
QA Collection Plan Elements Every collection element assigned to an Oracle Quality collection plan, with the element’s prompt and sequence on the plan, its element type, datatype, display…
QA Collection Plan Relationships Every Oracle Quality parent child collection plan relationship, at one row per parent element to child element mapping. Each row names both plans with their…
QA Collection Plan Transactions Every collection transaction an Oracle Quality collection plan is attached to, with the trigger conditions that decide whether collection actually fires, the…
QA Collection Plans One row per Oracle Quality collection plan, with the plan type, effective dates, instructions, specification assignment type, electronic signature mode and the…
QA Quality Results One row per collection result and characteristic, so results from any number of collection plans stack in a single extract instead of one column per…

← All Oracle EBS modules

© Enginatics GmbH