Solved

Issue when i select a view for reference for a field

  • 2 February 2022
  • 1 reply
  • 175 views
HumbertoFloresD
Rank
Userlevel 5
Badge +9

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

icon

Best answer by Kelum Pradeep Kumara 2 February 2022, 23:11

View original
This topic has been closed for comments

1 reply

Kelum Pradeep Kumara
Rank
Userlevel 7
Badge +18

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.

 

-Kelum Niranjana
Terms & ConditionsCookie settings