Results for “itm_templ_attribute_id”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JAI_RGM_ITM_TMPL_ATTRS is a transactional configuration table owned by the JA (Asia/Pacific Localizations) schema in Oracle EBS 12.1.1 and 12.2.2. It is a component of the Regional Globalization Management (RGM) functionality delivered under the Oracle localizations for the Asia/Pacific region. The table stores item-level or template-level attributes, meaning it holds the specific attribute values that define either a reusable attribute template or a concrete item's compliance with that template. The RGM framework allows organizations to model regulatory and localization characteristics of inventory items as a structured set of attributes, and this table is the persistence layer where those individual attribute assignments are recorded.
From a Data Vault modeling perspective, the mined relationship structure classifies this object as a link. Its foreign keys connect an attribute definition to both an item template (JAI_RGM_ITM_TEMPLATES) and an RGM item registry record (JAI_RGM_TMPL_ITM_REGNS), placing it at the intersection of template and item registry entities. This suggests it functions as an associative or intersection table that resolves many-to-many relationships between templates and the items (or registration entries) that adopt those templates.
Key Information Stored
The documented physical schema contains eleven columns. The most significant are:
- ITM_TEMPL_ATTRIBUTE_ID — The surrogate primary key, unique per row and enforced by the JAI_RGM_ITM_TMPL_ATTRS_PK constraint. This is a system-generated identifier and carries no business meaning.
- TEMPLATE_ID — Foreign key to JAI_RGM_ITM_TEMPLATES. Identifies the attribute template under which this attribute is defined.
- RGM_ITEM_REGNS_ID — Foreign key to JAI_RGM_TMPL_ITM_REGNS. Identifies the item registry entry that the attribute applies to.
- ATTRIBUTE_CODE — The code identifying which attribute is being recorded (for example, a regulatory or localization attribute name).
- ATTRIBUTE_VALUE — The value assigned to that attribute for the given template/item registration combination.
- OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework (OAF) to detect concurrent updates.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — Standard WHO audit columns recording row creation and last modification metadata.
The business key is captured by the unique index JAI_RGM_ITM_TMPL_ATTRS_U2, defined over the composite of TEMPLATE_ID, RGM_ITEM_REGNS_ID, and ATTRIBUTE_CODE. This guarantees that a given attribute code can appear only once for a specific template and item registration pairing, while the surrogate ITM_TEMPL_ATTRIBUTE_ID remains the physical primary key.
Common Use Cases and Queries
Typical usage centers on retrieving the attribute set for a given template or item registration, validating that mandatory attributes have been populated, and reporting attribute values across items for regulatory compliance. A representative query joining to the template master is:
SELECT attr.attribute_code, attr.attribute_value FROM jai_rgm_itm_tmpl_attrs attr WHERE attr.template_id = :template_id;SELECT attr.attribute_code, attr.attribute_value FROM jai_rgm_itm_tmpl_attrs attr WHERE attr.rgm_item_regns_id = :regns_id;- Existence and completeness checks joining ATTRIBUTE_CODE against a template's required attribute definitions.
- Integration and interface extracts that publish item attributes to external regulatory or customs systems.
- Audit reporting using CREATED_BY and LAST_UPDATED_BY to track who maintained attribute values.
Related Objects
The most significant related objects are those directly referenced by the documented foreign keys and those that depend on this table's primary key:
- JAI_RGM_ITM_TEMPLATES — Parent template master; joined on JAI_RGM_ITM_TMPL_ATTRS.TEMPLATE_ID.
- JAI_RGM_TMPL_ITM_REGNS — Parent item registration table; joined on JAI_RGM_ITM_TMPL_ATTRS.RGM_ITEM_REGNS_ID.
- JAI_RGM_ITM_TMPL_ATTRS_PK — Unique primary key index enforcing ITM_TEMPL_ATTRIBUTE_ID.
- JAI_RGM_ITM_TMPL_ATTRS_U2 — Composite unique index enforcing the TEMPLATE_ID, RGM_ITEM_REGNS_ID, ATTRIBUTE_CODE business key.
- RGM concurrent programs and OAF pages that maintain item templates and consume JAI_RGM_ITM_TMPL_ATTRS on commit.
-
Item or Template specific attributes are stored in this table.
-
Item or Template specific attributes are stored in this table.
-
eTRM - JA Tables and Views 12.1.1
The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.
-
eTRM - JA Tables and Views 12.2.2
The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.
-
eTRM - JA Tables and Views 12.1.1
The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.
-
eTRM - JA Tables and Views 12.2.2
The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.