Search Results rci_bp_cert_result_v




Overview
Explore in AI Chat

Overview

RCI_BP_CERT_RESULT_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AMW – Internal Controls Manager product family. Its documented purpose is to supply the definition of the Business Process Certification Results dimension, a conformed dimension used when reporting or extracting certification outcomes for business processes in Internal Controls Manager (ICM). The view is marked VALID in the ETRM repository and is available in both Oracle EBS 12.1.1 and 12.2.2.

Functionally, the view normalizes the set of possible certification result values into a simple two-column dimension of an identifier (ID) and a display label (VALUE). This two-column shape makes it suitable for direct use as a dimension source in Oracle Business Intelligence, Discoverer, or custom reports, and as a lookup source in data-integration or extract programs. One row is generated for each active opinion value belonging to the certification opinion type, plus one synthetic row representing the "NOT_CERTIFIED" evaluation status.

Underlying Base Objects

The view is defined over six base objects. Two of them, AMW_OPINION_VALUES_B and AMW_OPINION_VALUES_TL, are the base and translation tables for opinion values; they supply the opinion value identifier and its language-specific name. AMW_OPINION_COMPONTS_B and AMW_OPINION_TYPES_B link opinion values to their opinion components and opinion types. AMW_OBJECT_OPINION_TYPES associates opinion types with objects, and FND_OBJECTS provides the object identity. The final member of the UNION ALL branch is AMW_LOOKUPS, restricted to the lookup type RCI_CERT_EVAL_STATUS.

Joins in the first branch are driven by OPINION_VALUE_ID, OPINION_COMPONENT_ID, OBJECT_OPINION_TYPE_ID, OBJECT_ID, and OPINION_TYPE_ID, with the object type name fixed to AMW_ORGANIZATION and the opinion type code fixed to 'CERTIFICATION'. The row set is filtered to current or future-dated opinion values, since records with an end date in the past are excluded. The second branch adds the single NOT_CERTIFIED lookup value.

Key Columns

  • ID — In the first UNION ALL branch, the OPINION_VALUE_CODE of the opinion value; in the second branch, the LOOKUP_CODE, which is the constant 'NOT_CERTIFIED'. This is the dimension key.
  • VALUE — In the first branch, the translated OPINION_VALUE_NAME returned for the session language; in the second branch, the MEANING of the RCI_CERT_EVAL_STATUS lookup with code NOT_CERTIFIED. This is the display label.

Because the second column is sourced from a translated table and from a lookup meaning, the view is language-sensitive. The translation join uses USERENV('LANG'), so the values returned reflect the language of the querying session.

Common Use Cases and Queries

Typical uses include populating a certification result prompt or list of values, mapping stored opinion codes to readable names during extraction, and validating certification outcome data before loading it into a reporting layer.

To retrieve the full dimension:

  • SELECT ID, VALUE FROM APPS.RCI_BP_CERT_RESULT_V ORDER BY VALUE;

To confirm that the NOT_CERTIFIED placeholder is present:

  • SELECT ID, VALUE FROM APPS.RCI_BP_CERT_RESULT_V WHERE ID = 'NOT_CERTIFIED';

To drive a reporting query, the view can be outer-joined to certification fact data on the opinion value code, translating stored codes into user-facing labels while retaining records that have no certification opinion, which is where the NOT_CERTIFIED row becomes relevant. Because the view is a definition-only dimension and not a transactional source, it should be treated as reference data rather than as a repository of individual certification transactions.