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 ?
+10Hi
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
+11Hi
Please use the Views instead of tables. and don’t forget to add prefix &AO.. for each views, tables and method call.
for example, &AO..Customer_info,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.