Search Results rqstd_flag_m

Overview

APPS.BENBV_PER_CM_PRVDD_V is a read-only Oracle EBS view that exposes the "person communication provided" records used by Oracle Advanced Benefits (BEN) to track outbound communications delivered to participants, dependents, and other beneficiaries. It presents the communication-provided history—when a communication was sent, its delivery method and medium, whether the recipient requested it, whether inspection was required, and any re-send reason recorded against the communication. The view's primary role is to support concurrent programs, Oracle Business Intelligence (OBI) extracts, and integration points that must report on delivery status without joining the BEN_PER_CM_PRVDD_F table to the FND lookup and flexfield infrastructure directly. The name and column composition indicate it is an "BV" (business view) wrapper, meaning it is designed for consumption by forms, reports, and external extracts rather than as a transactional table. Because the view filters on the business group, it enforces row-level security via HR_BIS.GET_SEC_PROFILE_BG_ID, restricting results to the security profile assigned to the querying user at run time.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the view is defined over two documented objects:

• BEN_PER_CM_PRVDD_F (referenced via a synonym) — the base table that stores each communication-provided record, including delivery dates, method/medium codes, status, and re-send information.
• HR_BIS (package) — used to invoke HR_BIS.BIS_DECODE_LOOKUP for translating stored codes into user-readable meanings, and to obtain the security business group ID via GET_SEC_PROFILE_BG_ID.

The view is defined WITH READ ONLY, so it cannot be used for DML. It projects the descriptive flexfield reference '_DF:BEN:BEN_PER_CM_PRVDD_F:PCD', which allows consumers to render the DFF context and segments attached to BEN_PER_CM_PRVDD_F. The security predicate WHERE PCD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PCD.BUSINESS_GROUP_ID) ensures that when a security profile business group exists, only that business group's rows are returned; otherwise all business groups are visible. This is the standard BEN BV security pattern.

Key Columns

• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — datetracked validity range for the communication record.
• SENT_DT / TO_BE_SENT_DT — actual and scheduled transmission dates. These drive delivery compliance reporting.
• INSTNC_NUM — instance number identifying which occurrence of a recurring communication was sent.
• DLVRY_INSTN_TXT — free-text delivery instructions supplied to the delivery channel.
• RESND_CMNT_TXT — comment captured when a communication is re-sent.
• PER_CM_PRVDD_STAT_CD and its lookup meaning (BEN_PER_CM_PRVDD_STAT) — delivery status.
• CM_DLVRY_MED_CD (BEN_DLVRY_MED) — medium, e.g., print or electronic.
• CM_DLVRY_MTHD_CD (BEN_DLVRY_MTHD) — method, e.g., mail, e-mail, fax.
• RESND_RSN_CD (BEN_RESND_RSN) — the reason the communication was re-sent. This is the column referenced by the user's search term ben_resnd_rsn, and it is decoded through HR_BIS.BIS_DECODE_LOOKUP.
• RQSTD_FLAG / INSPN_RQD_FLAG (YES_NO) — whether the communication was requested and whether inspection is required.
• PER_CM_PRVDD_ID, PER_CM_ID, BUSINESS_GROUP_ID, ADDRESS_ID — primary and foreign identifiers linking the record to the communication and to the recipient's address.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID — request/program context for audit and traceability.
• WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE) — standard audit attributes.

Common Use Cases and Queries

Typical uses include communication delivery audits, re-send analysis (the ben_resnd_rsn lookup), and population of OBI/EDW extracts. A representative query listing re-sent communications and their decoded reason follows:

SELECT p.SENT_DT,
       p.INSTNC_NUM,
       p.PER_CM_PRVDD_STAT_CD,
       p.RESND_RSN_CD,
       HR_BIS.BIS_DECODE_LOOKUP('BEN_RESND_RSN', p.RESND_RSN_CD) RESND_RSN_MEANING,
       p.CM_DLVRY_MED_CD,
       p.CM_DLVRY_MTHD_CD,
       p.PER_CM_ID
FROM   APPS.BENBV_PER_CM_PRVDD_V p
WHERE  p.RESND_RSN_CD IS NOT NULL
AND    p.SENT_DT >= TRUNC(SYSDATE) - 90
ORDER BY p.SENT_DT DESC;

Because the view already decodes lookups and enforces business-group security, it is preferable to querying BEN_PER_CM_PRVDD_F directly. Note that it is read-only and should not be used for updates; all maintenance must go through the base table or the BEN forms and APIs.