Search Results frm_reqset_pub_options_pk

Overview

FRM_REQSET_PUB_OPTIONS is a Report Manager (FRM) table in the Oracle E-Business Suite that stores the publishing options configured for a request set. Within Oracle EBS, Report Manager governs how concurrent request output is delivered, secured, and retained. Request sets group multiple concurrent programs so they can be submitted together; each request set can carry publishing attributes that determine whether its output is published, how it is distributed, who may view it, and how long it is archived. FRM_REQSET_PUB_OPTIONS is the persistence point for those attributes.

The documented primary key is FRM_REQSET_PUB_OPTIONS_PK, defined on the composite of REQUEST_SET_ID, REPORT_ID, STAGE_NUMBER, and SEQUENCE_NUMBER. This composite key means a single request set can hold many publishing option rows, identified by the member report, the stage within the request set, and the sequence within that stage. The unique index FRM_REQSET_PUB_OPTIONS_UK1 mirrors the primary key columns, and the metadata records one foreign key: VALUE_SET_ID referencing FRM_PART_VALUE_SETS. The documented physical schema in ETRM 12.2.2 defines 37 columns.

From a Data Vault modeling perspective, the metadata’s heuristic classification of this table is standalone, with a single outward reference. That suggests treating it as a satellite-like structure dependent on the request set and report member, rather than a hub or link in its own right.

Key Information Stored

The table records both the identity of the publishing configuration and the delivery characteristics applied to request set output. The most significant columns are:

• REQUEST_SET_ID — identifies the request set to which the publishing options belong; a key column.
• REPORT_ID — identifies the specific report (concurrent program) member within the request set; a key column.
• STAGE_NUMBER — the stage within the request set where the member executes; a key column.
• SEQUENCE_NUMBER — the ordering position within the stage; a key column.
• TEMPLATE_CODE and PRES_TEMPLATE_CODE / PRES_TEMPLATE_ASN — the presentation template applied when publishing output.
• PUBLISH_FLAG — indicates whether the output is published.
• OUTPUT_TYPE — the format of the generated output.
• AVAILABILITY_TYPE and AVAILABILITY_DATE_TIME — control when published output becomes available.
• SECURITY_TYPE and SECURITY_CODE — define access restrictions on the published document.
• PUBLISHER_TYPE — identifies the publishing mechanism used.
• VALUE_SET_ID — references FRM_PART_VALUE_SETS; the only documented foreign key.
• DOCUMENT_ID, DOCUMENT_TYPE, and DOCUMENT_NAME — describe the published document.
• PRES_FUNCTION_ID, PRES_MENU_ID, PRES_MENU_ENTRY_SEQ, PRES_MENU_NAME, and PRES_MENU_PATH — define the presentation menu context from which the output is accessed.
• ARCHIVE_DATE — the retention/archival marker for the published output.
• OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — the standard EBS audit and optimistic-locking columns.
• CONFIGURATION_ID — ties the row to the Report Manager configuration context.

The surrogate identity is effectively the composite business key enforced by FRM_REQSET_PUB_OPTIONS_PK; there is no separate single-column surrogate in the documented metadata, and FRM_REQSET_PUB_OPTIONS_UK1 duplicates that composite as a unique business-key candidate.

Common Use Cases and Queries

Administrators and developers query this table to audit how a request set’s output is published, to verify security settings, and to troubleshoot missing or unavailable output. Typical patterns join the table back to request set and concurrent program definitions.

Retrieving all publishing options for a request set:

SELECT REQUEST_SET_ID, REPORT_ID, OUTPUT_TYPE, PUBLISH_FLAG, SECURITY_TYPE, SECURITY_CODE, ARCHIVE_DATE FROM FRM_REQSET_PUB_OPTIONS WHERE REQUEST_SET_ID = :p_request_set_id ORDER BY STAGE_NUMBER, SEQUENCE_NUMBER;

Joining to the value set reference to confirm the source of a publishing parameter:

SELECT p.REQUEST_SET_ID, p.REPORT_ID, p.VALUE_SET_ID, v.VALUE_SET_NAME FROM FRM_REQSET_PUB_OPTIONS p, FRM_PART_VALUE_SETS v WHERE p.VALUE_SET_ID = v.VALUE_SET_ID;

Reporting on rows where publication is suppressed or restricted:

SELECT REQUEST_SET_ID, REPORT_ID, PUBLISH_FLAG, SECURITY_TYPE FROM FRM_REQSET_PUB_OPTIONS WHERE PUBLISH_FLAG = 'N' OR SECURITY_TYPE IS NOT NULL;

Because publishing options are versioned through OBJECT_VERSION_NUMBER and audited through the standard WHO columns, these queries also support change-tracking and compliance reporting.

Related Objects

The following objects are most directly associated with FRM_REQSET_PUB_OPTIONS based on the documented relationships and EBS Report Manager semantics:

• FRM_PART_VALUE_SETS — referenced through VALUE_SET_ID, providing the value set definition used by publishing parameters.
• FND_REQUEST_SETS (or the corresponding request set definition table) — provides the request set identified by REQUEST_SET_ID.
• FND_REQUEST_SET_PROGRAMS — supplies the report/program members identified by REPORT_ID, STAGE_NUMBER, and SEQUENCE_NUMBER.
• FND_CONCURRENT_PROGRAMS — defines the concurrent program behind each REPORT_ID.
• FND_DOCUMENTS / FND_DOCUMENT_ENTITIES — relate to DOCUMENT_ID, DOCUMENT_TYPE, and DOCUMENT_NAME for the published output.
• FRM_PRESENTATION_TEMPLATES — source of the PRES_TEMPLATE_CODE and TEMPLATE_CODE presentation definitions.
• FND_MENUS and FND_MENU_ENTRIES — referenced through PRES_MENU_ID, PRES_MENU_NAME, and PRES_MENU_PATH.
• FND_RESPONSIBILITY — associated with PRES_RESP_ID, linking publishing options to the responsibility context in which output is presented.

These relationships make FRM_REQSET_PUB_OPTIONS the central configuration record connecting request set execution, report output publication, presentation templates, and access control within Oracle EBS Report Manager.