Results for “jgzz_eft_type”

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

Overview

JG_ZZ_SYS_FORMATS_ALL_TL is a translation (TL) table within the JG – Regional Localizations product family, owned by the AP schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores language-specific descriptive information for the Electronic Funds Transfer (EFT) payment formats defined by country and payment type. In the Oracle EBS multi-language architecture, TL tables hold the translatable text columns of a corresponding base table, joined by a shared language-independent key. Here, the base table is JG_ZZ_SYS_FORMATS_ALL_B, and JG_ZZ_SYS_FORMATS_ALL_TL carries the country-specific and language-specific attributes that describe how EFT formats are presented to users.

Mined from its foreign key structure, the ETRM metadata classifies this object as satellite-leaning under a Data Vault heuristic. In practical modeling terms, it behaves as a satellite attached to the base entity defined by JG_ZZ_SYS_FORMATS_ALL_B, capturing context-dependent descriptive attributes rather than serving as a hub of independent business identities or as a link between distinct entities. This classification is a modeling suggestion derived from the FK topology, not a formal Data Vault declaration by Oracle.

Key Information Stored

The table’s documented physical schema contains eleven columns. The following are the most significant:

• JGZZ_COUNTRY_CODE – The country identifier for which the EFT format applies. Combined with the EFT type and language, this forms part of the composite primary key.
• JGZZ_EFT_TYPE – The category of EFT payment format being described. Together with country code and language, it constitutes the core identity of each translated record.
• JGZZ_DESCRIPTION – The translated description text for the format, supplying the user-facing, language-specific label associated with a given country and EFT type.
• LANGUAGE – The language of the description. It participates in both the primary key and the unique index, enabling multiple translations per format.
• SOURCE_LANG – Indicates the source language from which a translation was derived, used by Oracle’s translation framework to track linguistic lineage.
• ORG_ID – The operating unit or organization identifier, supporting multi-org data segregation where applicable.

The surrogate primary key is JG_SYS_FORMATS_ALL_TL_PK, defined over JGZZ_COUNTRY_CODE, JGZZ_EFT_TYPE, and LANGUAGE. A separate unique index, JG_ZZ_SYS_FORMATS_ALL_TL_U1, spans JGZZ_COUNTRY_CODE, JGZZ_EFT_TYPE, ORG_ID, and LANGUAGE, and represents the strongest business-key candidate as documented. The remaining columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — are standard EBS audit columns recording who created and last modified each row.

Common Use Cases and Queries

The primary use case is retrieving translated descriptions of EFT payment formats for reporting, configuration review, and user-interface presentation. A typical query joins the translation table to its base table on the shared key columns:

• Listing all translations for a specific country and EFT type: SELECT JGZZ_DESCRIPTION, LANGUAGE FROM JG_ZZ_SYS_FORMATS_ALL_TL WHERE JGZZ_COUNTRY_CODE = :country AND JGZZ_EFT_TYPE = :eft_type;
• Joining to the base table to combine language-independent and language-specific attributes: SELECT b.*, t.JGZZ_DESCRIPTION FROM JG_ZZ_SYS_FORMATS_ALL_B b JOIN JG_ZZ_SYS_FORMATS_ALL_TL t ON b.JGZZ_COUNTRY_CODE = t.JGZZ_COUNTRY_CODE AND b.JGZZ_EFT_TYPE = t.JGZZ_EFT_TYPE;
• Filtering by organization for multi-org reporting using ORG_ID.
• Auditing recently changed translations via LAST_UPDATE_DATE ranges.

These patterns support payment-format setup validation, localization configuration audits, and operational reporting across countries and operating units.

Related Objects

• JG_ZZ_SYS_FORMATS_ALL_B – The base table. JG_ZZ_SYS_FORMATS_ALL_TL references it via foreign keys on JGZZ_COUNTRY_CODE and JGZZ_EFT_TYPE; the translation joins back on these same columns.
• JG_ZZ_SYS_FORMATS_ALL_TL_U1 – The unique index enforcing business-key uniqueness across JGZZ_COUNTRY_CODE, JGZZ_EFT_TYPE, ORG_ID, and LANGUAGE.
• JG_SYS_FORMATS_ALL_TL_PK – The primary key constraint on the translation table.
• EFT payment format configuration objects – Setup and validation logic that consumes the translated descriptions for country-specific EFT formats.
• Payables payment processing components – Payment creation and formatting routines that rely on the localized format definitions surfaced through this table.

Together these objects position JG_ZZ_SYS_FORMATS_ALL_TL as the language-specific description store for regional EFT payment formats, tightly coupled to its base table and consumed wherever localized format presentation is required.