Search Results ben_ext_rcd_in_file_pk

Overview

BEN_EXT_RCD_IN_FILE is a core configuration table within the Oracle Advanced Benefits (BEN) module, storing extract record definitions as they are associated with extract files. In Oracle EBS 12.1.1 and 12.2.2, the Advanced Benefits extract framework uses this table to define which extract records are included in a given extract file, along with sort order, selection criteria, and record-level flags that govern how the extract process assembles output data.

The object is owned by the BEN schema and is documented as VALID. Its physical definition in ETRM 12.2.2 comprises 22 columns and a composite unique index, BEN_EXT_RCD_IN_FILE_PK, spanning EXT_RCD_IN_FILE_ID and ZD_EDITION_NAME. From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification: the table carries descriptive attributes tied to parent extract file and extract record entities rather than acting as a pure hub or link.

Key Information Stored

The surrogate primary key is EXT_RCD_IN_FILE_ID, which uniquely identifies each row in the legacy (non-editioned) sense; at the physical level the unique index also includes ZD_EDITION_NAME, reflecting the edition-aware design introduced in 12.2.2. The most significant columns are:

EXT_FILE_ID — foreign key to BEN_EXT_FILE, identifying the extract file to which this record definition belongs.
EXT_RCD_ID — foreign key to BEN_EXT_RCD, identifying the extract record being associated.
SORT1_DATA_ELMT_IN_RCD_ID through SORT4_DATA_ELMT_IN_RCD_ID — foreign keys to BEN_EXT_DATA_ELMT_IN_RCD defining up to four sort keys applied to the record.
SEQ_NUM — sequence number controlling the ordering of records within the extract file.
RQD_FLAG — indicates whether the record is required in the file.
HIDE_FLAG — governs whether the record is hidden from certain output or user displays.
SPRS_CD — suppression code controlling record suppression behavior.
ANY_OR_ALL_CD — controls whether any or all qualifying criteria must be satisfied.
CHG_RCD_UPD_FLAG — flag governing record update behavior during change processing.
LEGISLATION_CODE — legislation context for the extract record configuration.
BUSINESS_GROUP_ID — multi-tenant business group identifier.
OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, CREATED_BY and related audit columns — standard EBS concurrency and audit controls.

Common Use Cases and Queries

Functional and technical consultants query this table when diagnosing extract output, verifying which records are attached to a file, and tracing sort or suppression logic. A typical diagnostic query joins to the parent file and record:

List records for a file: SELECT r.EXT_RCD_IN_FILE_ID, r.EXT_FILE_ID, r.EXT_RCD_ID, r.SEQ_NUM, r.RQD_FLAG FROM BEN_EXT_RCD_IN_FILE r WHERE r.EXT_FILE_ID = :p_file_id ORDER BY r.SEQ_NUM;
Identify sort keys: select SORT1_DATA_ELMT_IN_RCD_ID through SORT4 and join to BEN_EXT_DATA_ELMT_IN_RCD.
Extract configuration reporting: join to BEN_EXT_FILE and BEN_EXT_RCD to produce a catalogue of records per file for audit or migration.
Suppression analysis: filter on SPRS_CD, HIDE_FLAG and RQD_FLAG to explain why a record is absent from output.

Related Objects

BEN_EXT_RCD_IN_FILE sits at the centre of a dense FK web. It references BEN_EXT_FILE (EXT_FILE_ID), BEN_EXT_RCD (EXT_RCD_ID), and BEN_EXT_DATA_ELMT_IN_RCD (via SORT1 through SORT4). It is referenced by BEN_EXT_INCL_CHG, BEN_EXT_INCL_DATA_ELMT, BEN_EXT_WHERE_CLAUSE and BEN_EXT_RSLT_DTL (all through EXT_RCD_IN_FILE_ID), and by BEN_EXT_FILE. These relationships make it the hub of extract record configuration, inclusion criteria, and result-detail processing within Advanced Benefits.

INDEX: BEN.BEN_EXT_RCD_IN_FILE_PK 12.1.1
owner:BEN, object_type:INDEX, object_name:BEN_EXT_RCD_IN_FILE_PK, status:VALID,
Table: BEN_EXT_RCD_IN_FILE 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_EXT_RCD_IN_FILE, object_name:BEN_EXT_RCD_IN_FILE, status:VALID, product: BEN - Advanced Benefits , description: Extract record in file. , implementation_dba_data: BEN.BEN_EXT_RCD_IN_FILE ,
INDEX: BEN.BEN_EXT_RCD_IN_FILE_PK 12.2.2
owner:BEN, object_type:INDEX, object_name:BEN_EXT_RCD_IN_FILE_PK, status:VALID,
Table: BEN_EXT_RCD_IN_FILE 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_EXT_RCD_IN_FILE, object_name:BEN_EXT_RCD_IN_FILE, status:VALID, product: BEN - Advanced Benefits , description: Extract record in file. , implementation_dba_data: BEN.BEN_EXT_RCD_IN_FILE ,
TABLE: BEN.BEN_EXT_RCD_IN_FILE 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_EXT_RCD_IN_FILE, object_name:BEN_EXT_RCD_IN_FILE, status:VALID,
TABLE: BEN.BEN_EXT_RCD_IN_FILE 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_EXT_RCD_IN_FILE, object_name:BEN_EXT_RCD_IN_FILE, status:VALID,
PACKAGE BODY: APPS.BEN_XRF_SHD 12.2.2
PACKAGE BODY: APPS.BEN_XRF_SHD 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.BEN_XRF_BUS 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.BEN_XRF_BUS 12.2.2
APPS.BEN_XRF_BUS dependencies on BEN_EXT_RCD 12.1.1
APPS.BEN_XRF_BUS dependencies on BEN_EXT_RCD_IN_FILE 12.2.2
APPS.BEN_XRF_BUS dependencies on BEN_EXT_RCD_IN_FILE 12.1.1
APPS.BEN_XRF_BUS dependencies on BEN_EXT_RCD 12.2.2
APPS.BEN_XRF_SHD dependencies on FND_MESSAGE 12.1.1
APPS.BEN_XRF_SHD dependencies on FND_MESSAGE 12.2.2
APPS.BEN_XRF_SHD dependencies on BEN_EXT_RCD_IN_FILE 12.2.2
APPS.BEN_XRF_BUS dependencies on BEN_XRF_SHD 12.1.1
APPS.BEN_XRF_SHD dependencies on BEN_EXT_RCD_IN_FILE 12.1.1
APPS.BEN_XRF_BUS dependencies on BEN_XRF_SHD 12.2.2
eTRM - BEN Tables and Views 12.2.2
description: Start and End periods. ,
eTRM - BEN Tables and Views 12.1.1
description: Start and End periods. ,
eTRM - BEN Tables and Views 12.2.2
description: Start and End periods. ,
eTRM - BEN Tables and Views 12.1.1
description: Start and End periods. ,