Results for “rci_fs_cert_type”

6 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.RCI_SIG_ACCT_EVAL_SUMM_PKG package body supports the Significant Account Evaluation and Certification functionality within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, delivered primarily through Oracle's Enterprise Risk and Compliance (formerly the Financial Compliance / Internal Controls Manager modules built on the AMW schema). Its primary business purpose is to drive the dashboard and summary reporting of significant account evaluations, certifications, risk assessments, and control effectiveness results. The package provides the KPI (Key Performance Indicator) query generation logic used by Oracle Financials Intelligence / BIS-based dashboard regions, together with data-loading routines that populate the RCI_DR_INC staging table and summary evaluation tables. The internal constant RCI_FS_CERT referenced in GET_KPI reflects the certification page parameter passed from the dashboard region, confirming the package's tight coupling to the Certification and Significant Account Evaluation business flow.

Key Procedures and Functions

Tables Accessed

The package references the following tables through APPS synonyms:

Usage Notes

This package is invoked primarily by Oracle Financials Intelligence dashboard pages (via GET_KPI) and by concurrent programs that perform the initial and incremental loads of significant account evaluation summary data. It is not referenced by any other PL/SQL package (referenced by 0 packages), indicating it is a top-level consumer that relies on AMW and RCI base tables directly. Because the version header indicates the last modification in 2007, the body is stable and shared between 12.1.1 and 12.2.2, though it should be treated as a seeded (non-custom) object and never modified without a patch-safe wrapper.