Search Results jai_pa_setup_preferences_u1

Overview

The JA.JAI_PA_SETUP_PREFERENCES table is a setup data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, residing in the JA (Japanese Localization / Asia-Pacific) schema. Its functional purpose, as documented in the ETRM metadata, is to store the preferences of a Context Type based on a Distribution Rule. In practice, this table defines the configurable behavior of the localization setup, mapping a given setup context to a specific numeric preference value that governs downstream processing rules.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and is exposed as a valid, translatable object under the FND Design Data reference JA.JAI_PA_SETUP_PREFERENCES. Its companion index, JAI_PA_SETUP_PREFERENCES_U1, resides in APPS_TS_TX_IDX.

From a heuristic Data Vault modeling perspective, this object is classified as satellite-leaning. It carries descriptive, context-specific attribute values (the preference) attached to a parent context, and its columns reflect standard EBS audit and versioning behavior rather than an independent business entity or a pure associative link. A Data Vault conversion would typically model the context as a hub and this table as the satellite capturing preference and distribution-rule attributes over time.

Key Information Stored

The table contains eleven documented columns. The most operationally significant are:

• SETUP_PREFERENCE_ID — A sequence-driven surrogate identifier and the table's primary key. It is the leading column of the unique index JAI_PA_SETUP_PREFERENCES_U1.
• DISTRIBUTION_RULE — A VARCHAR2(20) value identifying the distribution rule that governs how the preference applies. This is a primary business-key candidate.
• CONTEXT_ID — A NUMBER(15) foreign key referencing JA.JAI_PA_SETUP_CONTEXTS, tying each preference row to its owning setup context.
• PREFERENCE — The numeric preference value configured for the context/rule combination; this is the substantive payload of the satellite.
• ZD_EDITION_NAME — A VARCHAR2(30) column participating in the unique index, supporting the edition-based redefinition (EBR) model used in EBS 12.2.2.
• OBJECT_VERSION_NUMBER — Optimistic locking / row versioning column used by the Oracle Application Framework (OAF) and BC4J layers.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN record the audit trail of each row's lifecycle.

Together, the unique index JAI_PA_SETUP_PREFERENCES_U1 on (SETUP_PREFERENCE_ID, ZD_EDITION_NAME) enforces both the surrogate uniqueness and edition-scoping required under the 12.2.x online patching architecture.

Common Use Cases and Queries

Typical usage scenarios include extracting the configured preference for a given context, auditing changes to setup preferences across editions, and joining preferences to their contexts for reporting.

To retrieve the configured preference for a specific context and distribution rule:

SELECT p.SETUP_PREFERENCE_ID,
       p.DISTRIBUTION_RULE,
       p.CONTEXT_ID,
       p.PREFERENCE
FROM   JA.JAI_PA_SETUP_PREFERENCES p
WHERE  p.CONTEXT_ID = :context_id
AND    p.DISTRIBUTION_RULE = :rule;

To report preferences with their owning context descriptions, join on the foreign key:

SELECT c.CONTEXT_NAME,
       p.DISTRIBUTION_RULE,
       p.PREFERENCE
FROM   JA.JAI_PA_SETUP_PREFERENCES p,
       JA.JAI_PA_SETUP_CONTEXTS c
WHERE  p.CONTEXT_ID = c.CONTEXT_ID;

To audit recent setup changes, order by the Who columns:

SELECT SETUP_PREFERENCE_ID, CONTEXT_ID, PREFERENCE,
       LAST_UPDATED_BY, LAST_UPDATE_DATE
FROM   JA.JAI_PA_SETUP_PREFERENCES
WHERE  LAST_UPDATE_DATE >= TRUNC(SYSDATE) - 30;

These queries support setup validation, migration verification between environments, and diagnostic reporting when localization behavior does not match expectations.

Related Objects

The ETRM metadata documents a single foreign-key relationship and identifies the object as referenced by a companion synonym or editioning view:

• JA.JAI_PA_SETUP_CONTEXTS — The parent table referenced by CONTEXT_ID. This is the principal related object; the preference logical record cannot exist without its owning context.
• JA.JAI_PA_SETUP_PREFERENCES# — The underlying base table referenced by the editioning view in the EBR model of 12.2.2.
• JA.JAI_PA_SETUP_PREFERENCES (synonym/view) — The application-facing access layer through which OAF pages and concurrent programs read and write preference data.
• JAI_PA_SETUP_PREFERENCES_U1 — The unique index supporting primary-key lookups and the edition scoping.

Note that the documented metadata indicates JAI_PA_SETUP_PREFERENCES does not itself reference any database object other than its context parent. Integration with the broader Japanese localization feature set occurs through the CONTEXT_ID linkage and the distribution-rule codes consumed by dependent localization programs.