Oracle® Argus Insight

CMN Profile Global Table Guide

Release 8.1.1

E90559-01

September 2017

Oracle Argus Insight CMN Profile Global Table Guide, Release 8.1.1

E90559-01

Copyright © 2010, 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Where to Find More Information

- Documentation Accessibility

1 Introduction

- 1.1 Internal Use Rows

- 1.2 About the Columns in the CMN_PROFILE_GLOBAL Table

- 1.3 Examples of Modifying the CMN_PROFILE_GLOBAL Table

2 SYSTEM Profile Global Switches

- 2.1 BLOB_DATA_POPULATION

- 2.2 CASE_DATA_POPULATION

- 2.3 CLEAR_XML_CACHE

- 2.4 COGNOS_AUTHENTICATION_ENTERPRISE

- 2.5 COGNOS_SINGLE_SIGN_ON_ENABLED

- 2.6 DEFAULT_ENTERPRISE

- 2.7 DUP_SEARCH_DATA_POPULATION

- 2.8 ESM_CLOB_DATA_POPULATION

- 2.9 ETL_COMPUTE_BALANCING

- 2.10 ETL_ENTERPRISE_PROGRESS

- 2.11 FORCE_SECURE_COOKIES

- 2.12 INSIGHT_HELP_URL

- 2.13 IS_CFG_CUST_WKF_STATES_UPDATED

- 2.14 LEGACY_REPORTS_CONFIGURATION

- 2.15 MAXIMUM_EMAIL_ATTEMPTS

- 2.16 POST_INCREMENTAL_ETL_TASK

- 2.17 PRE_INCREMENTAL_ETL_TASK

- 2.18 REPORT_DATA_POPULATION

- 2.19 SINGLE_SIGN_ON_ENABLED

- 2.20 SINGLE_SIGN_ON_HTTP_HEADER

- 2.21 TEMP_TABLE_DATA_POPULATION

3 DATABASE Profile Global Switches

- 3.1 Key 1

- 3.2 Key 2

- 3.3 Key 3

- 3.4 Key 4

- 3.5 Key 5

- 3.6 Key 6

- 3.7 Key 7

- 3.8 Key 8

- 3.9 Key 9

- 3.10 ACCESS

- 3.11 APP_OWNER

- 3.12 APP_OWNER_PASSWORD

- 3.13 APP_ROLE

- 3.14 APPLICATION_TYPE

- 3.15 COMMIT_AFTER_ROWS

- 3.16 COMMIT_EVERY_TABLE

- 3.17 COMMON_USER

- 3.18 DDL_VER

- 3.19 DDL_VER_INITIAL

- 3.20 DEFAULT_SECURITY_ACCESS

- 3.21 ETL_COMPUTE_MART_USER_STATISTICS

- 3.22 ETL_COMPUTE_STAGE_USER_STATISTICS

- 3.23 ETL_EMAIL_RECEIVER_ADDRESS

- 3.24 ETL_EMAIL_SETUP

- 3.25 ETL_STATS_CASCADE_OPTION

- 3.26 ETL_STATS_ESTIMATE_PERCENT

- 3.27 ETL_STATS_METHOD_OPT

- 3.28 ETL_STATS_PARALLEL_DEGREE

- 3.29 ETL_STATUS

- 3.30 INCR_ETL_PRE_REQ_STATUS

- 3.31 INCR_ETL_STEP

- 3.32 INCREMENTAL_ETL_STATUS

- 3.33 INITIAL_ETL_PRE_REQ_STATUS

- 3.34 LAST_ETL_START_DATETIME

- 3.35 LOGIN_OWNER

- 3.36 MART_HIST_OWNER

- 3.37 MART_OWNER

- 3.38 MEMORY_MODEL

- 3.39 PRE_REQ_CHECK_FLAG

- 3.40 READ_ONLY_OWNER

- 3.41 READ_ONLY_ROLE

- 3.42 RLS_OWNER

- 3.43 ROLE_NAME

- 3.44 RUN_INCR_ETL_EVERY_TIME

- 3.45 SAFETY_DDL_VER

- 3.46 STAGE_OWNER

- 3.47 VERY_FIRST_INITIAL_ETL_COMPLETE

- 3.48 LOG_REPORT_SQL

4 Profile Global Switches for Related Applications

- 4.1 Profile Global Switches Specific to Argus Safety

- 4.1.1 CURRENT_CASE_COPY

- 4.1.2 CURRENT_CASE_COPY

- 4.1.3 GMT_OFFSET

- 4.1.4 LAST_CASE_COPY

- 4.1.5 PREVIOUS_TO_LAST_CASE_COPY

Preface

This Oracle Argus Insight CMN Profile Global Table Guide describes the profile switches that you can use to control the behavior of the Argus Insight application.

Where to Find More Information

Oracle Help Center

The latest user documentation for Oracle Health Sciences products is available at http://docs.oracle.com/en/industries/health-sciences/.

My Oracle Support

The latest release notes, patches and white papers are on My Oracle Support (MOS) at https://support.oracle.com. For help with using MOS, see https://docs.oracle.com/cd/E74665_01/MOSHP/toc.htm.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

1 Introduction

The CMN_PROFILE_GLOBAL table contains values that control the behavior of the Argus Insight application.

You can update many of these values by modifying the Profile Switches in the List Maintenance tab on the ADMINISTRATION TOOLS page in Argus Insight.

Other values you can access and update only through direct SQL statements.

In addition to the CMN_PROFILE_GLOBAL table, the CMN_PROFILE_ENTERPRISE table contains values that control the behavior of all enterprises in Argus Insight. For more information about modifying the profile enterprise switches, see the Oracle Argus Insight CMN Profile Enterprise Table Guide.

1.1 Internal Use Rows

During the initial Factory Data load when the database is created, the system creates several Internal Use rows. As the name implies, these rows of values are for Argus Insight internal use only.

Do not modify any values in the internal use rows.

1.2 About the Columns in the CMN_PROFILE_GLOBAL Table

Each profile switch described in this guide includes the following information:

- Section — Lists the name of the section within the CMN_PROFILE_GLOBAL table that has the profile switch. The sections are as follows:

- SYSTEM

- DATABASE

- ARGUS

- BOXI (for BusinessObjects XI)

- COGNOS8

- Key — Lists the unique name for the profile switch.

- Company Defined — Indicates the method you can use to modify the profile switch:

- 0 = Indicates you can modify this profile switch only by issuing direct SQL statements. You should modify these profile switches with assistance from Oracle Support.

- 1 = Indicates you can modify this profile switch either by using the options in the List Maintenance tab in the Argus Insight application or by issuing direct SQL statements.

- Name — Lists the name of the profile switch as displayed in the List Maintenance tab in the Argus Insight application.

- Default Value — Lists the default value, if defined.

- Description — Provides more information about the function of the profile switch.

1.3 Examples of Modifying the CMN_PROFILE_GLOBAL Table

This section provides sample SQL for how to update and insert values in the CMN_PROFILE_GLOBAL table in the database.

Note that values, as specified, are case sensitive.

Updating an Existing Value

To update an existing value in the CMN_PROFILE_GLOBAL table:

UPDATE CMN_PROFILE_GLOBAL set value = '10'
WHERE section = 'DATABASE' AND key = 'ABC';
commit;

Inserting a New Row of Values

To insert a new row of values into the CMN_PROFILE_GLOBAL table:

INSERT into CMN_PROFILE_GLOBAL (section, key, company_defined, name, value, description)
values ('DATABASE', 'ABC', '0', 'ABC', '10', 'ABC_DEF_XYZ');
commit;

2 SYSTEM Profile Global Switches

This chapter lists the SYSTEM profile global switches for Argus Insight.

For information about the profile global switches you can use to change settings for the database or for your related application (Argus Safety), see Chapter 3, "DATABASE Profile Global Switches" and Chapter 4, "Profile Global Switches for Related Applications," respectively.

2.1 BLOB_DATA_POPULATION

Section

SYSTEM

Key

BLOB_DATA_POPULATION

Company Defined

1

Name

POPULATE BLOB DATA

Default Value

0

Description

Defines whether to bring all Binary LOB (BLOB) data into the data mart. BLOB data includes data type columns of Argus Owner Schema tables and Interchange Schema Owner tables.
0 — Do not bring any BLOB data into the data mart

1 — Bring all BLOB data into the data mart

To populate all BLOB columns data from Argus Database, set the value of this switch to 1. Oracle recommends that you leave the value of this switch set to 0.

2.2 CASE_DATA_POPULATION

Section

SYSTEM

Key

CASE_DATA_POPULATION

Company Defined

1

Name

POPULATE CASE/CONFIGURATION DATA

Default Value

1

Description

Sets the flag for populating case/configuration data.

- 0 — Populate configuration data only

- 1 — Populate all the data (case and configuration data)

2.3 CLEAR_XML_CACHE

Section

SYSTEM

Key

CLEAR_XML_CACHE

Company Defined

0

Name

CLEAR XML CACHE

Default Value

0

Description

Sets the flag for clearing the XML cache.
Argus Insight sets this value to 1 every time you run Incremental ETL and sets this value to 0 whenever the XML cache is cleared.

2.4 COGNOS_AUTHENTICATION_ENTERPRISE

Section

SYSTEM

Key

COGNOS_AUTHENTICATION_ENTERPRISE

Company Defined

1

Name

COGNOS AUTHENTICATION ENTERPRISE

Default Value

—

Description

Defines the short name of the enterprise from which all users are authenticated for Cognos login. All Argus Insight users must be a member of this template enterprise. On the Cognos Server, Cognos security is enabled only after this switch is configured.

2.5 COGNOS_SINGLE_SIGN_ON_ENABLED

Section

SYSTEM

Key

COGNOS_SINGLE_SIGN_ON_ENABLED

Company Defined

1

Name

COGNOS SINGLE SIGN ON ENABLED

Default Value

0

Description

Determines if Cognos is Single Sign-On enabled or not.
0 — Cognos Single Sign-On is disabled

1 — Cognos Single Sign-On is enabled

2.6 DEFAULT_ENTERPRISE

Section

SYSTEM

Key

DEFAULT_ENTERPRISE

Company Defined

0

Name

DEFAULT ENTERPRISE

Default Value

2

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle default enterprise ID for Argus Insight.

2.7 DUP_SEARCH_DATA_POPULATION

Section

SYSTEM

Key

DUP_SEARCH_DATA_POPULATION

Company Defined

0

Name

POPULATE DUP SEARCH DATA

Default Value

0

Description

Defines whether to bring the duplicate search data from the DUP_SEARCH_DATA table and the USER_DUP_SEARCH_RESULT table into the data mart.
0 — Do not bring the duplicate search data into the data mart

1 — Bring the duplicate search data into the data mart

2.8 ESM_CLOB_DATA_POPULATION

Section

SYSTEM

Key

ESM_CLOB_DATA_POPULATION

Company Defined

1

Name

POPULATE INTERCHANGE CLOB DATA

Default Value

0

Description

Defines whether to bring the Interchange CLOB data into the data mart.
0 — Do not bring the Interchange CLOB data into the data mart

1 — Bring the Interchange CLOB data into the data mart

2.9 ETL_COMPUTE_BALANCING

Section

SYSTEM

Key

ETL_COMPUTE_BALANCING

Company Defined

0

Name

ETL_COMPUTE_BALANCING

Default Value

0

Description

DO NOT USE. For Oracle future purpose and reference.
Computes the balancing after every Incremental ETL.

2.10 ETL_ENTERPRISE_PROGRESS

Section

SYSTEM

Key

ETL_ENTERPRISE_PROGRESS

Company Defined

0

Name

ETL_ENTERPRISE_PROGRESS

Default Value

0/0

Description

DO NOT USE. For Oracle internal use only.
Drops the indexes in the first enterprise and recreates the indexes in the last enterprise.

2.11 FORCE_SECURE_COOKIES

Section

SYSTEM

Key

FORCE_SECURE_COOKIES

Company Defined

1

Name

FORCE SECURE COOKIES

Default Value

0

Description

Defines whether the user must enter a SSL-enabled URL (HTTPS) to open the Argus Insight application.
0 — Users can use either HTTP or HTTPS to open the Argus Insight application

1 — Users must use HTTPS (an SSL_enabled URL) to open the Argus Insight application

2.12 INSIGHT_HELP_URL

Section

SYSTEM

Key

INSIGHT_HELP_URL

Company Defined

1

Name

INSIGHT_HELP_URL

Default Value

http://docs.oracle.com/health-sciences/argus-insight-811/index.html

Description

Specifies Argus Insight Help URL.
This must be a valid URL otherwise a 404 - Page Not Found error will be displayed to the user.

2.13 IS_CFG_CUST_WKF_STATES_UPDATED

Section

SYSTEM

Key

IS_CFG_CUST_WKF_STATES_UPDATED

Company Defined

0

Name

IS CFG_CUST_WKF_STATES UPDATED

Default Value

1

Description

Specifies whether the configuration for the COMP_DATA_ENTRY column and the COMP_HQ column in the CFG_CUST_WORKFLOW_STATES table has changed.
0 — The configuration has not changed

1 — The configuration has changed

Argus Insight uses the value of this switch to determine whether to populate the RPT_WORKFLOW.INCLUDE_ROW_IN_REPORT column.

2.14 LEGACY_REPORTS_CONFIGURATION

Section

SYSTEM

Key

LEGACY_REPORTS_CONFIGURATION

Company Defined

1

Name

LEGACY REPORTS CONFIGURATION

Default Value

0

Description

Sets the flag to determine if the Legacy Report Configuration profile items are visible or not.
0 — The configuration profile items are not visible

1 — The configuration profile items are visible

2.15 MAXIMUM_EMAIL_ATTEMPTS

Section

SYSTEM

Key

MAXIMUM_EMAIL_ATTEMPTS

Company Defined

1

Name

MAXIMUM EMAIL ATTEMPTS

Default Value

3

Description

Defines the maximum number of times the system attempts to send an email.
0 — No limit

2.16 POST_INCREMENTAL_ETL_TASK

Section

SYSTEM

Key

POST_INCREMENTAL_ETL_TASK

Company Defined

1

Name

CUSTOM ROUTINE AFTER INCREMENTAL ETL

Default Value

—

Description

Defines the full path of the custom routine (Oracle stored procedure) to be executed after Incremental ETL. If the routine fails or is not found, the administrator receives an email notification.

2.17 PRE_INCREMENTAL_ETL_TASK

Section

SYSTEM

Key

PRE_INCREMENTAL_ETL_TASK

Company Defined

1

Name

CUSTOM ROUTINE BEFORE INCREMENTAL ETL

Default Value

—

Description

Defines the full path of the custom routine (Oracle stored procedure) to be executed before Incremental ETL. If this routine fails or is not found, then the ETL does not run and the administrator receives an email notification.

2.18 REPORT_DATA_POPULATION

Section

SYSTEM

Key

REPORT_DATA_POPULATION

Company Defined

0

Name

POPULATE REPORT TEMP DATA

Default Value

0

Description

DO NOT USE. For Oracle internal use only.
0 — Do not bring the report temporary data into the data mart

1 — Bring all report temporary data into the data mart. Includes all data from the following tables: RPT_PDF, RPT_PRINT_LOG, RPT_SAVED_MSG, RPT_TRANSMIT_EMAIL, RPT_TRANSMIT_EMAIL_ATTACH, RPT_TRANSMIT_LOG, and RPT_TRANSMIT_QUEUE.

2.19 SINGLE_SIGN_ON_ENABLED

Section

SYSTEM

Key

SINGLE_SIGN_ON_ENABLED

Company Defined

0

Name

SINGLE SIGN ON ENABLED

Default Value

0

Description

Defines whether Single Sign-On is enabled.
0 — Single Sign-On is disabled

1 — Single Sign-On is enabled

2.20 SINGLE_SIGN_ON_HTTP_HEADER

Section

SYSTEM

Key

SINGLE_SIGN_ON_HTTP_HEADER

Company Defined

0

Name

SINGLE SIGN ON HTTP HEADER

Default Value

––

Description

Configures the Single Sign-On in the HTTP header. Argus Insight populates this text value with information from Argus Safety.

2.21 TEMP_TABLE_DATA_POPULATION

Section

SYSTEM

Key

TEMP_TABLE_DATA_POPULATION

Company Defined

0

Name

POPULATE TEMP TABLE DATA

Default Value

0

Description

DO NOT USE. For Oracle internal use only.
Defines whether to bring data from the temporary tables into the data mart.

0 — Do not bring any data from the temporary tables into the data mart

1 — Bring all data from the temporary tables into the data mart. Includes all data from the following tables:

- CFG_BATCH_REPORT_CASES
CFG_PDP_QUEUE_DESC
CFG_SITE_PRINTERS
CFG_SMTP
CFG_SYSTEM_RESOURCE_USAGE
CFG_USER_ASYNC_TASKS

- CMN_ERROR_LOG
CMN_HELP_TEXT
CMN_PRINT_QUEUE
CMN_RAW
CMN_REC_CHK_OUT
CMN_SEQUENCE_UTL
CMN_STATUS
CMN_TRIGGER_TMP_QUEUE
CMN_USER_LOGIN
CMN_VARCHAR2

- ESM Schema: (ERROR_LOG)

- IF_LM_ACTIONS

- PDP_* tables (all tables prefixed with PDP_)

- TEMP_NO_AGENCY_ID

- USER_* tables (all tables prefixed with USER_)

- WEB_* tables (all tables prefixed with WEB_)

3 DATABASE Profile Global Switches

This chapter lists the DATABASE profile global switches for Argus Insight.

For information about the profile global switches you can use to change settings for your system or for your related application (Argus Safety), see Chapter 2, "SYSTEM Profile Global Switches" and Chapter 4, "Profile Global Switches for Related Applications," respectively.

3.1 Key 1

Section

DATABASE

Key

1

Company Defined

0

Name

ETL_SUNDAY

Default Value

0

Description

Argus Insight uses this record to determine whether Extract Transform and Load (ETL) will execute on Sunday.

3.2 Key 2

Section

DATABASE

Key

2

Company Defined

0

Name

ETL_MONDAY

Default Value

0

Description

Argus Insight uses this record to determine whether ETL will execute on Monday.

3.3 Key 3

Section

DATABASE

Key

3

Company Defined

0

Name

ETL_TUESDAY

Default Value

0

Description

Argus Insight uses this record to determine whether ETL will execute on Tuesday.

3.4 Key 4

Section

DATABASE

Key

4

Company Defined

0

Name

ETL_WEDNESDAY

Default Value

0

Description

Argus Insight uses this record to determine whether ETL will execute on Wednesday.

3.5 Key 5

Section

DATABASE

Key

5

Company Defined

0

Name

ETL_THURSDAY

Default Value

0

Description

Argus Insight uses this record to determine whether ETL will execute on Thursday.

3.6 Key 6

Section

DATABASE

Key

6

Company Defined

0

Name

ETL_FRIDAY

Default Value

0

Description

Argus Insight uses this record to determine whether ETL will execute on Friday.

3.7 Key 7

Section

DATABASE

Key

7

Company Defined

0

Name

ETL_SATURDAY

Default Value

0

Description

Argus Insight uses this record to determine whether ETL will execute on Saturday.

3.8 Key 8

Section

DATABASE

Key

8

Company Defined

0

Name

ETL_TIME

Default Value

12:00:00 AM

Description

Defines the ETL execution time.

3.9 Key 9

Section

DATABASE

Key

9

Company Defined

0

Name

ETL_EXECUTE_IMMEDIATE

Default Value

0

Description

This key is obsolete.

3.10 ACCESS

Section

DATABASE

Key

ACCESS

Company Defined

0

Name

ACCESS

Default Value

COMMON

Description

DO NOT USE. For Oracle internal use only.

3.11 APP_OWNER

Section

DATABASE

Key

APP_OWNER

Company Defined

0

Name

APP OWNER

Default Value

APR_APP

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle application schema name for Argus Insight.

3.12 APP_OWNER_PASSWORD

Section

DATABASE

Key

APP_OWNER_PASSWORD

Company Defined

0

Name

APP OWNER PASSWORD

Default Value

—

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle application schema password for Argus Insight.

3.13 APP_ROLE

Section

DATABASE

Key

APP_ROLE

Company Defined

0

Name

APP ROLE

Default Value

APR_APP_ROLE

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle application role name for Argus Insight.

3.14 APPLICATION_TYPE

Section

DATABASE

Key

APPLICATION_TYPE

Company Defined

0

Name

APPLICATION TYPE

Default Value

1

Description

DO NOT USE. For Oracle internal use only.
Defines the type of installation for Argus Insight.

0 — Single tenant installation

1 — Multi-tenant installation

3.15 COMMIT_AFTER_ROWS

Section

DATABASE

Key

COMMIT_AFTER_ROWS

Company Defined

0

Name

ETL - COMMIT_AFTER_ROWS

Default Value

10000

Description

Sets the number of cases that the Incremental ETL processes before committing the data to the database.

3.16 COMMIT_EVERY_TABLE

Section

DATABASE

Key

COMMIT_EVERY_TABLE

Company Defined

0

Name

ETL - COMMIT_EVERY_TABLE

Default Value

FALSE

Description

Sets the configuration flag for Incremental ETL execution to perform an Oracle commit after processing one table.
TRUE — Incremental ETL commits data after every table.

FALSE — Incremental ETL does not commit data after every table. Instead, Incremental ETL commits the data only after the end of the mart processing.

3.17 COMMON_USER

Section

DATABASE

Key

COMMON_USER

Company Defined

0

Name

COMMON USER

Default Value

APR_LOGIN

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle login schema name for Argus Insight.

3.18 DDL_VER

Section

DATABASE

Key

DDL_VER

Company Defined

0

Name

DDL_VER

Default Value

8.1.1

Description

Specifies the current database version for Argus Insight.

3.19 DDL_VER_INITIAL

Section

DATABASE

Key

DDL_VER_INITIAL

Company Defined

0

Name

DDL_VER_INITIAL

Description

Specifies the initial version of the schema creation for Argus Insight.

3.20 DEFAULT_SECURITY_ACCESS

Section

DATABASE

Key

DEFAULT_SECURITY_ACCESS

Company Defined

0

Name

DEFAULT_SECURITY_ACCESS

Default Value

0

Description

DO NOT USE. For Oracle internal use only.
Defines the default security access to Argus data (site, study, and product) for all Argus Insight users.

0 — Full access

8 — No access

3.21 ETL_COMPUTE_MART_USER_STATISTICS

Section

DATABASE

Key

ETL_COMPUTE_MART_USER_STATISTICS

Company Defined

0

Name

ETL_MART_USER_STATISTICS

Default Value

1

Description

Defines how ETL should compute statistics for the mart user.
0 — Disabled (no statistics computed)

1 — Use the Oracle DBMS_STATS method to compute the statistics. DBMS_STATS is the preferred method for computing statistics.

2 — Use the Oracle ANALYZE method to compute the statistics.

3.22 ETL_COMPUTE_STAGE_USER_STATISTICS

Section

DATABASE

Key

ETL_COMPUTE_STAGE_USER_STATISTICS

Company Defined

0

Name

ETL_STAGE_USER_STATISTICS

Default Value

1

Description

Defines how ETL should compute statistics for the stage user.
0 — Disabled (no statistics computed)

1 — Use the Oracle DBMS_STATS method to compute the statistics. DBMS_STATS is the preferred method for computing statistics.

2 — Use the Oracle ANALYZE method to compute the statistics.

3.23 ETL_EMAIL_RECEIVER_ADDRESS

Section

DATABASE

Key

ETL_EMAIL_RECEIVER_ADDRESS

Company Defined

1

Name

ETL EMAIL RECEIVER ADDRESS

Default Value

—

Description

Defines the email address of each administrator who will receive email status messages of the ETL process. Use a semi-colon to separate each entry. If you leave the value blank, then Argus Insight sends no email messages.

3.24 ETL_EMAIL_SETUP

Section

DATABASE

Key

ETL_EMAIL_SETUP

Company Defined

1

Name

ETL EMAIL SETUP

Default Value

0

Description

Defines whether to send an email after ETL is run and under what circumstances to send the email.
0 — Do not send an email after any ETL process

1 — Send an email only when an Initial ETL or an Incremental ETL fails

2 — Send an email only when an Initial ETL or an Incremental ETL succeeds

3 — Send an email after every Initial ETL or Incremental ETL regardless of whether the process succeeds or fails

3.25 ETL_STATS_CASCADE_OPTION

Section

DATABASE

Key

ETL_STATS_CASCADE_OPTION

Company Defined

0

Name

ETL STATS CASCADE OPTION

Default Value

TRUE

Description

Specifies (TRUE or FALSE) whether to use the Oracle Cascade option for computing statistics for the mart user.

3.26 ETL_STATS_ESTIMATE_PERCENT

Section

DATABASE

Key

ETL_STATS_ESTIMATE_PERCENT

Company Defined

0

Name

ETL STATS ESTIMATE PERCENT

Default Value

1

Description

Sets the estimate percentage for computing statistics for the mart user.

3.27 ETL_STATS_METHOD_OPT

Section

DATABASE

Key

ETL_STATS_METHOD_OPT

Company Defined

0

Name

ETL STATS METHOD OPT

Default Value

FOR ALL COLUMNS SIZE AUTO

Description

Defines the METHOD_OPT parameter for the Oracle DBMS_STATS method used when computing ETL schema statistics.

3.28 ETL_STATS_PARALLEL_DEGREE

Section

DATABASE

Key

ETL_STATS_PARALLEL_DEGREE

Company Defined

0

Name

PARALLEL DEGREE IN DBMS_STATS

Default Value

—

Description

Defines the DEGREE parameter for the Oracle DBMS_STATS method used when computing ETL schema statistics.

3.29 ETL_STATUS

Section

DATABASE

Key

ETL_STATUS

Company Defined

0

Name

ETL_STATUS

Default Value

0

Description

Provides the status of the current ETL.
-1 — Initial ETL started

1 — Initial ETL completed

-2 — Incremental ETL started

2 — Incremental ETL completed

3.30 INCR_ETL_PRE_REQ_STATUS

Section

DATABASE

Key

INCR_ETL_PRE_REQ_STATUS

Company Defined

0

Name

INCR_ETL_PRE_REQ_STATUS

Default Value

—

Description

DO NOT USE. For Oracle internal use only.

3.31 INCR_ETL_STEP

Section

DATABASE

Key

INCR_ETL_STEP

Company Defined

0

Name

INCR_ETL_STEP

Default Value

0

Description

DO NOT USE. For Oracle internal use only.

3.32 INCREMENTAL_ETL_STATUS

Section

DATABASE

Key

INCREMENTAL_ETL_STATUS

Company Defined

0

Name

INCREMENTAL_ETL_STATUS

Default Value

0

Description

Provides status information about the Incremental ETL.
0 — Indicates either the Incremental ETL has not started or the pre-incremental tasks are in process

1 — Indicates the pre-incremental tasks have completed

3.33 INITIAL_ETL_PRE_REQ_STATUS

Section

DATABASE

Key

INITIAL_ETL_PRE_REQ_STATUS

Company Defined

0

Name

INITIAL ETL PRE REQ STATUS

Default Value

—

Description

DO NOT USE. For Oracle internal use only.
Provides information about the Initial ETL process.

1 — No errors

2 — Ignore errors and proceed

3 — Abort ETL

3.34 LAST_ETL_START_DATETIME

Section

DATABASE

Key

LAST_ETL_START_DATETIME

Company Defined

0

Name

LAST ETL START TIME

Default Value

—

Description

Contains the date and time that the last ETL started.

3.35 LOGIN_OWNER

Section

DATABASE

Key

LOGIN_OWNER

Company Defined

0

Name

LOGIN OWNER

Default Value

APP_USER

Description

DO NOT USE. For Oracle internal use only.
Specifies the Oracle APR APP schema name for Argus Insight.

3.36 MART_HIST_OWNER

Section

DATABASE

Key

MART_HIST_OWNER

Company Defined

0

Name

MART HISTORY OWNER

Default Value

APR_HIST

Description

DO NOT USE. For Oracle internal use only.
Specifies the Oracle history schema name for Argus Insight.

3.37 MART_OWNER

Section

DATABASE

Key

MART_OWNER

Company Defined

0

Name

MART OWNER

Default Value

APR_MART

Description

DO NOT USE. For Oracle internal use only.
Oracle MART schema name for Argus Insight.

3.38 MEMORY_MODEL

Section

DATABASE

Key

MEMORY_MODEL

Company Defined

0

Name

MEMORY MODEL

Default Value

0

Description

DO NOT USE. For Oracle internal use only.
Stores the memory model used to create schema. The Schema Creation Tool sets this value based on user selection.

0 — Default (Oracle internal use only.)

1 — Small

2 — Medium

3 — Large

3.39 PRE_REQ_CHECK_FLAG

Section

DATABASE

Key

PRE_REQ_CHECK_FLAG

Company Defined

1

Name

ETL DATA EXCLUSION

Default Value

IGNORE

Description

Specifies whether to continue or cancel the ETL process if cases with erroneous data are found.
IGNORE — Continue the ETL but skip cases with erroneous data.

ABORT — Cancel the ETL if any cases with erroneous data are found.

3.40 READ_ONLY_OWNER

Section

DATABASE

Key

READ_ONLY_OWNER

Company Defined

0

Name

READ ONLY OWNER

Default Value

APR_LINK_USER

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle read-only schema name for Argus Insight.

3.41 READ_ONLY_ROLE

Section

DATABASE

Key

READ_ONLY_ROLE

Company Defined

0

Name

READ ONLY ROLE

Default Value

APR_LINK_ROLE

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle read-only role name for Argus Insight.

3.42 RLS_OWNER

Section

DATABASE

Key

RLS_OWNER

Company Defined

0

Name

RLS OWNER

Default Value

APR_RLS

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle Virtual Private Database (VPD) schema name for Argus Insight.

3.43 ROLE_NAME

Section

DATABASE

Key

ROLE_NAME

Company Defined

0

Name

ROLE NAME

Default Value

APR_ROLE

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle role name for Argus Insight.

3.44 RUN_INCR_ETL_EVERY_TIME

Section

DATABASE

Key

RUN_INCR_ETL_EVERY_TIME

Company Defined

0

Name

RUN INCR ETL EVERY TIME

Default Value

1

Description

Defines whether to run Incremental ETL only if data has changed.
0 — Only run Incremental ETL if the case data, report data, or LAM data has changed

1 — Always run Incremental ETL regardless of whether there are any changes to the case data, report data, or LAM data

3.45 SAFETY_DDL_VER

Section

DATABASE

Key

SAFETY_DDL_VER

Company Defined

0

Name

ARGUS SAFETY VERSION

Default Value

SELECT VALUE FROM cmn_profile@db_link_argus
WHERE KEY = 'DDL_VER' AND section = 'DATABASE'

Description

Specifies the current version of Argus Safety.

3.46 STAGE_OWNER

Section

DATABASE

Key

STAGE_OWNER

Company Defined

0

Name

STAGE OWNER

Default Value

APR_STAGE

Description

DO NOT USE. For Oracle internal use only.
Defines the Oracle STAGE schema name for Argus Insight.

3.47 VERY_FIRST_INITIAL_ETL_COMPLETE

Section

DATABASE

Key

VERY_FIRST_INITIAL_ETL_COMPLETE

Company Defined

0

Name

VERY FIRST INITIAL ETL COMPLETE

Default Value

0

Description

Indicates whether the first Initial ETL for Argus Insight has completed.
0 — No

1 — Yes

3.48 LOG_REPORT_SQL

Section

DATABASE

Key

LOG_REPORT_SQL

Company Defined

0

Name

LOG REPORT SQL

Default Value

0

Description

Identifies if the report SQL is to be logged or not.
0 — No

1 — Yes

4 Profile Global Switches for Related Applications

This chapter lists the profile global switches to configure the settings for the Argus Safety application that you are using with Argus Insight..

This chapter groups the switches as follows and lists the switches within each section in alphabetic order:

- Section 4.1, "Profile Global Switches Specific to Argus Safety"

For information about the profile global switches you can use to change settings for your system or for your database, see Chapter 2, "SYSTEM Profile Global Switches" and Chapter 3, "DATABASE Profile Global Switches," respectively.

4.1 Profile Global Switches Specific to Argus Safety

This section provides information about the profile global switches specific to configuring Argus Safety for use with Argus Insight. The switches are listed in alphabetic order.

4.1.1 CURRENT_CASE_COPY

Section

ARGUS

Key

CURRENT_CASE_COPY

Company Defined

0

Name

CURRENT_CASE_COPY

Default Value

—

Description

Specifies the start date and time of the current ETL process.

4.1.2 CURRENT_CASE_COPY

Section

ARGUS

Key

DATABASE_TIMEZONE

Company Defined

0

Name

DATABASE_TIMEZONE

Default Value

—

Description

Specifies Argus Safety database timezone.

4.1.3 GMT_OFFSET

Section

ARGUS

Key

GMT_OFFSET

Company Defined

0

Name

GMT OFFSET

Default Value

—

Description

Specifies the Greenwich Mean Time (GMT) offset for the date and time of the last successful ETL process.

4.1.4 LAST_CASE_COPY

Section

ARGUS

Key

LAST_CASE_COPY

Company Defined

0

Name

LAST_CASE_COPY

Default Value

—

Description

Specifies the start date and time of the last successfully completed ETL process.

4.1.5 PREVIOUS_TO_LAST_CASE_COPY

Section

ARGUS

Key

PREVIOUS_TO_LAST_CASE_COPY

Company Defined

0

Name

PREVIOUS TO LAST CASE COPY

Default Value

—

Description

Specifies the start date and time of the next-to-last successfully completed ETL process.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.