It looks like my images got stripped out.In the Design view you can see the reference to a sheet within the workbook. When the report is run you can see the sheet names have been stripped out so excel is now referring to cells on the current sheet:
Hi,Just to update on my previous reply.We have SSO working now.Above the standard setup shown in the YouTube Video we had to ...Add 2 Optional Claims in the Azure App Registration:upn with Token Type IDupn with Token Type Access In IFS add an IdP Attribute Mapper Name= upn Claim = upnThen obviously set the Directory ID of the user to be the Azure upn. RegardsPaul
Hi Kendall,Did you get a resolution for this?We are upgrading to IFS Cloud. Our company uses UPN that is not the email to login to Azure and I’ve hit similar issues. ThanksPaul
Hi @ConAlberM did you get a resolution to this?W have noticed our payment advices are randomly not sending and we have the errors just like you describe.
Thanks Johan,Yes there is a sequence. Some Authorisation groups and some Project Roles.The example I was using had reached the Project Manager of which there is only 1. I am testing in a non production environment at the moment so there will not be any contention between users.So I think the error is misleading. We have been using this form of authorisation in Aurena for 18 months.I will raise a ticket today with IFS support. Thanks,Paul
Thank you Magnus,This is what we will do.RegardsPaul
I noticed I didn’t update on this.The issue will be resolved in UPD22 for Apps 10.Paul
In case anyone else has this issue, I’ve written a script that cleans the failing reports (older than 3 hours) out of the queue: DECLARECURSOR cGetRows ISSelect p.report_id, p.result_key from ifsapp.XLR_REPORT_RENDERING_INFO pwhere p.rendering_status = 'Rendering in Progress'and p.created_date < sysdate - interval '3' hour;report_id_ varchar2(10);result_key_ varchar2(10);BEGIN for row_ in cGetRows loop report_id_ := row_.report_id; result_key_ := row_.result_key; ifsapp.xlr_report_rendering_info_api.remove_instance(report_id_,result_key_); COMMIT; end loop; END;
Thanks Everyone.@Dharshankumaar Mahendran It is not that there are data lines missing,Multifields are customer defined records and there are customer defined fields that do not show in Aurena.There are defined fields that do not show in Aurena but do show in EE.There is no validity period on the field itself. I have raised a ticket with IFS though it is currently priority 4. ThanksPaul
Further update. they do time out after 1 hour (3600 seconds set in the config file) but will try to run again when I restart the service.
By the way we are running in OOXML mode
FYI we have this in IFS Apps 10 Aurena.There is a workaround to select the advanced mode (1) and deselect “Default Transaction Dates” (2) as below.1.Select Advanced Mode2. deselect “Default Transaction Dates”ThanksPaul
Hi,I know this was a while ago but we have the same issue. I know the permission is an EE permission I need to add but I can’t find it. Can you remember what you added? ThanksPaul
IFS support have identified a fix for this. They initially identified it as low severity but the screen is unusable so it is going to be delivered for free.I believe it is in an update too but not sure which one.
Thanks Himasha, I’m considering this - or using default startup behavior for the window. Neither is ideal but will work.
Hi Johan,That was it!We have the reasons in Production but for some reason they were not in DEV where I am testing.I’ve copied them across and it’s now offering them in the app.Thank you. Paul.
Thanks Jonas, That’s what I expected but I’m relatively new to Aurena so worth the ask.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.