Search Results even_rev_dist

Overview

APPS.CN_SCA_WF_PKG is a public PL/SQL package within the Oracle E-Business Suite Channel Revenue Management (CN) product family. It encapsulates the workflow processes that drive Sales Credit Allocation (SCA) standard Revenue Distribution and Transaction Transfer. Its stated business purpose is to orchestrate the automated allocation of revenue across transactions processed in batch mode, and to allow the creation of plan element assignments as part of the same flow. It is registered in ETRM as an active, public API with a compatibility rating of S and the business entity category CN_COMP_PLANS. The package is compiled AUTHID CURRENT_USER and carries an internal version header of 120.1 (2005), reflecting its long-standing stabilization across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes nine documented procedures and functions. START_PROCESS initiates the workflow process for online Revenue Distribution, taking the SCA batch identifier along with the workflow process and item type specifications; the documented process identifier is CN_SCA_REV_DIST_PR and the item type is CNSCARPR. SELECTOR serves as the workflow selection routine that determines whether a given item proceeds down the revenue distribution path. REV_DIST_SELECT and TRX_LOAD_SELECT provide the selection logic for the revenue distribution and transaction loading branches respectively. EVEN_REV_DIST performs revenue distribution using an even (equal) split method, while WTD_REV_DIST applies a weighted distribution method. CN_TRX_LOAD handles the loading of transaction data into the SCA workflow pipeline. The package also exposes the processing status constants G_REV_NOT_100 ('REV NOT 100'), G_ALLOCATED ('ALLOCATED'), and G_PROFILE ('CN_SCA_REV_NOT_100'), which govern how a batch is classified as it moves through allocation.

Tables Accessed

The package operates against five documented tables through APPS synonyms. CN_SCA_HEADERS_INTERFACE is the primary staging table for SCA batch headers and is referenced by the batch identifier passed to START_PROCESS; CN_SCA_HEADERS_INTERFACE_GTT provides the global temporary counterpart used for session-scoped processing. CN_SCA_LINES_OUTPUT and CN_SCA_LINES_OUTPUT_GTT hold the computed allocation lines produced by the revenue distribution routines, with the GTT variant supporting intermediate workflow calculation. FND_APPLICATION is referenced for application context resolution, consistent with standard Oracle EBS API conventions. Together these objects support the full staging-to-output lifecycle of a Sales Credit Allocation batch.

Usage Notes

CN_SCA_WF_PKG is not intended for direct ad hoc invocation. It is normally called by the Sales Credit Allocation engine and by Oracle Workflow, which executes the selector and distribution functions as part of the CN_SCA_REV_DIST_PR process. The package is referenced by three other packages, indicating it sits in the middle of the SCA call stack rather than at its edge. Custom code that needs to inspect the "sca_trx_sources" concept should query the SCA interface and output tables listed above rather than calling these workflow entry points directly. Because the procedures are workflow-driven, any custom invocation must supply a valid SCA batch identifier that already exists in CN_SCA_HEADERS_INTERFACE, and should be restricted to environments where the SCA workflow background processes are not running concurrently.