Search Results flm_schedule_report

Overview

FLM_SCHEDULE_REPORT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM taxonomy as an "OTHER" API. Its name and structure place it within the Flow Manufacturing (FLM) product family, where it supports the schedule reporting layer used to present production line schedules and bill of material revision context. The package is defined with AUTHID CURRENT_USER, meaning that its unqualified database references resolve against the privileges of the invoking session rather than the package owner, a common pattern for reporting utilities that must respect row-level security and operating unit restrictions enforced by the caller's responsibility and organization context.

Functionally, the package provides the server-side logic behind Flow Manufacturing schedule reports, supplying the data retrieval and formatted output routines that a report template or form calls to render schedule lines at the appropriate level of detail. The "$Header" comment in the source (FLMFSCHS.pls 115.0, dated 1999) indicates the package originates in the earliest releases of the Flow Manufacturing module and has remained stable through the 12.1.1 and 12.2.2 releases documented in ETRM.

The user search term "4 hourly reporting" is consistent with typical Flow Manufacturing usage, where schedule reports are generated at recurring intervals — commonly four-hourly or similar shift-aligned cadences — to refresh line-side demand and sequencing information.

Key Procedures and Functions

• GET_REVISION — A function that returns the bill of material revision applicable to a given organization, item, and effective date. It resolves which revision of an item's BOM is in effect on the date supplied, allowing the report to display the correct configuration for the schedule being reported. The presence of organization, item, and date inputs reflects the standard EBS effective-dating model, where revision applicability is determined by organization-specific item attributes and bill effective dates.
• DISPLAY_ITEM — A function that controls the presentation of an item within the schedule report. It accepts a level and sort order along with a top bill sequence identifier and organization, and returns a numeric value used by the calling report to drive hierarchical display logic — typically indicating how many rows were written or whether processing should continue.

Both functions are declared in the package specification and are therefore part of the public interface available to report templates and custom code. No additional procedures are documented in the ETRM metadata.

Tables Accessed

• BOM_EXPLOSIONS — The core bill of material explosion view used to resolve component structures, levels, and bill sequence information. This table supports both the revision determination in GET_REVISION and the multi-level item display driven by DISPLAY_ITEM.
• MTL_SYSTEM_ITEMS — The item master, joined to obtain item attributes such as description, unit of measure, and other display fields required when presenting schedule lines.

The package does not write to these tables; access is read-only for reporting purposes.

Usage Notes

FLM_SCHEDULE_REPORT is invoked from Oracle Reports report definitions or concurrent programs belonging to the Flow Manufacturing schedule reporting family, and may also be called from custom PL/SQL that needs to reproduce schedule report output. It is not referenced by any other package per the ETRM metadata, which confirms its role as a terminal reporting utility rather than a shared business logic layer.

Because the package is AUTHID CURRENT_USER and accesses the referenced tables through APPS synonyms, callers must run with a valid organization context set (for example via FND_REQUEST or the concurrent program's organization parameter); otherwise the item and bill queries cannot resolve correctly.