Table Does Not Appear in Detail Client Data Loader List Even With Classification (Doc ID 565851.1)

Last updated on NOVEMBER 18, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
Oracle Profitability Manager - Version: 11.5.10
This problem can occur on any platform.
Detail Client Data Loader

Symptoms

When trying to run the "Detail Client Data Loader" program in an 11i instance, you cannot see a user defined instrument table in the "Rule" list of values in the parameters screen.  You have already assigned the required "Detail Client Data Tables" classification to the instrument table.

The table does appear in the results of the following query used to generate the list of values:

select to_char(object_definition_id) FLEX_ID, display_name FLEX_VALUE,
display_name FLEX_DISPLAY, description FLEX_DESCRIPTION
from FEM_OBJECT_DEFINITION_VL where
(object_id IN (SELECT o.object_id
FROM fem_object_catalog_b o, fem_user_folders f,
fem_data_loader_objects d, fem_table_class_assignmt_v t
WHERE o.object_type_code = 'SOURCE_DATA_LOADER'
AND o.folder_id = f.folder_id
AND f.user_id = &user_id
AND d.object_id = o.object_id
AND d.table_name = t.table_name
AND table_classification_code = 'SOURCE_DATA_TABLE')
AND old_approved_copy_flag = 'N')
order by display_name;

(where &user_id is from the result of this query:
select user_id, user_name from fnd_user where user_name = <login name in caps>;)

Steps To Reproduce:

The instrument table does not appear.

Cause

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