Hi all,
I am creating folder object types using Eclipse Composer. I have user value assistance to populate attribute values from register tables. I am using the following query in the conditional assistance.
select <column name> from dm_dbo.<table name> where <column_name>='$value(r_object_type)' and <cloumn_name>=some value
Now while creating the folder type in Document Administer the dropdown list is correctly getting populated. But while i click on Finish it gives the following error :
DM_QUERY2_E_TABLE_NOT_FOUNDerror: The database table or view was not found in the database. Error from database was:'ORA-00942 table or view does not exist'
The queries used in the value assistance when executed through DQL editor return correct results.
Please help.