IFS APPS 10 IAL Aurena Lobby Error

Hi @WyrAndreM ,

Does the &IAL.WYR_CLOCKED_IN_REP view has any column with a name similar to the alias used in data source?

If so, please make sure to use a name that does not exist as a column name in the
view. Let us know whether it would work ..
 

Hello @WyrAndreM,

Check if there are any common names have been used for a column in &IAL.WYR_CLOCKED_IN_REP view and the alias that is used in data source. If so, please change the names.

Cheers!

Thank you for the replies I have swapped out the alias to be something that would not be used as per normal for a reference and refreshed Aurena cache but still have the same issue e.g. 

What user account are you using, IFSAPP?

@WyrAndreM 

I guess, if you just use company_id and emp_no only in data source, you will be able to see the element in Aurena? Did you give such a try?

Using my own account as opposed to IFSAPP and the code for the IAL is as follows - 

“

CREATE OR REPLACE VIEW &IAL_OWNER..&OBJECT._IAL AS
 SELECT distinct company_id,emp_no
         FROM   &AO..time_pers_diary_clocking_tab
         WHERE account_date BETWEEN TRUNC(sysdate + (NVL(1, 0) / 24) ) -1 AND TRUNC(sysdate + (NVL(1, 0) / 24) ) +1
         AND    proc_status   != 'B'
         AND    in_pers_class != 'F'
         AND    in_stamp BETWEEN (sysdate + (NVL(1, 0) / 24) ) -0.75 AND (sysdate + (NVL(1, 0) / 24) )
         AND    NVL(out_stamp, (sysdate + (NVL(1, 0) / 24) ) +1) > (sysdate + (NVL(1, 0) / 24) )

“ 

Thanks.

Can you run a select statement over the IAL - using the query tool or something else?

I have created a new datasource element and lobby element with 1 column but still get the same results, I can also view this in the SQL query tool. I have created a new IAL looking at company column from company.

EE Client - 

Aurena Client - 

Thanks.

As you are not using the IFSAPP account. It might be worth checking the permission set access (thats assigned to your account) for this Aurena Lobby. The Aurena Lobby has a separate object (from EE) that would need granting. 

@WyrAndreM 

Just give a try to change the &IAL.WYR_CLOCKED_IN_EMP to IFSINFO.WYR_CLOCKED_IN_EMP where you have to give the view name in Data Source Designer.

IAL Object Developer
 

IEE
 

Aurena
 

Thank you, I did try the INFSINFO schema prefix on the Datasource element which didn’t appear to work before i’m not too sure why, I have since retried which has corrected the problem thanks for you help.