My Oracle Support Banner

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


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
(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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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