Search Results csf_planboard_tasks




Overview
Explore in AI Chat

Overview

CSF_PLANBOARD_TASKS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM object type OTHER. Its principal responsibility is to populate the planboard staging structures used by the Field Service / Service (CSF and CSP) planboard views. The planboard is the scheduling and dispatch workspace in which planners review field service tasks, resource assignments, capacities, and related customer and incident data on a graphical time-line. Because the planboard must render task, assignment, capacity, and reference data quickly, the package consolidates the required rows into a dedicated planboard table rather than querying the underlying transactional tables directly at render time.

The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and it depends only on the SYS.STANDARD package and the APPS schema itself. The documented metadata records a single exposed program unit, POPULATE_PLANBOARD_TABLE, and lists sixteen referenced tables accessed through APPS synonyms. No other packages are documented as referencing CSF_PLANBOARD_TASKS, so its consumers are form-based or concurrent-program invocations rather than other PL/SQL APIs.

Key Procedures and Functions

The ETRM documentation records exactly one program unit within the package:

  • POPULATE_PLANBOARD_TABLE — The population routine for the planboard staging table. Its purpose is to gather the task, assignment, resource, capacity, and reference rows required by the planboard display and write them into the planboard table. Detailed parameter lists are not published in the ETRM metadata and are deliberately not restated here; the routine should be treated as an internal population program rather than a general-purpose public API.

No other procedures or functions are documented for this package. Callers should not assume the existence of additional program units beyond those recorded in ETRM for the specific EBS release in use.

Tables Accessed

All tables are referenced through APPS synonyms. They fall into four functional groups.

The breadth of this list confirms the package’s role as a denormalising collector: it reads across the task, resource, capacity, service, and customer models and writes the flattened result into the planboard table.

Usage Notes

CSF_PLANBOARD_TASKS is an internal support package for the Service / Field Service planboard. It is typically invoked indirectly — when a planner opens or refreshes the planboard, or through the concurrent programs and form logic that rebuild the planboard staging data — rather than being called directly by end users. Because the package exposes only POPULATE_PLANBOARD_TABLE and is referenced by no other documented package, custom integrations should not treat it as a supported public API.

Typical uses of the documented metadata are impact analysis before patching, dependency review, and confirming that the package remains VALID after an upgrade between 12.1.1 and 12.2.2. Custom code that requires planboard data should generally read the populated planboard table rather than re-invoking this package, and any direct call should be guarded by validation against the target release.