You might want to cross post this (just post a link) in the framework section here at Community as well. I think there might be more lobby nerds hanging out there :)

Hi @Mathias Dahl , sorry but I didn’t get it.

You mean I post what link and where?

I don’t know why the user is not seeing the info in aurena lobby.

the collumn is based on calculation.

The sum of the total reported hours of the work task divided by the sum of the total hours based on calendar.

The view: &AO.JT_TASK_TRANSACTION_UTIL

The column: 

NVL(sum(quantity),0) / (SELECT SUM(A.working_time / 60 + 1) FROM &AO.WORK_TIME_COUNTER A WHERE A.calendar_id = 'PETRO-ADM' AND TRUNC(A.work_day) between TRUNC(SYSDATE, 'MM') and LAST_DAY(SYSDATE))*100

If I change the select to a static number it works in Aurena. So that I thing is related something about permission to the calendar.

Tks for attention.

Sorry for not being clear.

I meant you should post a link to this post/question here as well:

https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50

Hi @lopespetro 

I can show you my approach in IFS App 9:

You can grant the lobby as following:

Then choose there your lobby. You can also select here all lobby sources and elements.

Grant the view you need for your lobby.

Hi @lopespetro 

I can show you my approach in IFS App 9:

 

You can grant the lobby as following:

Then choose there your lobby. You can also select here all lobby sources and elements.

 

Grant the view you need for your lobby.

 

Hi @Link , Tks for the info.

I’ve already done this and in IEE works well.

My problem is as I open the lobby page in Aurena.

The counter shows zero in value.

I’ve already granted all the projections related calendar but still does not work.

I’m keeping trying to find what it is.

Br.

Lopes

Hi @Mathias Dahl , tks a lot. I’ll do that.

Br.

Lopes

Hi @lopespetro 

I can show you my approach in IFS App 9:

 

You can grant the lobby as following:

Then choose there your lobby. You can also select here all lobby sources and elements.

 

Grant the view you need for your lobby.

 

Hi @Link , Tks for the info.

I’ve already done this and in IEE works well.

My problem is as I open the lobby page in Aurena.

The counter shows zero in value.

I’ve already granted all the projections related calendar but still does not work.

I’m keeping trying to find what it is.

Br.

Lopes

Hi @lopespetro 

can you provide a screenshot of your data source please?

So I can check your statement.

Maybe you can try one of these:

IFSAPP. WORK_TIME_COUNTER  or this

&AO. WORK_TIME_COUNTER

Hi @lopespetro 

I can show you my approach in IFS App 9:

 

You can grant the lobby as following:

Then choose there your lobby. You can also select here all lobby sources and elements.

 

Grant the view you need for your lobby.

 

Hi @Link , Tks for the info.

I’ve already done this and in IEE works well.

My problem is as I open the lobby page in Aurena.

The counter shows zero in value.

I’ve already granted all the projections related calendar but still does not work.

I’m keeping trying to find what it is.

Br.

Lopes

Hi @lopespetro 

can you provide a screenshot of your data source please?

So I can check your statement.

Maybe you can try one of these:

IFSAPP. WORK_TIME_COUNTER  or this

&AO. WORK_TIME_COUNTER

 

 

Hi @Link , follow the screen shot. I’m using the owner before the view.

It’s strange because in IEE it works.

Even with the owner user, in Aurena does not show the info.

The column: 

NVL(sum(quantity),0) / (SELECT SUM(A.working_time / 60 + 1) FROM &AO.WORK_TIME_COUNTER A WHERE A.calendar_id = 'PETRO-ADM' AND TRUNC(A.work_day) between TRUNC(SYSDATE, 'MM') and LAST_DAY(SYSDATE))*100

Owner user:

lobby in IEE:

Lobby in Aurena.

Hi @lopespetro 

I think an usual user doesn’t have the permission for Fnd_Session.API

1. Try this: &AO.Fnd_Session.API.Get_FND_User.

2. If it doesn’t work grant this API on your test environment to an usual user and test it there.

Hi @Link , tks for the info.

Changed to &AO. but no success.

The second element is using the same condition and it works.

The problem is when I use the calendar view.

TRUNC(TRANSACTION_DATE) between TRUNC(SYSDATE, 'MM') and LAST_DAY(SYSDATE) AND
RESOURCE_ID = &AO.Fnd_Session_API.Get_Fnd_User

I’ve have posted also in 

as mentioned by @Mathias Dahl .

The thing is even with the onwer user does not work just in Aurena.

Hi all.

After refreshing some caches it worked. I didn’t uderstand right but the problem is solved.

Tks a lot