Search Results trgt_table

Overview

WIP_BIS_ALERTS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It supports the Work in Process (WIP) Business Intelligence System (BIS) alerting framework by comparing actual manufacturing performance against defined targets and triggering workflow notifications when deviations warrant attention. The package declares AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, which is significant in a multi-organization, multi-responsibility environment where data access is frequently gated by organization-level security.

The package is classified under the ETRM "OTHER" API classification, indicating that it is an internal supporting package rather than a public, formally supported extension API. Its logic is oriented around period-based manufacturing metrics: it retrieves actual values for a completed or in-progress period, resolves the corresponding target value from a configurable target source, and then initiates a workflow process when the comparison indicates an alert condition.

Key Procedures and Functions

• POST_ACTUAL_TO_BIS — Writes an actual performance value into the BIS data store for a specified target short name, accounting period set, period name, and organization.
• GET_LAST_COMP_PERIOD — Returns the most recently completed period for a given function, period set, and period type, along with its start and end dates. This establishes the reporting window for alert evaluation.
• GET_ACTUAL — Retrieves the actual metric value for a function, period set, period, and organization. It is the read-side counterpart to POST_ACTUAL_TO_BIS.
• GET_TARGET — Resolves the target value for a given target table, period set, period, and organization. Significantly, this is the procedure that consumes the trgt_table parameter, which identifies the source table from which the target is drawn. It also returns supporting workflow context: the workflow process name, role, and role identifier used to route the resulting notification.
• ALERT_CHECK — The driving procedure for the alerting cycle. For a specified function it compares actual against target values and determines whether an alert condition exists.
• WIP_STRT_WF_PROCESS — Initiates the Oracle Workflow process that delivers the alert. It accepts subject, period, legal entity, organization, workflow process, role, actual and target values, report name and parameter, and responsibility identifier, and returns a status indicator.

Tables Accessed

The ETRM metadata supplied does not enumerate specific base tables referenced through APPS synonyms. Functionally, the package operates against WIP BIS target and actual tables — the target table being dynamically named via the trgt_table parameter passed to GET_TARGET. This design allows different manufacturing metrics to draw their targets from different tables without requiring package changes, with the target table name supplied at runtime. The trgt_table parameter is therefore the key configuration point users searching for this term will encounter.

Usage Notes

WIP_BIS_ALERTS is normally invoked indirectly rather than called directly by end users. ALERT_CHECK is the natural entry point for a scheduled concurrent program or a periodic workflow-triggered evaluation that runs after period close, retrieves actuals and targets, and launches WIP_STRT_WF_PROCESS when thresholds are breached. The package is referenced by zero other packages according to the metadata, confirming it sits at the outer edge of the call graph and is driven by external scheduling or custom code. Customizations that supply a trgt_table value, or that call GET_TARGET, GET_ACTUAL, or POST_ACTUAL_TO_BIS directly, must be validated during upgrades because the package is an internal "OTHER" classification object and is not covered by Oracle's public API compatibility guarantees.