Search Results csd_bulletins_b




Overview
Explore in AI Chat

Overview

CSD_BULLETINS_B is the base table for service bulletins within the CSD (Depot Repair) product module of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. Service bulletins are internal communications — quality alerts, repair instructions, escalation notices, or process advisories — that depot repair organizations distribute to technicians, repair agents, and operational staff. The table resides in the CSD schema and is documented as VALID in ETRM. It serves as the master (header) entity for bulletin definitions, storing identifying, scheduling, workflow, and descriptive attributes that govern how and when a bulletin is surfaced to its audience.

Under a Data Vault modeling heuristic, the observed foreign-key topology classifies CSD_BULLETINS_B as hub-leaning: it is the referenced anchor for dependent child tables, and no foreign keys point outward from it to other hubs. This suggests treating BULLETIN_ID as a durable business key candidate at the center of the bulletin subject area, with dependent associations and descriptors modeled as separate satellites or links.

Key Information Stored

The table contains 32 documented columns. The most significant are:

The primary key is a system-generated surrogate; the documented unique index exposes BULLETIN_ID only, so any human-readable business identifier is carried in the flexfield or type/date attributes rather than a separate business-key column.

Common Use Cases and Queries

Typical scenarios include reporting the currently active bulletin set for a repair organization, auditing which bulletins are mandatory, and driving workflow notifications when a bulletin is published. A representative query retrieves active, published bulletins within their effective window:

  • SELECT b.bulletin_id, b.bulletin_type_code, b.escalation_code, b.mandatory_flag FROM csd.csd_bulletins_b b WHERE b.published_flag = 'Y' AND SYSDATE BETWEEN b.active_from AND NVL(b.active_to, SYSDATE + 1) AND b.mandatory_flag = 'Y';
  • Joining to CSD_BULLETIN_SCS to report which service organizations are scoped to each bulletin: SELECT s.bulletin_id, s.* FROM csd.csd_bulletin_scs s WHERE s.bulletin_id = :p_bulletin_id;
  • Auditing workflow-enabled bulletins: filter on wf_item_type IS NOT NULL and join to WF tables for notification history.

Because the table is the hub, most operational reporting joins child tables on BULLETIN_ID and applies date and flag predicates at the header level.

Related Objects

  • CSD_BULLETIN_SCS — references CSD_BULLETINS_B via BULLETIN_ID; holds the service/organization scoping of each bulletin.
  • CSD_RO_BULLETINS — references CSD_BULLETINS_B via BULLETIN_ID; associates bulletins with repair orders or related repair entities.
  • CSD_BULLETINS_PK1 — the primary key constraint enforcing BULLETIN_ID uniqueness.
  • CSD_BULLETINS_B_U1 — the unique index on BULLETIN_ID, the documented business-key candidate.
  • Oracle Workflow (WF_ITEM_TYPE / WF_PROCESS_NAME) — external dependency for bulletin notification and approval processes.
  • Standard EBS audit and DFF infrastructure that consumes the CREATED_BY / LAST_UPDATED_BY and ATTRIBUTE columns.