Search Results jtf_prefab_sys_policies




Overview
Explore in AI Chat

Overview

JTF_PREFAB_SYS_POLICIES is a CRM Foundation (JTF) configuration table that models the system-wide policy governing the prefabrication subsystem in Oracle E-Business Suite 12.1.1 and 12.2.2. Prefabrication is the mechanism by which frequently accessed CRM objects are assembled, cached, or pre-rendered ahead of user demand. This table stores the singleton-level policy that controls how that prefabrication service behaves — resource ceilings, caching behavior, load-balancing endpoints, and interceptor activation — rather than per-object or per-user settings.

The object is owned by the JTF schema and is documented as VALID in the ETRM 12.2.2 repository with 19 physical columns. The heuristic Data Vault classification mined from its foreign key structure is standalone, which is best read as a modeling suggestion: the table carries no downward dependencies and behaves as an independent reference/configuration entity rather than a hub, link, or satellite within a Data Vault model. Its single outbound foreign key to FND_SECURITY_GROUPS is a security-scoping pointer, not a relationship to another transactional entity.

Key Information Stored

The table is keyed by the surrogate primary key SYS_POLICY_ID, enforced through the constraint JTF_PREFAB_SYS_POLICIES_PK. A second unique index, JTF_PREFAB_SYS_POLICIES_U1, covers (SYS_POLICY_ID, ZD_EDITION_NAME), indicating that the row is additionally qualified by an edition name for Oracle EBS 12.2 edition-based redefinition support.

The most significant columns fall into three functional groups:

Common Use Cases and Queries

Typical usage centers on verifying or tuning the active prefabrication policy. A configuration review query retrieves the effective row for a security group:

  • SELECT sys_policy_id, start_flag, max_concurrency, use_load_balancer_flag, load_balancer_url, interceptor_enabled_flag FROM jtf.jtf_prefab_sys_policies WHERE security_group_id = :sgid;
  • SELECT cpu, memory, cache_memory, disk_location, refresh_flag FROM jtf.jtf_prefab_sys_policies WHERE start_flag = 'Y';

Reporting scenarios include auditing whether load balancing is enabled across the CRM tier, confirming that concurrency limits match the available application server capacity, and tracking changes to the policy over time via the LAST_UPDATED_BY and LAST_UPDATE_DATE audit columns. Administrators also query this table when diagnosing prefabrication failures, since an inactive START_FLAG or a misconfigured DISK_LOCATION will halt cache assembly without raising an obvious application error.

Related Objects

The following objects are the most significant to consider alongside JTF_PREFAB_SYS_POLICIES:

  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID; the FK that scopes each policy row to a security group.
  • JTF_PREFAB_SYS_POLICIES_PK — the primary key constraint on SYS_POLICY_ID.
  • JTF_PREFAB_SYS_POLICIES_U1 — the unique index over (SYS_POLICY_ID, ZD_EDITION_NAME).
  • JTF_PREFAB_* configuration tables — the broader prefabrication family in the JTF schema, which consumes the policy values defined here.
  • FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — used to confirm the CRM Foundation product installation that owns this table.

Because the table is classified as standalone, no downstream tables carry foreign keys into it; changes to a policy row therefore propagate only through the prefabrication runtime rather than through relational dependencies.