Search Results q_c_res

Overview

The concurrent program CN_BIS_SRP_REFRESH_Q_C_RES_CP belongs to the Oracle Incentive Compensation (CN) module and is exposed to end users under the name Update Salesperson Q and C by Res Summary. Its documented purpose is to refresh the DBI materialized view known as q_c_res, which stores quota and commission summary data segmented by resource. This summary supports downstream reporting and analytics for salesperson performance, allowing quota attainment and commission earnings to be analyzed at the resource level without querying the base transactional tables directly.

The program is classified as a Business Intelligence System (BIS) / Sales Resource Planning (SRP) utility within the Incentive Compensation application. It is important to note that the ETRM metadata records this program as Enabled: No, meaning it is delivered in a disabled state and is not intended for routine submission in a standard production environment. This is typical of internal materialized view refresh utilities that are either scheduled by Oracle's own infrastructure or superseded by other refresh mechanisms.

Execution Details

The program executes via the PL/SQL Stored Procedure execution method, using the Standard argument method. The documented executable is CN_BIS_SRP_Q_C_RES_MV, and the execution file is cn_bis_srp_mv_refresh_pvt.refresh_q_c_res_mv. This indicates that the executable maps to a packaged procedure in the private PL/SQL package CN_BIS_SRP_MV_REFRESH_PVT, whose refresh_q_c_res_mv routine performs the actual materialized view refresh operation.

Because the execution logic resides in a private package, the concurrent program acts purely as a submission wrapper. The refresh itself follows Oracle's standard materialized view refresh semantics, which can be complete or fast depending on the materialized view definition and the availability of materialized view logs on the underlying base tables.

How to Run

Under normal circumstances, this program is submitted from the Standard Request Submission (SRS) window in Oracle E-Business Suite (available in both 12.1.1 and 12.2.2) by selecting the user-facing name Update Salesperson Q and C by Res Summary from the list of concurrent programs. Submission can also be scheduled via the Concurrent Programs form, the Request Groups setup, or orchestrated by Oracle Workflow and the concurrent manager.

The metadata does not document any program parameters; the executable is designed to refresh the specific materialized view q_c_res without requiring runtime arguments. General guidance for similar BIS refresh utilities is that they should be scheduled after dependent data loads (such as Incentive Compensation calculation and quota assignment processes) have completed, and during off-peak windows because materialized view refreshes can be resource-intensive. Since the program is delivered disabled, enabling it requires explicit configuration and should generally be performed only under guidance from Oracle Support or when replacing an existing refresh strategy.

Related Objects

The primary related object is the materialized view q_c_res (DBI Quota and Commission by Resource), which this program refreshes. The executable CN_BIS_SRP_Q_C_RES_MV and the package routine cn_bis_srp_mv_refresh_pvt.refresh_q_c_res_mv form the execution chain. Related Incentive Compensation components typically include the quota and commission calculation concurrent programs, the resource and salesperson hierarchy tables, and other CN_BIS_SRP_* refresh utilities that maintain sibling DBI materialized views. Reporting objects and OBIEE/BI Publisher analyses that source from q_c_res depend on the successful completion of this refresh.