Results for “csd_bulletin_types”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CSD_BULLETINS_V is a reporting and inquiry view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that presents bulletin definitions maintained within the Service (CSD) module. In EBS, bulletins are broadcast communications — such as service alerts, field notices, quality notifications, or internal escalation messages — that can be published to users, workgroups, or downstream processes. Although the requesting user searched under the phrase "classification board reports," the documented object is the bulletin view; the two concepts are adjacent in that both concern structured content categories and their distribution, but CSD_BULLETINS_V exposes bulletin metadata rather than classification board data itself.

The view consolidates the base bulletin record with translated descriptive text, lookup-decoded meanings, and workflow process display names. It is commonly used in Oracle Reports, BI Publisher data templates, OAF/Forms-based inquiries, and custom PL/SQL integrations that need to enumerate active or published bulletins without joining the underlying transactional tables directly. Its principal value lies in hiding the multilingual, lookup, and workflow joins from the consuming report.

Underlying Base Objects

The view is defined over the following documented base objects:

• CSD_BULLETINS_B (synonym) — the base table holding the bulletin header: identifiers, type, escalation, frequency, effective dates, published and mandatory flags, workflow linkage, and the standard 15 descriptive flexfield attributes.
• CSD_BULLETINS_TL (synonym) — the translation table supplying the language-specific bulletin name and description; joined on language = userenv('LANG'), so each session sees text in its own language.
• FND_LOOKUPS (view) — joined three times to decode bulletin type (CSD_BULLETIN_TYPES), escalation code (CSD_ESCALATION_CODES, outer-joined), and frequency (CSD_BULLETIN_FREQUENCY).
• WF_RUNNABLE_PROCESSES_V (view) — outer-joined on workflow item type and process name to retrieve the process display name.
• FND_GLOBAL (package) — invoked implicitly via USERENV('LANG') for the language context.

The joins are inner on the base and translation tables and on bulletin type and frequency lookups, but outer on escalation code and the workflow process view, allowing bulletins without an escalation or workflow process to remain visible.

Key Columns

• BULLETIN_ID — primary identifier for the bulletin.
• NAME / DESCRIPTION — translated text from CSD_BULLETINS_TL.
• BULLETIN_TYPE_CODE, MEANING, DESCRIPTION — coded type plus decoded meaning from FND_LOOKUPS.
• ACTIVE_FROM / ACTIVE_TO — validity window for the bulletin.
• PUBLISHED_FLAG / MANDATORY_FLAG — publication state and whether acknowledgement is compulsory.
• ESCALATION_CODE, MEANING, DESCRIPTION — optional escalation classification.
• FREQUENCY_CODE, MEANING, DESCRIPTION — recurrence or delivery cadence.
• WF_ITEM_TYPE, WF_PROCESS_NAME, DISPLAY_NAME — associated workflow process and its user-facing name.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — descriptive flexfield content.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Typical scenarios include generating a listing of currently published bulletins for a service dashboard, validating mandatory bulletins, and extracting workflow-linked bulletins for escalation reporting.

List all published bulletins active today:

SELECT bulletin_id, name, bulletin_type_code, active_from, active_to
FROM   apps.csd_bulletins_v
WHERE  published_flag = 'Y'
AND    SYSDATE BETWEEN NVL(active_from, SYSDATE) AND NVL(active_to, SYSDATE);

Report by type and frequency with decoded meanings:

SELECT bulletin_type_code, frequency_code, COUNT(*) bulletins
FROM   apps.csd_bulletins_v
GROUP  BY bulletin_type_code, frequency_code;

Identify mandatory bulletins tied to a workflow process:

SELECT name, wf_item_type, wf_process_name, display_name
FROM   apps.csd_bulletins_v
WHERE  mandatory_flag = 'Y'
AND    wf_process_name IS NOT NULL;

Because the view applies userenv('LANG'), query results are automatically localized; reports spanning multiple languages must set the session language accordingly or query CSD_BULLETINS_TL directly.