Search Results bnf_person

Overview

APPS.BEN_PL_BNF_D is a reporting view in the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module. It presents a denormalized, human-readable projection of plan beneficiary designations stored in the BEN_PL_BNF_F base table. Rather than exposing surrogate identifiers alone, the view resolves those identifiers into descriptive attributes: the full name of the designated beneficiary, the full name of any associated trustee, the name of the designating organization, and the meaning of the primary contingency code. It also exposes the designation percentage, designated amount, unit of measure, designation start and end dates, additional instruction text, and standard audit columns such as LAST_UPDATE_DATE and the user name of the last updater.

The view is read-only and is intended for reporting, inquiry, and integration scenarios where a beneficiary designation must be displayed or extracted without performing independent lookups against people, organization, or lookup tables. Because it draws from multiple foundation objects, it is a convenient single-source object for concurrent programs, BI Publisher data templates, and custom OAF or Forms-based inquiries. Note that the view name carries the _D suffix, which by convention in Oracle EBS indicates a view defined over the date-tracked (datetrack) attributes of the underlying entity.

Underlying Base Objects

The view is defined over the following documented base objects, all referenced through the APPS schema:

• BEN_PL_BNF_F (synonym) — the core plan beneficiary designation table; supplies PL_BNF_ID, effective dates, designation amounts and percentages, and audit columns.
• BEN_PER_IN_LER (synonym) — the person/learner record; joined on PER_IN_LER_ID and BUSINESS_GROUP_ID to filter out voided or backdated records (PER_IN_LER_STAT_CD NOT IN ('VOIDD','BCKDT')).
• PER_ALL_PEOPLE_F (synonym) — joined twice, once as BNF_PERSON for the designated beneficiary and once as TTEE_PERSON for the trustee, each constrained by the designation effective start date falling within the person's effective date range.
• HR_ALL_ORGANIZATION_UNITS_VL (view) — provides the organization name via ORGANIZATION_ID.
• HR_LOOKUPS (view) — supplies PRMRY_CNTNGNT.MEANING where LOOKUP_TYPE = 'BEN_PRMRY_CNTNGNT'.
• FND_USER (synonym) — provides the user name of the last updater through a outer join on USER_ID = LAST_UPDATED_BY.
• HR_API (package) — referenced indirectly through the HR_ALL_ORGANIZATION_UNITS_VL view definition.

All person, organization, lookup, and user joins are outer joins (denoted by the (+) operator), so a designation record is returned even when the beneficiary, trustee, organization, contingency, or updater cannot be resolved.

Key Columns

• ROW_ID — the ROWID of the underlying BEN_PL_BNF_F row; useful for row-level identification.
• PL_BNF_ID — primary key of the beneficiary designation.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — datetrack validity range of the designation.
• BNF_PERSON_FULL_NAME — resolved name of the designated beneficiary.
• TTEE_PERSON_FULL_NAME — resolved name of the trustee, where applicable.
• ORGANIZATION_NAME — name of the organization associated with the designation.
• PRMRY_CNTNGNT_MEANING — decoded description of the primary contingency lookup value.
• PCT_DSGD_NUM / AMT_DSGD_VAL / AMT_DSGD_UOM — designated percentage, designated amount, and its unit of measure.
• DSGN_STRT_DT / DSGN_THRU_DT — designation start and end dates.
• ADDL_INSTRN_TXT — free-form additional instructions.
• LAST_UPDATE_DATE / USER_NAME — audit information identifying when and by whom the record was last changed.

Common Use Cases and Queries

The view supports beneficiary audit reports, plan administration inquiries, and extracts for downstream systems. A typical query retrieving all designations for a given beneficiary name follows:

• SELECT pl_bnf_id, bnf_person_full_name, ttee_person_full_name, pct_dsgd_num, amt_dsgd_val, dsgn_strt_dt, dsgn_thru_dt FROM apps.ben_pl_bnf_d WHERE bnf_person_full_name LIKE :name ORDER BY effective_start_date DESC;
• SELECT pl_bnf_id, organization_name, prmry_cntngnt_meaning, user_name, last_update_date FROM apps.ben_pl_bnf_d WHERE TRUNC(last_update_date) >= :from_date;
• SELECT pl_bnf_id, bnf_person_full_name, amt_dsgd_val, amt_dsgd_uom FROM apps.ben_pl_bnf_d WHERE pct_dsgd_num IS NULL AND amt_dsgd_val IS NOT NULL;

Because the view applies an outer join to BEN_PER_IN_LER, records whose learner status is VOIDD or BCKDT are effectively suppressed, ensuring that only active or completed designations appear. When querying, restrict on EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, or use the datetracked designation dates (DSGN_STRT_DT and DSGN_THRU_DT), to obtain a point-in-time result set appropriate for audit and reconciliation reporting.