Skip Headers
Oracle® Warehouse Builder API and Scripting Reference
11g Release 2 (11.2)

E10584-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 Public Views for the Runtime Environment

The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. These views are called the Warehouse Builder public views and are the API alternative to using the Repository Browser described in the Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.

Use these views to access to metadata and data stored in Warehouse Builder repositories.

You can access public views by logging in to SQL*Plus with default workspace@set. When you login to SQL*Plus, you can access public views (design-time public views or runtime public views) from your default workspace.If you try to access public views from any workspace other than the default, then you must call: WB_workspace_management.set_workspace(<wksp_name>, <wksp_owner>). If you want to switch to a workspace other than the default one, then you can call the WB_workspace_management.set_workspace procedure. You must have the ACCESS_PUBLICVIEW_BROWSER system privilege to retrieve useful information from the public views. Otherwise, you will get "0 rows returned." You may need to ask the workspace owner or workspace admin to grant the system privilege ACCESS_PUBLICVIEW_BROWSER.

This chapter contains a catalog of the public views for the runtime environment.

Deployment Auditing Views

Table 1-1 ALL_RT_AUDIT_LOCATIONS

Column Name Data Type Description

LOCATION_AUDIT_ID

NUMBER (22)

Internal primary key to audit_location

RUNTIME_VERSION

VARCHAR2 (64)

Runtime version number

CLIENT_VERSION

VARCHAR2 (64)

Design client version number

CLIENT_REPOSITORY

VARCHAR2 (30)

Name of the client repository

CLIENT_REPOSITORY_VERSION

VARCHAR2 (64)

Client repository version number

REPOSITORY_USER

VARCHAR2 (30)

Username of the design repository

GENERATION_TIME

DATE

When the deployment was generated

DEPLOYMENT_AUDIT_ID

NUMBER (22)

Internal audit ID of the deployment

DEPLOYMENT_SEQUENCE_NUMBER

NUMBER (10)

Sequence number of this location in the deployment

DEPLOYMENT_AUDIT_NAME

VARCHAR2 (64)

Audit name of the location

DEPLOYMENT_AUDIT_STATUS

VARCHAR2 (4000)

INACTIVE, READY, or COMPLETE

LOCATION_AUDIT_STATUS

VARCHAR2 (4000)

INACTIVE, READY, BUSY_PREPARE, BUSY_UNPREPARE, BUSY_DEPLOY, BUSY_UNDO, BUSY_FINALIZE, or COMPLETE

LOCATION_UOID

VARCHAR2 (32)

Client UOID of the location

LOCATION_NAME

VARCHAR2 (64)

Name of the location

LOCATION_TYPE

VARCHAR2 (64)

Type of the location. (ODB, OWF, OEM)

LOCATION_TYPE_VERSION

VARCHAR2 (64)

Version of the target

NUMBER_SCRIPT_RUN_ERRORS

NUMBER (10)

Number of errors detected

NUMBER_SCRIPT_RUN_WARNINGS

NUMBER (10)

Number of warnings detected

CREATED_ON

DATE

The time audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATED_ON

DATE

The time audit data was updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-2 ALL_RT_AUDIT_LOCATION_MESSAGES

Column Name Data Type Description

MESSAGE_AUDIT_ID

NUMBER (22)

Internal key to audit_location_message. Primary when used with message_line_number.

LOCATION_AUDIT_ID

NUMBER (22)

Internal key to audit_location

MESSAGE_SEVERITY

VARCHAR2 (4000)

INFORMATIONAL, WARNING, ERROR, or RECOVERY

MESSAGE_LINE_NUMBER

NUMBER (10)

1 for single line messages

>0 for multiple line messages

(Forms primary key when used with message_audit_id)

MESSAGE_TEXT

VARCHAR2 (4000)

plain_text or nls_key

CREATED_ON

DATE

The time audit data was created

CREATED_BY

VARCHAR2 (30)

Database username


Table 1-3 ALL_RT_AUDIT_LOCATION_FILES

Column Name Data Type Description

FILE_AUDIT_ID

NUMBER (22)

Internal primary key to audit_location_file

LOCATION_AUDIT_ID

NUMBER (22)

Internal key to audit_location

FILE_TYPE

VARCHAR2 (64)

SQLLoaderLogFile, ShellOutputStream, ShellErrorStream, FTPOutputStream, or FTPErrorStream

FILE_TEXT

CLOB

Contents of the file

FORMAT

VARCHAR2(4000)

TEXT or HTML

CREATED_ON

DATE

The time audit data was created

CREATED_BY

VARCHAR2 (30)

Database username


Table 1-4 ALL_RT_AUDIT_OBJECTS

Column Name Data Type Description

OBJECT_AUDIT_ID

NUMBER (22)

Internal primary key to audit_object

PARENT_OBJECT_AUDIT_ID

NUMBER (22)

Internal key to parent audit_script_run

LOCATION_AUDIT_ID

NUMBER (22)

Internal key to audit_location

LOCATION_SEQUENCE_NUMBER

NUMBER (10)

Sequence number of this object in the location

OBJECT_UOID

VARCHAR2 (32)

UOID of the deployed object

OBJECT_NAME

VARCHAR2 (64)

Name of the deployed object

OBJECT_TYPE

VARCHAR2 (64)

Type of deployed object. (PLSQLMap, Table, Dimension, SQLLoaderControlFile)

CLIENT_VERSION_TAG

VARCHAR2 (80)

Client version identifier of this object

NUMBER_SCRIPT_RUN_ERRORS

NUMBER (10)

Number of errors detected

NUMBER_SCRIPT_RUN_WARNINGS

NUMBER (10)

Number of warnings detected

STATUS_WHEN_DEPLOYED

VARCHAR2 (4000)

VALID, INVALID, REMOVED, or UNCERTAIN

CREATED_ON

DATE

The time audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATE_ON

DATE

The time audit data was updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-5 ALL_RT_AUDIT_SCRIPT_MESSAGES

Column Name Data Type Description

MESSAGE_AUDIT_ID

NUMBER (22)

Internal primary key to audit_script_file

SCRIPT_RUN_AUDIT_ID

NUMBER (22)

Internal key to audit_script_run

MESSAGE_SEVERITY

VARCHAR2 (4000)

INFORMATIONAL, WARNING, ERROR, or RECOVERY

MESSAGE_LINE_NUMBER

NUMBER (10)

1 for single line messages

>0 for multiple line messages

(Forms primary key when used with message_audit_id)

MESSAGE_TEXT

VARCHAR2 (4000)

plain_text or nls_key

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username


Table 1-6 ALL_RT_AUDIT_SCRIPT_RUNS

Column Name Data Type Description

SCRIPT_RUN_AUDIT_ID

NUMBER (22)

Internal primary key to audit_script_run

LOCATION_AUDIT_ID

NUMBER (22)

Internal key to audit_location

OBJECT_AUDIT_ID

NUMBER (22)

Internal key to audit_object

SCRIPT_RUN_AUDIT_STATUS

VARCHAR2 (4000)

BUSY, COMPLETE, UNCERTAIN, FAILED or INACTIVE

OPERATION

VARCHAR2 (4000)

DEPLOY, or UNDO

SCRIPT_ACTION

VARCHAR2 (4000)

CREATE, DROP, UPGRADE, or REPORT

SCRIPT

CLOB

Script used to perform the action

SCRIPT_FORMAT

VARCHAR2 (4000)

TEXT or HTML

SCRIPT_GENERATION_TIME

DATE

The time the script was created

NUMBER_SCRIPT_RUN_ERRORS

NUMBER

The number of errors detected

NUMBER_SCRIPT_RUN_WARNINGS

NUMBER

The number of warnings detected

ELAPSE_TIME

NUMBER (10)

The number of seconds that elapsed

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATED_ON

DATE

The time the audit data updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-7 ALL_RT_AUDIT_SCRIPT_FILES

Column Name Data Type Description

FILE_AUDIT_ID

NUMBER (22)

Internal primary key to audit_script_file

SCRIPT_RUN_AUDIT_ID

NUMBER (22)

Internal key to audit_script_run

FILE_TYPE

VARCHAR2 (64)

SQLLoaderLogFile, ShellOutputStream, ShellErrorStream, FTPOutputStream, or FTPErrorStream

FILE_TEXT

CLOB

Contents of the file

FORMAT

VARCHAR2 (4000)

TEXT or HTML

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username


Table 1-8 ALL_RT_AUDIT_DEPLOYMENTS

Column Name Data Type Description

DEPLOYMENT_AUDIT_ID

NUMBER(22)

ID of the deployment audit

DEPLOYMENT_AUDIT_NAME

VARCHAR2(64)

Name of the deployment audit

NUMBER_OF_UNITS

NUMBER(10)

Number of units

RUNTIME_VERSION

VARCHAR2(64)

Version of the control center

CLIENT_VERSION

VARCHAR2(64)

Version of the Warehouse Builder client

CLIENT_REPOSITORY

VARCHAR2(30)

Name of client repository

CLIENT_REPOSITORY_VERSION

VARCHAR2(64)

Version of the client repository

REPOSITORY_USER

VARCHAR2(30)

Name of the repository user

GENERATION_TIME

DATE

Timestamp of the object generation

DEPLOYMENT_AUDIT_STATUS

VARCHAR2(4000)

Status of the deployment

NUMBER_SCRIPT_RUN_ERRORS

NUMBER(10)

Number of errors running the scripts within the deployment

NUMBER_SCRIPT_RUN_WARNINGS

NUMBER(10)

Number of warnings while running the scripts within the deployment

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 1-9 ALL_RT_INSTALLATIONS

Column Name Data Type Description

INSTALLATION_ID

VARCHAR2

ID of the installation

INSTALLATION_NAME

CHAR

Name of the installation

DESCRIPTION

CHAR

Description of the installation

INSTALLED_VERSION

VARCHAR2(4000)

Version of the repository that is installed

RELEASE

VARCHAR2

Release number of Warehouse Builder

PUBLIC_VIEW_VERSION

CHAR(4)

Version of the PublicViews implemented by this installation

SCHEMA_TYPE

VARCHAR2(24)

Type of schema

UPDATED_ON

VARCHAR2

Update timestamp

CREATED_ON

VARCHAR2

Creation timestamp


Table 1-10 ALL_RT_LOCATIONS

Column Name Data Type Description

LOCATION_NAME

VARCHAR2(64)

Name of the location

LOCATION_UOID

VARCHAR2(32)

UOID of the location

IS_DEPLOYMENT_TARGET

VARCHAR2(5)

Indicates whether this location is a deployment target

LOCATION_TYPE

VARCHAR2(64)

Type of the source or target with which the location is associated

LOCATION_TYPE_VERSION

VARCHAR2(64)

Version of the source or target


Table 1-11 ALL_RT_LOCATION_PARAMETERS

Column Name Data Type Description

LOCATION_NAME

VARCHAR2(64)

Name of the location

PARAMETER_NAME

VARCHAR2(64)

Name of the parameter

IS_ACCESS_RESTRICTED

VARCHAR2(5)

Indicates whether the parameter-value has a restricted value, such as for a password.

PARAMETER_VALUE

VARCHAR2(4000)

The value of a non-access restricted parameter


Table 1-12 ALL_RT_OBJECTS

Column Name Data Type Description

OBJECT_NAME

VARCHAR2(64)

Name of the object

OBJECT_TYPE

VARCHAR2(64)

Type of the object

PARENT_OBJECT_NAME

VARCHAR2(64)

Name of the parent object

PARENT_OBJECT_TYPE

VARCHAR2(64)

Type of the parent object

LOCATION_NAME

VARCHAR2(64)

Name of the location to which this object is deployed

OBJECT_UOID

VARCHAR2(32)

UOID of the object

VERSION_TAG

VARCHAR2(80)

Version string used by Control Center Manager

LAST_DEPLOYMENT_SCRIPT

CLOB

Script that was used during this objects last deployment

STATUS_WHEN_LAST_DEPLOYED

VARCHAR2(4000)

Object status after its last deployment

SUB_OBJECTS_VALID

VARCHAR2(5)

Indicates whether the subobjects of an object were valid at last deployment

RELATED_OBJECTS_VALID

VARCHAR2(5)

Indicates whether the related objects of an object were valid at last deployment

DEPLOYMENT_DATE

DATE

Date the object was deployed

DEPLOYED_BY

VARCHAR2(30)

User who deployed the object


Table 1-13 ALL_RT_TASKS

Column Name Data Type Description

CONTEXT_OBJECT_NAME

VARCHAR2(64)

Name of the tasks context

CONTEXT_OBJECT_TYPE

VARCHAR2(64)

Type of the tasks context

CONTEXT_LOCATION_NAME

VARCHAR2(64)

Name of the location where the context was deployed to

EXEC_LOCATION_NAME

VARCHAR2(64)

Name of the location where the task will be executed

TASK_NAME

VARCHAR2(64)

Name of the task

TASK_TYPE

VARCHAR2(64)

Type of the task

TASK_INPUT

CLOB

Script that implements the task

OBJECT_NAME

VARCHAR2(64)

Name of the object

OBJECT_TYPE

VARCHAR2(64)

Type of the object

OBJECT_LOCATION_NAME

VARCHAR2(64)

Location to which the object is deployed


Table 1-14 ALL_RT_TASK_PARAMETERS

Column Name Data Type Description

CONTEXT_OBJECT_NAME

VARCHAR2(64)

Name of the tasks context

CONTEXT_OBJECT_TYPE

VARCHAR2(64)

Type of the tasks context

CONTEXT_LOCATION_NAME

VARCHAR2(64)

Name of the location where the context was deployed to

EXEC_LOCATION_NAME

VARCHAR2(64)

Name of the location where the task will be executed

TASK_NAME

VARCHAR2(64)

Name of the task

PARAMETER_KIND

VARCHAR2(4000)

Kind of Parameter

CUSTOM_PARAMETER_UOID

VARCHAR2(32)

UOID of the parameter if it is a custom parameter

PARAMETER_NAME

VARCHAR2(64)

Name of the parameter

PARAMETER_TYPE

VARCHAR2(4000)

Type of the parameter

PARAMETER_MODE

VARCHAR2(4000)

Mode of the parameter (IN/OUT/INOUT/VARIABLE)

PARAMETER_SCOPE

VARCHAR2(4000)

Scope of the parameter (GLOBAL, SHARED, PARAMETER, LOCAL or INNER)

BOUND_TO_NAME

VARCHAR2(64)

Name of object that the parameter might be bound to

BOUND_TO_KIND

VARCHAR2(4000)

Kind of object that the parameter might be bound to

BOUND_TO_SCOPE

VARCHAR2(4000)

Scope of the object that the parameter might be bound to

IS_FIXED

VARCHAR2(5)

Is parameter value fixed

IS_REQUIRED

VARCHAR2(5)

Is parameter value required

TYPE_LENGTH

NUMBER(10)

Data type length of parameter

TYPE_SCALE

NUMBER(10)

Data type scale of parameter

TYPE_PRECISION

NUMBER(10)

Data type precision of parameter

DEFAULT_VALUE_KIND

NUMBER(8)

Integer indicating kind of value (Literal, Expression, Evaluated Expression, Not Set)

DEFAULT_VALUE

VARCHAR2(4000)

Default value for parameter


Execution Auditing Views

Table 1-15 ALL_RT_AUDIT_EXECUTIONS

Column Name Data Type Description

EXECUTION_AUDIT_ID

NUMBER (22)

Internal primary key to audit_execution

PARENT_EXECUTION_AUDIT_ID

NUMBER (22)

Internal key to parent audit_execution

TOP_LEVEL_EXECUTION_AUDIT_ID

NUMBER (22)

Internal key to top-level audit_execution

EXECUTION_NAME

VARCHAR2 (64)

Name of the execution run

TASK_NAME

VARCHAR2 (64)

Name of the task executed

TASK_TYPE

VARCHAR2 (64)

Type of task executed (PL/SQL, ProcessFlow).

TASK_INPUT

CLOB

Input stream for the task

EXEC_LOCATION_UOID

VARCHAR2 (32)

UOID of the location where execution is performed

EXEC_LOCATION_NAME

VARCHAR2 (64)

Name of the location where execution is performed

EXEC_LOCATION_TYPE

VARCHAR2 (64)

Type of the location where execution is performed. (Runtime Platform, OEM)

EXEC_LOCATION_TYPE_VERSION

VARCHAR2 (64)

Version of the location where execution is performed

OBJECT_UOID

VARCHAR2 (32)

Client UOID of mapping executed

OBJECT_NAME

VARCHAR2 (64)

Name of mapping executed

OBJECT_TYPE

VARCHAR2 (64)

Type of mapping executed

OBJECT_LOCATION_UOID

VARCHAR2 (32)

Location UOID where mapping deployed

OBJECT_LOCATION_NAME

VARCHAR2 (64)

Location name where mapping deployed

OBJECT_LOCATION_TYPE

VARCHAR2 (64)

Location type where mapping deployed

OBJECT_LOCATION_TYPE_VERSION

VARCHAR2 (64)

Location version where mapping deployed

RETURN_RESULT

VARCHAR2 (64)

FAILURE, OK, OK_WITH_WARNINGS, or OK_WITH_ERRORS

RETURN_CODE

NUMBER (10)

<0: Failure

>= 0: Success

EXECUTION_AUDIT_STATUS

VARCHAR2

INACTIVE, BUSY, READY, or COMPLETE

ELAPSE_TIME

NUMBER (10)

Number of seconds elapsed

NUMBER_TASK_ERRORS

NUMBER (10)

Number of errors detected

NUMBER_TASK_WARNINGS

NUMBER (10)

Number of warnings detected

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATED_ON

DATE

The time the audit data was updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-16 ALL_RT_AUDIT_EXECUTION_PARAMS

Column Name Data Type Description

PARAMETER_AUDIT_ID

NUMBER (22)

Internal primary key to audit_execution_param

EXECUTION_AUDIT_ID

NUMBER (22)

Internal key to audit_execution

CUSTOM_PARAMETER_UOID

VARCHAR2 (32)

UOID of custom parameter

PARAMETER_NAME

VARCHAR2 (64)

Name of parameter

PARAMETER_TYPE

VARCHAR2(4000)

BOOLEAN, CHAR, DATE, FLOAT, NUMBER, VARCHAR, VARCHAR2, OPERATING_MODE, or AUDIT_LEVEL

PARAMETER_KIND

VARCHAR2(4000)

SYSTEM or CUSTOM

PARAMETER_MODE

VARCHAR2(4000)

IN, OUT, or INOUT

VALUE_KIND

VARCHAR2 (12)

INPUT VALUE or OUTPUT VALUE

VALUE

VARCHAR2 (4000)

Character representation of parameter value


Table 1-17 ALL_RT_AUDIT_EXEC_MESSAGES

Column Name Data Type Description

MESSAGE_AUDIT_ID

NUMBER (22)

Internal key to audit_exec_message. Primary key when used with message_line_number

EXECUTION_AUDIT_ID

NUMBER (22)

Internal key to audit_execution

MESSAGE_SEVERITY

VARCHAR2

INFORMATIONAL, WARNING, ERROR, or RECOVERY

MESSAGE_LINE_NUMBER

NUMBER (10)

1 for single line messages

>0 for multiple line messages

(Forms primary key when used with message_audit_id))

MESSAGE_TEXT

VARCHAR2 (4000)

Plain_text or nls_key

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username


Table 1-18 ALL_RT_AUDIT_EXEC_FILES

Column Name Data Type Description

FILE_AUDIT_ID

NUMBER (22)

Internal primary key to audit_exec_file

EXECUTION_AUDIT_ID

NUMBER (22)

Internal key to audit_execution

FILE_TYPE

VARCHAR2 (64)

Type of the file

FILE_TEXT

CLOB

Content of the file

FORMAT

VARCHAR2

TEXT or HTML

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username


Table 1-19 ALL_RT_AUDIT_MAP_RUNS

Column Name Data Type Description

MAP_RUN_ID

NUMBER (22)

Internal primary key to audit_map_run

EXECUTION_AUDIT_ID

NUMBER (22)

Internal key to audit_execution

MAP_UOID

VARCHAR2 (255)

UOID of the mapping

MAP_NAME

VARCHAR2 (80)

Name of the mapping

MAP_TYPE

VARCHAR2 (30)

PLSQLMap or SQLLoaderControlFile

START_TIME

DATE

The time the mapping started

END_TIME

DATE

The time the mapping ended

ELAPSE_TIME

NUMBER (10)

Number of seconds elapsed

RUN_STATUS

VARCHAR2 (8)

RUNNING, FAILURE or COMPLETE

FAILURE: This status means that the mapping run was completed with errors.COMPLETE: This status means that the mapping run has been completed successfully.

However, when you specify a limit on the maximum number of errors that can be generated during the mapping run, if this limit is exceeded, the mapping run is stopped with the status COMPLETE.

PHYSICAL_NAME

VARCHAR2 (80)

Full hierarchic name of .dat file for a SQL*Loader run

LOAD_DATE

VARCHAR2 (30)

Load date for a SQL*Loader run

LOAD_TIME

VARCHAR2 (30)

Load time for a SQL*Loader run

NUMBER_ERRORS

NUMBER (10)

Number of errors detected

NUMBER_RECORDS_SELECTED

NUMBER (10)

Number of records selected from source tables

NUMBER_RECORDS_INSERTED

NUMBER (10)

Number of records inserted into target tables

NUMBER_RECORDS_UPDATED

NUMBER (10)

Number of records updated in target tables

NUMBER_RECORDS_DELETED

NUMBER (10)

Number of records deleted in target tables

NUMBER_RECORDS_DISCARDED

NUMBER (10)

Number of records discarded in SQL*Loader run

NUMBER_RECORDS_MERGED

NUMBER (10)

Number of records merged in target tables

NUMBER_RECORDS_CORRECTED

NUMBER (10)

Number of records corrected in target tables

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATED_ON

DATE

The time the audit data was updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-20 ALL_RT_AUDIT_MAP_RUN_SOURCES

Column Name Data Type Description

MAP_RUN_ID

NUMBER (22)

Internal key to audit_map_run

SOURCE_NAME

VARCHAR2 (2000)

Name of mapping operator representing source table

SOURCE_DBLINK

VARCHAR2 (2000)

Name of database link for mapping operator representing source table


Table 1-21 ALL_RT_AUDIT_MAP_RUN_TARGETS

Column Name Data Type Description

MAP_RUN_ID

NUMBER (22)

Internal key to audit_map_run

TARGET_NAME

VARCHAR2 (2000)

Name of mapping operator representing target table


Table 1-22 ALL_RT_AUDIT_STEP_RUNS

Column Name Data Type Description

STEP_ID

NUMBER (22)

Internal primary key to audit_step_run

MAP_RUN_ID

NUMBER (22)

Internal key to audit_map_run

MAP_STEP

NUMBER (22)

Step number 0 or 1

For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run

STEP_NAME

VARCHAR2 (80)

Name of the mapping for a set-based run, or the name of a mapping object for a set-based or set-based-target run

STEP_TYPE

VARCHAR2 (18)

Set-based, Row-based or Row-based target

START_TIME

DATE

The time the mapping step started

END_TIME

DATE

The time the mapping step ended

ELAPSE_TIME

NUMBER (10)

Number of seconds taken

RUN_STATUS

VARCHAR2 (8)

RUNNING or COMPLETE

NUMBER_ERRORS

NUMBER (10)

Number of errors detected

NUMBER_RECORDS_SELECTED

NUMBER (10)

Number of records selected from source tables

NUMBER_RECORDS_INSERTED

NUMBER (10)

Number of records inserted into target tables

NUMBER_RECORDS_UPDATED

NUMBER (10)

Number of records updated in target tables

NUMBER_RECORDS_DELETED

NUMBER (10)

Number of records deleted in target tables

NUMBER_RECORDS_DISCARDED

NUMBER (10)

Number of records discarded in a SQL*Loader run

NUMBER_RECORDS_MERGED

NUMBER (10)

Number of records merged in target tables

NUMBER_RECORDS_CORRECTED

NUMBER (10)

Number of records corrected in target tables

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATED_ON

DATE

The time the audit data was updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-23 ALL_RT_AUDIT_STEP_RUN_SOURCES

Column Name Data Type Description

STEP_ID

NUMBER (22)

Internal key to audit_step_run

MAP_RUN_ID

NUMBER (22)

Internal key to audit_map_run

MAP_STEP

NUMBER (22)

Step number 0 or 1

For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run

SOURCE_NAME

VARCHAR2 (2000)

Name of mapping operator representing source table

SOURCE_DBLINK

VARCHAR2 (2000)

Name of database link for mapping operator representing source table


Table 1-24 ALL_RT_AUDIT_STEP_RUN_TARGETS

Column Name Data Type Description

STEP_ID

NUMBER (22)

Internal key to audit_step_run

MAP_RUN_ID

NUMBER (22)

Internal key to audit_map_run

MAP_STEP

NUMBER (22)

Step number 0 or 1

For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run

TARGET_NAME

VARCHAR2 (2000)

Name of mapping operator representing target table


Table 1-25 ALL_RT_AUDIT_MAP_RUN_ERRORS

Column Name Data Type Description

RUN_ERROR_ID

NUMBER (22)

Internal primary key for map_run_error

STEP_ID

NUMBER (22)

Internal key to audit_step_run

MAP_RUN_ID

NUMBER (22)

Internal key to audit_map_run

MAP_STEP

NUMBER (22)

Step number 0 or 1

For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run.

CURSOR_ROWKEY

NUMBER (22)

Value identifying row returned by cursor. This is 0 for errors in a set-based run.

RUN_ERROR_NUMBER

NUMBER (10)

Message number

RUN_ERROR_MESSAGE

VARCHAR2 (2000)

Message text

TARGET_NAME

VARCHAR2 (80)

Name of mapping operator representing target table

TARGET_COLUMN

VARCHAR2 (80)

Column name, or '*' if not known or not applicable

STATEMENT

VARCHAR2 (2000)

Value such as INSERT or BATCH INSERT, or a PL/SQL statement

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATED_ON

DATE

The time the audit data was updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-26 ALL_RT_AUDIT_MAP_RUN_TRACE

Column Name Data Type Description

TRACE_ID

NUMBER (22)

Internal primary key for map_run_trace

MAP_RUN_ID

NUMBER (22)

Internal key to audit_map_run

MAP_STEP

NUMBER (22)

Step number 0 or 1

For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run

CURSOR_ROWKEY

NUMBER (22)

Value identifying error row returned by cursor. This is 0 for set-based run

TYPE

VARCHAR2 (30)

NEW for trace or ERROR for error

ROLE

VARCHAR2 (30)

S for source or T for target

ACTION

VARCHAR2 (30)

Value such as SELECT or a PL/SQL statement

TABLE_NAME

VARCHAR2 (80)

Name of mapping operator representing source/target table

CREATED_ON

DATE

The time the audit data was created

CREATED_BY

VARCHAR2 (30)

Database username

UPDATED_ON

DATE

The time the audit data was updated

UPDATED_BY

VARCHAR2 (30)

Database username


Table 1-27 ALL_RT_AUDIT_PROC_RUN_ERRORS

Column Name Data Type Description

RUN_ERROR_ID

NUMBER(22)

ID of the run error

MAP_RUN_ID

NUMBER(22)

ID of the map run

CURSOR_ROWKEY

NUMBER(22)

Rowkey of record returned by cursor when error reported

RUN_ERROR_NUMBER

NUMBER(10)

Error number

RUN_ERROR_MESSAGE

VARCHAR2(2000)

Error message

TARGET_NAME

VARCHAR2(2000)

Name of target

TARGET_COLUMN

VARCHAR2(80)

Name of target column

STATEMENT

VARCHAR2(2000)

Statement when error is reported

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user


Table 1-28 ALL_RT_AUDIT_STEP_RUN_STRUCTS

Column Name Data Type Description

STRUCT_ID

NUMBER(22)

ID of the structure

STEP_ID

NUMBER(22)

ID of the step in the map

MAP_RUN_ID

NUMBER(22)

ID of the run of the map

PARENT_OPERATOR_UOID

VARCHAR2(32)

UOID of the map-operator being audited

PARENT_OBJECT_UOID

VARCHAR2(32)

UOID of the parent object that the object is related to

PARENT_OBJECT_TYPE

VARCHAR2(30)

Type of the parent object

PARENT_OBJECT_LOCATION_UOID

VARCHAR2(32)

UOID of the location where the parent object has been deployed

PARENT_OBJECT_NAME

VARCHAR2(80)

Name of the parent object

OBJECT_UOID

VARCHAR2(32)

UOID of the object

OBJECT_TYPE

VARCHAR2(30)

Type of the object

OBJECT_LOCATION_UOID

VARCHAR2(32)

UOID of the location where the object has been deployed

OBJECT_NAME

VARCHAR2(80)

Name of the object

UPDATED_ON

DATE

Update timestamp

CREATED_ON

DATE

Creation timestamp

UPDATED_BY

VARCHAR2(40)

Updated by user

CREATED_BY

VARCHAR2(40)

Created by user