Table Does Not Appear in Detail Client Data Loader List Even With Classification
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
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:
- Go to Process Management > Requests > Submit Request
- Set program to "Detail Client Data Loader" and click Next
- Review the list of values for "Rule"
The instrument table does not appear.
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