+5Hey All,
I’m on EE for Apps 10 and I’m trying to set up an IAL here:
However, when I try to deploy it, I keep getting this error:
I’m not sure if this is a syntax issue - because I get the same error if I use &AO. or if I remove the &AO altogether - or if API calls just aren’t allowed here, and I was hoping someone could straighten me out.
Best answer by MiLeNL
The &AO.. is correct, however API calls also need to be prefixed with &AO.. (e.g. &AO..Shop_Ord_API.Get_State). This is not done in your main SELECT statement. Also the WHERE clausule can just be added to your main select.
The reason why &AO.. is required; during runtime/execution of the query the &AO.. is replaced with the application owner who owns the database objects. If you omit the Application owner, it will try to find the database objects in your own user. Hence generating the error, as your user does not have the SHOP_ORD_API.GET_STATE database object.
Hope it's clear.
+23Hi
after ‘&AO’ you have two points (&AO..SHOP_Ord_Api….).
→ &AO.Shop_Ord_Api.Get_State()
The &AO.. is correct, however API calls also need to be prefixed with &AO.. (e.g. &AO..Shop_Ord_API.Get_State). This is not done in your main SELECT statement. Also the WHERE clausule can just be added to your main select.
The reason why &AO.. is required; during runtime/execution of the query the &AO.. is replaced with the application owner who owns the database objects. If you omit the Application owner, it will try to find the database objects in your own user. Hence generating the error, as your user does not have the SHOP_ORD_API.GET_STATE database object.
Hope it's clear.
+23OK, &AO.. was completely new for me. Thank you. :-)
Did you try to paste the where block (second block) to the first block?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
