Search Results frm_set_pub_options_pk

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.

• REPORT_SET_ID, REPORT_ID, SEQUENCE_NUMBER — the composite identifier that ties a publishing option to its request set, report, and ordinal position.
• TEMPLATE_CODE, PRES_TEMPLATE_CODE, PRES_TEMPLATE_ASN — the presentation template used when rendering published output.
• OUTPUT_TYPE, DOCUMENT_TYPE, DOCUMENT_ID, DOCUMENT_NAME, CONFIGURATION_ID — define the output format and the underlying document or configuration being published.
• AVAILABILITY_TYPE, AVAILABILITY_DATE, AVAILABILITY_DATE_TIME — govern when the published content becomes accessible.
• SECURITY_TYPE, SECURITY_CODE, PUBLISHER_TYPE, REVIEWERS_ID, PRES_RESP_ID — control access and the publishing responsibility context.
• ARCHIVE_PERIOD_MONTHS, ARCHIVE_DATE, PUBLISH_FLAG, TIME_FRAME, EXPANDED_FLAG, EXPANDED_VALUE — manage archiving behavior and expansion state.
• VALUE_SET_ID, FUNCTION_ID, MENU_ID, MENU_ENTRY_SEQ, PRES_MENU_NAME, PRES_MENU_PATH — link the publish option to value sets, functions, and menu navigation.
• OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS auditing and concurrency columns.

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.