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.
The view: &AO.JT_TASK_TRANSACTION_UTIL
WORK_TIME_COUNTER
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
I think I must grant the calendar to the user in Aurena. I’m trying to find it in projections.
I’m using owner and IFS UPD12.
Could someone help how can I allow the user to see the calendar days?
This is in IEE.
The same element Aurena is 0.
