Adding sensitive column to ADM results in warning "Number of applications/objects retrieved are limited to a maximum of 1000. Provide more restrictive search criteria to refine the list" (Doc ID 2912413.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Scenario 1:
###########

OEMCC 13.5: Adding sensitive column to ADM results in warning.

Adding a sensitive column to existing application data model by searching
column pattern 'XXX%' results in below warning

"Number of applications/objects retrieved are limited to a maximum of 1000.
Provide more restrictive search criteria to refine the list".

In this case the number of columns are just 100. This is confirmed by running
the following query

select count(*) from dba_tab_columns where column_name like 'XXX%';

count(*)
------------
100

Scenario 2:
##########

In second scenario adding sensitive columns to ADM by searching column_name
like 'AAA%' reports same warning

"Number of applications/objects retrieved are limited to a maximum of 1000.
Provide more restrictive search criteria to refine the list".

In this case the columns are more than 1000 i.e 1001 and it justifies the
warning

select count(*) from dba_tab_columns where  column_name like 'AAA%';

count(*)
------------
1001

Inconsistency in the warning message received for different count of sensitive columns

Changes

 NA

Cause

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