Hello - I am trying to create an IAL but it keeps failing with the following (Failed executing statement (ORA-00903: invalid table name). I can run the same code in SQL developer with no issues, can someone tell me what I am doing wrong please ?
Hi
Can you please show us your SELECT statement or IAL please?
Probably you have to add the schema as prefix of your table.
E.g. table is CUSTOMER_INFO_TAB
→ IFSAPP.CUSTOMER_INFO_TAB
My recommendation is always to use the DB view instead of using the DB table.
select * from ifsapp.customer_info
/Jens
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.