Search Results wsm_cost_manager

Overview

APPS.CSTPSMCM is a lightweight PL/SQL package in Oracle E-Business Suite that exposes a single concurrent-program entry point, WSM_COST_MANAGER. The package belongs to the Cost Management (CST) product family and is closely associated with Oracle Work in Process / Shop Floor Manufacturing (WSM) split-and-merge processing. Its business role is to act as the orchestrating driver that invokes cost manager logic against Work in Process split and merge transactions, ensuring that the affected jobs, schedules, and assemblies receive correct costing after the shop floor has redistributed quantities, components, or resources.

The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. In EBS this is significant: it confirms that the package is intended to be invoked from a concurrent program context where APPS-level access to the underlying tables is already established, and where the calling session carries the responsibility and organization context needed to process costed transactions correctly.

Key Procedures and Functions

ETRM documents a single procedure for this package:

• WSM_COST_MANAGER — The sole documented entry point. It accepts a return code and an error buffer as OUT parameters, which is the standard EBS concurrent-program signature: the return code communicates success or failure back to the Concurrent Manager, and the error buffer carries any diagnostic text returned to the concurrent request log. The procedure drives the cost manager processing cycle for Work in Process split and merge activity, reading pending transactions, passing them through costing logic, and reporting completion status to the concurrent request framework.

No public functions are documented for CSTPSMCM. The package contains no additional documented subprograms, so all costing orchestration is funneled through WSM_COST_MANAGER.

Tables Accessed

The package references the following tables through APPS synonyms:

• FND_CONCURRENT_REQUESTS — The standard EBS concurrent request table. It is referenced so the procedure can associate execution with a running concurrent request, report status, and support the concurrent manager's request lifecycle.
• WSM_SPLIT_MERGE_TRANSACTIONS and WSM_SPLIT_MERGE_TRANSACTIONS_S — The base and secondary (translation/language) tables holding Work in Process split and merge transaction records. These are the substantive business data driving the cost manager run; the procedure reads the transactions and processes them for costing.
• DUAL — Used for trivial PL/SQL validation and single-row select operations within the procedure body.

Usage Notes

CSTPSMCM is not an open API intended for ad hoc calls from forms. It is invoked through the concurrent program framework, where the Concurrent Manager supplies the OUT return code and error buffer. Typical invocation is from a scheduled or on-demand concurrent program that runs the Work in Process cost manager for split and merge transactions, often after shop floor operators have split jobs, merged jobs, or reassigned assemblies. Because the package is AUTHID CURRENT_USER, any custom wrapper must be registered and run within the appropriate APPS context.

ETRM shows no other packages referencing CSTPSMCM, indicating it is a top-level driver rather than a shared utility. Customizations should avoid calling it directly; instead, submit the associated concurrent program or reference the standard Work in Process costing flow so that organization, responsibility, and period controls are applied. When diagnosing costing discrepancies after split/merge activity, reviewing the concurrent request output for the WSM_COST_MANAGER run is the primary troubleshooting step.