OBIA:11.1.1.8.1: Spend Classification - Run Tables

(Doc ID 2145693.1)

Last updated on AUGUST 17, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Goal

On : Oracle Business Intelligence Application 11.1.1.8.1 

Spend Classification - Run Tables

Over time a number the number of Spend Classification Tables has grown, they look like tables created when loading and/or classifying data. Some have data in, some don't. The tables are:

- PSC_RUN_KEYWORD_n
- PSC RUN_OUTPUT_n
- PSC_RUN_TRAIN_TAB_n
- PSC_RUN_UPLOAD_STAGING_n

where n on each of the tables is a sequence number.

1) Do they have any ongoing purpose after they have been created?

2) Are any of these tables ever cleaned up or is the number of tables just going to keep growing as we use the Product? If so, will that impact the Performance of spend classification in any way?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms