Results for “package_spool_filename”

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

Overview

JTF_QUAL_TYPE_USGS_ALL is a CRM Foundation (JTF) intersection table that defines the association between a qualifier type and the source from which that qualifier type is drawn. In Oracle EBS 12.1.1 and 12.2.2, it functions as a usage mapping table: each row records that a given qualifier type (held in JTF_QUAL_TYPES_ALL) is available or applicable for a given source (held in JTF_SOURCES_ALL). Because the row is keyed by QUAL_TYPE_USG_ID and is referenced by several downstream usage and territory tables, it acts as the central anchor for qualifier-type usage definitions within the CRM Foundation model.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning. It carries its own stable surrogate identity plus descriptive linkage, which suggests treating it as a hub or hub-adjacent entity rather than a pure transactional satellite. This classification is a heuristic suggestion derived from the FK topology, not an enforced constraint.

Key Information Stored

The table is documented with 14 physical columns in ETRM 12.2.2. Its most significant contents are:

• QUAL_TYPE_USG_ID — The surrogate primary key (JTF_QUAL_TYPE_USGS_ALL_PK) that uniquely identifies each qualifier-type usage record and serves as the join key for all dependent tables.
• QUAL_TYPE_ID — Foreign key to JTF_QUAL_TYPES_ALL, identifying the qualifier type being made available.
• SOURCE_ID — Foreign key to JTF_SOURCES_ALL, identifying the source of the qualifier type.
• ORG_ID — Multi-org operating unit identifier, enabling organization-level partitioning of qualifier-type usage data.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS supporting data security and access partitioning.
• PACKAGE_NAME and PACKAGE_SPOOL_FILENAME — Store information about the concurrent program or package that generated or seeded the usage record.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OA Framework for concurrent update control.
• ZD_EDITION_NAME — Editioning column supporting Oracle EBS online patching in 12.2.x.

The documented unique index JTF_QUAL_TYPE_USGS_U1 spans QUAL_TYPE_USG_ID, ORG_ID, and ZD_EDITION_NAME, representing the business-key candidate that enforces uniqueness across edition and organization context.

Common Use Cases and Queries

Typical usage includes diagnosing which qualifier types are valid for a given source, resolving the usage identifier before joining to dependent usage or territory tables, and validating customization or extensibility setups. A representative pattern resolves the qualifier type and source names behind a usage record:

• SELECT u.qual_type_usg_id, t.qual_type_name, s.source_name FROM jtf_qual_type_usgs_all u JOIN jtf_qual_types_all t ON u.qual_type_id = t.qual_type_id JOIN jtf_sources_all s ON u.source_id = s.source_id WHERE u.qual_type_usg_id = :id;
• Locate all usages for a source: filter jtf_qual_type_usgs_all by SOURCE_ID, then count downstream rows in JTF_QUAL_USGS_ALL keyed on QUAL_TYPE_USG_ID.
• Diagnose duplicate or missing setups: compare the JTF_QUAL_TYPE_USGS_U1 business key against the primary key to identify orphaned usage records.
• Security-aware reporting: restrict by ORG_ID and SECURITY_GROUP_ID to reflect the operating unit and access control context.

Related Objects

JTF_QUAL_TYPE_USGS_ALL sits at a junction of the qualifier type, source, and usage models. The significant related objects and join columns are:

• JTF_QUAL_TYPES_ALL — referenced via JTF_QUAL_TYPE_USGS_ALL.QUAL_TYPE_ID; provides the qualifier type definition.
• JTF_SOURCES_ALL — referenced via JTF_QUAL_TYPE_USGS_ALL.SOURCE_ID; provides the source definition.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; drives data security partitioning.
• JTF_QUAL_USGS_ALL — references this table via QUAL_TYPE_USG_ID; carries qualifier usage details.
• JTF_TERR_QTYPE_USGS_ALL — references this table via QUAL_TYPE_USG_ID; links qualifier-type usage to territory definitions.
• JTF_TYPE_QTYPE_USGS_ALL — references this table via QUAL_TYPE_USG_ID; links qualifier-type usage to object types.

These relationships establish JTF_QUAL_TYPE_USGS_ALL as the shared anchor for qualifier-type usage across CRM source, territory, and type configurations, reinforcing its hub-leaning role in the CRM Foundation data model.