Hi everyone, i try to reference a view for LOV of Custom Field, but Doesnt work and displays this error
Thanks for the help
Regards
Solved
Issue when i select a view for reference for a field
+9Best answer by Kelum Pradeep Kumara
When you are using a CcotcfBl it appears that it does not have a base table. So, you won’t be able to use views related to that.
Technically, if you want to find whether that logical unit has a base table, you can use following code to check.
begin
-- Call the function
:result := dictionary_sys.get_base_table_name(‘CcotcfBl ‘);
end;
please execute above statement in a PLSQL Test window and check whether it is a base view or not.
This topic has been closed for replies.
+18When you are using a CcotcfBl it appears that it does not have a base table. So, you won’t be able to use views related to that.
Technically, if you want to find whether that logical unit has a base table, you can use following code to check.
begin
-- Call the function
:result := dictionary_sys.get_base_table_name(‘CcotcfBl ‘);
end;
please execute above statement in a PLSQL Test window and check whether it is a base view or not.
-Kelum Niranjana
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.