Share this page

# RPT_TRACE_DETAILS

This table stores the file, line, and function that need to perform SQL level trace during full ETL or incremental ETL. Enable trace log for the SQLs you noted down by adding the file name, line number, and function name of the rows to the RPT_TRACE_DETAILS table.

If you add file name and set line number to -1, the SQL trace log stays open for the entire package body file.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FILE_NAME | NOT NULL | NUMBER | PLSQL package body file name
LINE_NO | NULLABLE | NUMBER | Line number in package body source file
FUNC_NAME | NULLABLE | NUMBER | Function name of the package

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_TRACE_DETAILS_N1 | NONUNIQUE | 1 | FILE_NAME
RPT_TRACE_DETAILS_N2 | NONUNIQUE | 1 | LINE_NO
RPT_TRACE_DETAILS_N3 | NONUNIQUE | 1 | FUNC_NAME

## Sequences

This table does not use any sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: