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
- GET_KPI — Builds dynamic SQL for a BIS_PMV dashboard page. Iterates the page parameter table and constructs a WHERE clause based on parameters such as
RCI_FS_CERT(certification id),RCI_FS_CERT_TYPE, and time dimensions (FII_TIME_ENT_PERIOD_FROM,FII_TIME_ENT_QTR_FROM). - GET_SIG_ACCT_EVAL_DETAILS / GET_SIG_ACCT_EVAL_RESULT / GET_SIG_ACCT_EVAL_SUMM_RESULT — Return detail, line-level result, and summarized evaluation results for significant accounts.
- GET_SIG_ACCT_DETAILS — Retrieves the underlying significant account attributes.
- GET_RISK_COUNT / GET_UNMITI_RISKS — Count and list unmitigated risks associated with significant accounts.
- GET_CONTROL_COUNT / GET_INEFF_CTRLS / GET_INEFF_PROCS — Count controls and retrieve ineffective controls and processes.
- GET_LATEST_ENGAGEMENT — Returns the most recent engagement record.
- COUNTORGSINEFFCTRL_FINITEM, COUNTUNMITTIGATEDRISK_FINITEM, COUNTINEFFECTIVECTRLS_FINITEM — Item-level count functions supporting financial reporting summaries.
- SIG_ACCT_INCREMENTAL_LOAD / SIG_ACCT_INITIAL_LOAD — Load or refresh the summary table via incremental or full (initial) population.
- GET_ORG_DETAILS / GET_ORG_DEF_DETAILS — Retrieve organization definition data for scoping.
Tables Accessed
The package references the following tables through APPS synonyms:
- AMW_CERTIFICATION_B — certification master data.
- AMW_EXECUTION_SCOPE, AMW_FIN_CERT_SCOPE — certification scope and execution scope.
- AMW_FIN_CERT_EVAL_SUM — summarized certification evaluation results.
- AMW_CONTROL_ASSOCIATIONS, AMW_RISK_ASSOCIATIONS — associations linking controls and risks to accounts/processes.
- AMW_OPINIONS — certification opinions.
- RCI_DR_INC — incremental staging table used by the load routines.
- RCI_SIG_ACCT_EVAL_F — the significant account evaluation fact table.
- PLITBLM — the standard PL/SQL integer table type used for bulk processing.
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.