Use IAL on Lobby Data Source

Christophe, are you using two periods between the “&IAL” and the object name? I think you only need one at this point. I just created a Quick Report, and the following query was accepted:

SELECT * FROM &IAL.<View Name>

Just one period, unlike the dual periods you need to use when creating the IAL itself (I am not entirely sure why that is, but assume it is due to the IAL being created with another layer of indirection?).

So, just speaking from some limited experience, two periods when creating the IAL, as in:

&AO..Customer_Info

and one period when consuming data from the deployed IAL, as in:

&IAL.<IAL view name>

(This is all assuming the IAL has permissions properly set so that it is visible to whoever is running the query.)

Hope that works for you…

Joe Kaufman

Hi @sutekh137, Thanks for your mail but it don’t works. Are you on 21Rx ?

 We are on APPS10 on-premise.

can you make a Quick Report against the IAL? The Quick Info Source idea sounds like a good one to get this working in Aurena/web. I do not have much experience with that.

Thanks,

Joe Kaufman

it works using the quick information source and use QFACT_xxx_IAS$ like view in the lobby data source designer.

Best thanks for all.

For me it worked by changing &IAL. to ifsinfo. before the IAL name.