Solved

Calendar days Aurena permission

  • 10 January 2022
  • 11 replies
  • 149 views

Userlevel 5
Badge +12

Hi all.

I’ve developed a counter element for aurena but the values shows 0. In IEE is OK.

 

This is the view i’m using to calculate in the element.

 

WORK_TIME_COUNTER

 

I think I must grant the calendar to the user in Aurena. I’m trying to find it in projections.

 

Could someone help how can I allow the user to see the calendar days?

This is in IEE.

 

Aurena is 0.

 

icon

Best answer by lopespetro 4 March 2022, 18:57

View original

11 replies

Userlevel 7
Badge +20

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 :)

 

Userlevel 5
Badge +12

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.

Userlevel 7
Badge +20

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

 

Userlevel 6
Badge +14

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.

 

Userlevel 5
Badge +12

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

Userlevel 5
Badge +12

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 @Mathias Dahl , tks a lot. I’ll do that.

Br.

Lopes

Userlevel 6
Badge +14

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

 

 

Userlevel 5
Badge +12

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.

 

Userlevel 6
Badge +14

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.
  1. If it doesn’t work grant this API on your test environment to an usual user and test it there.

 

Userlevel 5
Badge +12

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.
  1. 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.

Userlevel 5
Badge +12

Hi all.

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

Tks a lot

Reply