Search Results frm_set_pub_options




Overview
Explore in AI Chat

Overview

FRM_SET_PUB_OPTIONS is a table in the FRM (Report Manager) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the publishing options configured for a report or a request set, controlling how output is delivered, secured, archived, and made available to end users through the Report Manager publishing framework. Each row associates a publishing definition with a specific report set and report, ordered by a sequence number, so that a single report set can carry multiple publishing option entries.

From a heuristic Data Vault modeling perspective, this table is classified as standalone. It does not act as a hub or a link in a conventional Data Vault sense, but behaves as a satellite-like configuration store whose natural business key is derived from its unique index rather than from a generated surrogate. This classification is a modeling suggestion only and reflects the mined foreign key structure, which shows the table referencing other objects rather than being referenced as a parent.

Key Information Stored

The table is defined with 38 documented columns. The primary key object, FRM_SET_PUB_OPTIONS_PK, is a composite key over REPORT_SET_ID, REPORT_ID, and SEQUENCE_NUMBER. The unique index FRM_SET_PUB_OPTIONS_UK1 carries the same column set, identifying this composite as the business-key candidate for the row.

Common Use Cases and Queries

Typical scenarios include auditing which reports within a request set have publishing enabled, verifying security and availability settings before go-live, and tracing archived versus active publications. A representative query lists publishing options for a request set:

SELECT report_set_id, report_id, sequence_number, template_code, output_type, publish_flag, security_type FROM frm.frm_set_pub_options WHERE report_set_id = :p_set_id ORDER BY sequence_number;

To identify options pending archival, filter on archive settings and publish flag, and to resolve menu-driven navigation, join MENU_ID to FND_MENUS. Reporting use cases commonly join these rows to FND request and concurrent program metadata to produce publishing configuration inventories.

Related Objects

  • FRM_PART_VALUE_SETS — referenced via VALUE_SET_ID; supplies the value set backing a publishing parameter.
  • FND_MENUS — referenced via MENU_ID; provides the menu that exposes the published output.
  • FND_CONCURRENT_REQUESTS / FND_CONCURRENT_PROGRAMS — contextual parents for the publishing run.
  • FRM_SET_PUB_OPTIONS_PK / FRM_SET_PUB_OPTIONS_UK1 — the primary key and unique index enforcing the composite business key.
  • FND_FLEX_VALUE_SETS — related through the value set linkage for validated parameters.