My Oracle Support Banner

Some of the Placeholders Still Referring to the Old Table (Doc ID 2801557.1)

Last updated on AUGUST 25, 2021

Applies to:

Oracle Argus Dossier - Version 8.2.2 and later
Information in this document applies to any platform.

Symptoms

The following placeholder's SQL are referring to old tables and should be updated to refer to current tables.

Placeholders are stored in CFG_PLACEHOLDERS table and each placeholder is referring to tables by SQL stored at SQL_QUERY and SQL_QUERY_J columns.

The SQL in CFG_PLACEHOLDERS.SQL_QUERY and CFG_PLACEHOLDERS.SQL_QUERY_J should be updated to retrieve data from current version right table respectively.

PlaceHolder Name Table Name (Argus 7.0.7) Table Name (Argus 8.2.2)
[Evaluation_codes_method1]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_method2]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_method3]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_method4]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Result1]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Result2]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Result3]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Result4]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Conclusion1]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Conclusion2]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Conclusion3]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[Evaluation_codes_Conclusion4]:[n] CASE_PROD_DEVICES CASE_PROD_DEV_EVAL
[dev_subcomponent]:[n] CASE_PROD_DEVICES CASE_PROD_COMPONENT
[comp_name]:[n]:[m] CASE_PROD_DEVICES CASE_PROD_COMPONENT
[ethnicity] CASE_PAT_INFO CASE_PAT_RACE

 

* The following SQL can retrieve the existing placeholders records which are pointed out by the customer.

=====
select * from CFG_PLACEHOLDERS where PLACE_HOLDER in (
'[Evaluation_codes_method1]:[n]',
'[Evaluation_codes_method2]:[n]',
'[Evaluation_codes_method3]:[n]',
'[Evaluation_codes_method4]:[n]',
'[Evaluation_codes_Result1]:[n]',
'[Evaluation_codes_Result2]:[n]',
'[Evaluation_codes_Result3]:[n]',
'[Evaluation_codes_Result4]:[n]',
'[Evaluation_codes_Conclusion1]:[n]',
'[Evaluation_codes_Conclusion2]:[n]',
'[Evaluation_codes_Conclusion3]:[n]',
'[Evaluation_codes_Conclusion4]:[n]',
'[dev_subcomponent]:[n]',
'[comp_name]:[n]:[m]',
'[ethnicity]')
order by PLACE_ID;
=====

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.