Skip to main content

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 @JannetteC

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

Hi @JannetteC 

 

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,

Reply


Terms & ConditionsCookie settings