You are experiencing the classic "mutating table" problem that most people working with triggers (used by a custom event) do. If you search for that here or on the internet you can find various workarounds, as well as an explanation of what it is about. Here is one forum post that mentions it: https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/cannot-update-custom-field-from-custom-event-11581 Hi, tks for the info.putting the pragma but getting the deadblock. DECLAREpragma autonomous_transaction; p1_ DATE;BEGIN SELECT PLANNED_FINISH INTO p1_ FROM jt_task_uiv WHERE TASK_SEQ = &OLD:TASK_SEQ; UPDATE jt_task_tab SET LATEST_START = p1_ WHERE TASK_SEQ = &OLD:TASK_SEQ;commit;end;
@lopespetro In this section what i should do for view my lobby? You need to open the permission set for the related user and give the permission of the view with the information.take a look in this post. https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/grant-permission-by-page-in-aurena-7187
Hi,did you check the permission set in projections?These are for Aurena.
I Create a Lobby in IEE and in the client type i select Aurena but when i try to open this lobby in aurean Doesnt Work How can i solve this situation ? Regads! Hi,Check if the page and the element are set to Aurena Type.Also, the permission set in Aurena is different.Br.
Hi Skullk.Tks for the info. I did another test and the system works like that. But to solve my problem, I just ignored the tranfer window date variable and set to sysdate in the cursor parameter.It’s working well. AND trunc(e.allocated_start) = trunc(SYSDATE) when schedule a task, I leave the transfer window blank and the system just transfer the sysdate allocated start, not all. Tks for attention
Hi @lopespetro , I’m not aware of a standard functionality to schedule a crystal report type quick report in IFS. Maybe you can define a custom database procedure to run the quick report, and export/email the report, and create a new database task in the application using that custom procedure, and then create a new database task schedule using that database task. If there’s a standard way to do this, please someone let us know. Thanks, Hi @ThushAsanka ,Tks 4 the info.I’ll try that method.Best Regards!
Hi @lopespetro , Yes, you can schedule to run a SQL statement type quick report and email to a set of users as an excel export. You can use Application Server Task for this, defining the Job type as Quick Report. After saving, RMB and select “Scheduled Task”. Then, it will create a scheduled task for this. Then, in the scheduled task window which is populated with the data for the defined application message, you can schedule it as you want. You can find more information on Application Server Task in this help document. https://docs.ifs.com/techdocs/Foundation1/040_administration/230_bckgrnd_processing/030_app_server_tasks/default.htm Thanks, Hi ThushAsanka,Yes. I found it there.How about Crystal reports? Is there anyway or do I need a customization?Tks a lot
Hi @Magnus Svensson , Yes, you can easily schedule a report is available in order reports through “Create New Report Schedule”. There, you can change the Report Schedule Name as you want, and select the wanted report from the list of values available. You can set the parameters in Parameters tab (note that Parameters section will change based on the report you select). And, in the Schedule tab, the scheduling time parameters can be entered. In the Settings tab, you can specify what the system to do after the report is run; whether it is just save the report in report archive, or print, or email to a set of users… Hope this helps.. Thanks, Hi. This is gr8.Is there a way to schedule a custom quick report?Tks
Hi @Vinu Peiris, Thanks for the response, It seems to be specific to the resource detail & not affecting WO generation. This can be a requirement which is not handled yet. We have a GSD case reporting similar scenario & will see if can get a confirmation either end. Hi,Have you try creating an event to uncheck this box after the creating of the WO?Br.Samuel Lopes
Already have an account? Login
No account yet? Create an account
Enter your username or 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.