Search Results formatting_function_flag




Overview
Explore in AI Chat

Overview

JTF_QUAL_USGS is a CRM Foundation (JTF) view in Oracle E-Business Suite 12.1.1 and 12.2.2 that governs the usage definitions for qualification attributes in the CRM extensibility model. The Oracle ETRM documentation describes the object succinctly: "Same as JTF_QUAL_USGS_ALL table." It exposes the seed and setup data that determines how qualification flexfield columns are displayed, validated, and rendered across CRM qualification pages, lists of values (LOVs), and integration flows. Because it is a reporting-style view rather than a transactional entity, no DML is performed against it; consumers query it to resolve the presentation and validation rules attached to a given qualification usage.

Underlying Base Objects

The view is defined exclusively over the table JTF_QUAL_USGS_ALL, per the documented view text, which performs a straight projection of all columns from that table. In the standard Oracle EBS implementation, JTF_QUAL_USGS_ALL is the multi-organization base table, and JTF_QUAL_USGS is the view typically layered on it to expose the operating-unit-scoped rows (via ORG_ID) in a form consumed by the qualification engine. The ETRM metadata notes that the view is "Not implemented in this database" for the reference environment, and no additional referenced base objects are documented. In practice, the view is a thin wrapper: its structure, column names, and datatypes mirror JTF_QUAL_USGS_ALL one-for-one, and any custom logic is applied through the ORG_ID column rather than through joins or filters in the view definition.

Key Columns

Common Use Cases and Queries

Typical scenarios include diagnosing why a qualification column fails to appear or validate on a CRM page, auditing LOV SQL for a given application, and reporting on enabled usage definitions by operating unit.

SELECT QUAL_USG_ID, APPLICATION_SHORT_NAME, DISPLAY_TYPE,
       ENABLED_FLAG, ORG_ID
  FROM JTF_QUAL_USGS
 WHERE ENABLED_FLAG = 'Y'
   AND ORG_ID = :p_org_id;
SELECT QUAL_USG_ID, QUAL_COL1, QUAL_COL1_DATATYPE,
       LOV_SQL, DISPLAY_SQL1
  FROM JTF_QUAL_USGS
 WHERE APPLICATION_SHORT_NAME = 'JTF'
   AND SEEDED_FLAG = 'Y';

Because the view mirrors JTF_QUAL_USGS_ALL, queries returning inconsistent row counts across environments usually reflect ORG_ID scoping or missing seed data rather than view logic. Confirm seeded rows against the ALL table when discrepancies arise.