FR Consistency Log Error

Error Message:

You can run the following query using the SQL developer to view the Flexible Re-categorization (FR) Consistency warning message:

SELECT enterprise_id, code_list_id, decode_context, code, fr_type, log_message, log_date_time FROM etl_fr_consistency_log ORDER BY enterprise_id, code_list_id

The following is the error message:

Figure 14-2 FR Consistency Error

Cause of Error:

The display value for a codelist is NULL in the rm_code_list_detail_discrete table in Oracle Argus Safety.

Resolution:

You must update the value for the codelist in the rm_code_list_detail_discrete table in Oracle Argus Safety and re-run the ETL.