Results for “kb_set”

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

Overview

APPS.CSD_REPAIR_KB_SOLUTIONS_V is a reporting view in Oracle E-Business Suite that correlates repair order lines with the knowledge base solution (article) records linked to them. It resides in the service (CSD) schema family and is exposed under the APPS database user for use by Oracle Service, Depot Repair, and TeleService functionality. The view presents one row per repair line-to-solution association, surfacing the knowledge base set identifier (SET_ID, aliased as SOLUTION_ID), the human-readable solution number and title, and the repair line identifier. In the context of EBS 12.1.1 and 12.2.2, this view is consumed by forms, concurrent programs, and custom reporting to display the "solutions" or knowledge base articles attached to a given repair. Because knowledge base sets can exist in multiple statuses (draft, published, obsolete), the view applies a selection rule—encoded through a scalar DECODE over CS_KB_SETS_B—to return the most appropriate version of a solution for a given set number.

Underlying Base Objects

The view is defined over six referenced objects, as documented in the ETRM metadata:

• CS_KB_SET_LINKS (synonym) — the association table linking a knowledge base set to a business object such as a repair line (OBJECT_CODE = 'DR', OTHER_ID = repair_line_id).
• CS_KB_SET_TYPES_VL (view) — the translated set type definition, joined on SET_TYPE_ID.
• CS_KB_SETS_VL (view) — the translated knowledge base set header, supplying ROW_ID, SET_ID, SET_NUMBER, and NAME.
• CS_KB_SETS_B (synonym) — the base table used in the correlated subqueries that resolve status (PUB, OBS) and select the correct SET_ID per SET_NUMBER.
• CS_LOOKUPS (view) — provides the lookup meaning for LINK_TYPE under lookup_type = 'CS_KB_LINK_TYPE', joined with an outer (+) operator so that missing lookup values do not suppress rows.
• CSD_REPAIRS (synonym) — the repair header/line source supplying REPAIR_LINE_ID.
• FND_GLOBAL (package) — the standard EBS context package, typically referenced for multi-org or security context (commonly via ORG_ID or USER_ID) rather than a direct join.

Key Columns

• ROW_ID — the unique row identifier from the knowledge base set header, useful for integration keys.
• SOLUTION_ID — the SET_ID of the resolved knowledge base set; the primary solution key returned by the view.
• SOLUTION_NUMBER — the user-facing SET_NUMBER of the solution.
• SOLUTION_TITLE — the NAME (title) of the solution.
• REPAIR_LINE_ID — the repair line to which the solution is linked (via OTHER_ID where OBJECT_CODE = 'DR').

The status-resolution logic is the defining characteristic of this view: if exactly one obsolete (OBS) version exists for a set number, the view returns NULL; if exactly one published (PUB) version exists, that SET_ID is returned; otherwise the maximum SET_ID across versions is returned.

Common Use Cases and Queries

Typical uses include displaying solutions attached to a repair in a custom form or OAF page, building depot repair productivity reports, and auditing which knowledge articles were associated with repairs. A representative query follows:

• SELECT solution_id, solution_number, solution_title, repair_line_id FROM apps.csd_repair_kb_solutions_v WHERE repair_line_id = :p_repair_line_id;
• SELECT r.repair_line_id, v.solution_number, v.solution_title FROM apps.csd_repairs r, apps.csd_repair_kb_solutions_v v WHERE r.repair_line_id = v.repair_line_id;
• SELECT solution_number, COUNT(*) FROM apps.csd_repair_kb_solutions_v GROUP BY solution_number ORDER BY 2 DESC;

Because the view already applies the published/obsolete selection rule, callers need not re-implement status filtering; the returned SET_ID is the authoritative solution instance to present to users. The presence of both CS_KB_SETS_VL and CSD_REPAIRS ensures multilingual titles and repair context are available in a single query.