Replies posted by lopespetro

237 Replies

Schedule Inside one Maint. Window

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

2 years ago

Magnus SvenssonDo Gooder (Employee)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Scheduling Order Reports (Order Confirmation Reminder)

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

2 years ago

Magnus SvenssonDo Gooder (Employee)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Scheduling Order Reports (Order Confirmation Reminder)

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

2 years ago

Magnus SvenssonDo Gooder (Employee)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Scheduling Order Reports (Order Confirmation Reminder)

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!

2 years ago

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

Transfer Work Assignments to Mobile

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

2 years ago

HumbertoFloresDSidekick (Customer)

asked in Distribution (CRM, Commerce)

How can i migrate a Lobby From IEE to 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.

2 years ago

HumbertoFloresDSidekick (Customer)

asked in Distribution (CRM, Commerce)

How can i migrate a Lobby From IEE to Aurena

Hi,did you check the permission set in projections?These are for Aurena.

2 years ago

HumbertoFloresDSidekick (Customer)

asked in Distribution (CRM, Commerce)

How can i migrate a Lobby From IEE to Aurena

@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

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

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;

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

You might also want to have a look at this post by @dsj: https://dsj23.me/2021/08/27/tips-to-avoid-mutating-table-error-in-ifs-event-actions/ Nice content, but still not working.

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

I’m trying with a custom field but getting the same problem.Any ideas? DECLAREp1_ DATE;BEGINSELECT PLANNED_FINISH INTO p1_ FROM jt_task_uiv WHERE objkey = '&OLD:ROWKEY'; UPDATE jt_task_cft SET CF$_PRI_PLAN_DATE = p1_ WHERE rowkey = '&OLD:ROWKEY';end;

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

The SELECT above could probably be removed. You can get the value using the &OLD/NEW syntax instead. Then I assume the UPDATE will go well since that is the custom field table, which is not what you are triggering on. What do you think, @Tomas Ruderfelt? Yes, something like this: BEGIN UPDATE jt_task_cft SET cf$_pri_plan_date = '&OLD:PLANNED_FINISH' WHERE rowkey = '&OLD:ROWKEY';END; Hi, good info, but this works only if I already have a line in cft table. Otherwise, there is no rowkey to link to task table.I tried creating a text custom field with a sysdate default value.As the user create a task, the system creates a row in cft table with the sysdate. After release the task, the event works. It updates the field with the planned finish.But there is a situation that I need to block the update of this field after the first time release.Could you guys have any idea how may I do that?If the user changes the planned finish, the event is changing the custo

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

If there is no record in the CFT, you don't need to update it either, right? in fact, I need to insert the planned finish after realease.I could block the change with another event not letting the user return the status to prepared and after workstarted not return to release.But I’ve another situation that if the user creates a task from mobile, there is not cft line, just if I create the task in IEE.Tried with history log but got the same situation “mutating”If you have an idea, please tell me.I saw this article but how could I create a database task and call the procedure to insert planned finish date to the lastest_start field after the user realease the wo task?

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

Try to update this field from a background job and instead of using direct update query in the custom event, I recommend you to use Modify/Modify__ method of JT_TASK_API. you can create background job using another custom event, by following below example: Event 1:DECLARE /*define variables*/ lu_name_ VARCHAR2(8000):= 'EquipmentFunctional'; event_id_ VARCHAR2(8000):= 'C_UPSERT_PM_GROUP_ID_EQBJ';-- call this event event_msg_ VARCHAR2(8000); attr_ VARCHAR2(32767);BEGIN event_msg_ := Message_SYS.Construct('C_AUTOMATE_DEPENDENCIES'); -- from this event Message_SYS.Add_Attribute(event_msg_, 'OLD_MCH_CODE', '&OLD:MCH_CODE'); Message_SYS.Add_Attribute(event_msg_, 'OLD_CONTRACT', '&OLD:CONTRACT'); Client_SYS.Clear_Attr(attr_); Client_SYS.Add_To_Attr('EVENT_DATA_', event_msg_, attr_); Client_SYS.Add_To_Attr('EVENT_ID_', event_id_, attr_); Client_SYS.Add_To_Attr('EVENT_LU_NAME_',lu_name_, attr_); attr_ := REPLACE

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

@lopespetro I’m not sure how to setup database task values according to your case. But I have attached an example for your reference on parameter default values. I think it would be better, if you go with Modify__ and its similar to this post community link . That is trying to update a custom field but you can use the same logic for your purpose. Most of the data you need, can get directly from custom event attributes, same as ‘&OLD:TASK_SEQ’ which you have already used. Hi, after burning the midnight oil, I’ve done in this way:Change the event table to “WORK_ORDER_JOURNAL_TAB”. As the user changes the work task to released, the system creates a record here.Like this works well.Also set the EARLIEST_START readonly in conditional field.As part of the process, once the user release the work task or start work, it’s not possible to return the status. BEGIN UPDATE jt_task_tab SET EARLIEST_START = PLANNED_FINISH WHERE TASK_SEQ = '&NEW:TASK_SEQ';end;Appreciate the help and

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

resource break

Hi, I could get it.I need to schedule the break inside MPB before schedule the work task.Tks for attention!!

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

command_SYS.mail must be declared

Hi, I’m not getting the error anymore just by inserting the owner before command.ifspet.COMMAND_SYS.Mail I’m testing but not getting the e-mail in my inbox. Am I missing something? ifspet.COMMAND_SYS.Mail('IFS Applications!', 'test@test.com.br', 'test@test.com.br', NULL, NULL, 'Subject', 'body', NULL, NULL, 'test@test.com.br'); ============================================================ --testeDECLARE mail_ VARCHAR2(2000); poco_ VARCHAR2(50); obs_ VARCHAR2(2000); CURSOR get_mail IS SELECT E.VALUE FROM IFSPET.fnd_user_property E WHERE E.identity IN (select a.person_id from ifspet.SURVEY_ACCESS a WHERE A.survey_id = 'CHK-CSB-001') AND E.NAME = 'SMTP_MAIL_ADDRESS'; CURSOR get_poco IS SELECT A.ANSWER FROM IFSPET.SURVEY_ANSWER A where a.EMP_NO = '000048'

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

command_SYS.mail must be declared

Hi @lopespetro, Please check application messages OUT1 queue and see if you can find relevant application message for sending mail. Any errors while sending the email is displayed there. Regards, Damith Hi, dsj, i’ve got it working using this example from plsql. ifspet.COMMAND_SYS.Mail('IFS Applications!', ‘’, ' Olá, prezados ' || poco_ || 'Obrigado' || obs_ || CHR(13) || CHR(13) || 'Favor verificar.' || CHR(13) || CHR(13) || CHR(13) || CHR(13) || 'Atenciosamente,' || CHR(13), NULL, NULL, NULL, 'CSB DO POCO COM ANOMALIA', NULL, NULL, 'IFS');But from event action is not working. I thing there is some thing wrong in my code.if I just run the command sys it works, but not using the code above.I have a survey just with 2 questions?if the second is “YES”, the user must put a remark and I need to send e-ma

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

command_SYS.mail must be declared

Hi @lopespetro , If it works from plsql, it could be the event action conditions. Remove conditions and see if it works. specially check survey_answer_tab for what’s the value recoded for ANSWER column. It could be a different value which is in the table than it’s shown in the client. Regards, Damith Hi,one thing I could see is the date format in tab is datetime, but using the e-mail event format it shows just date. The conditions are OK, i’ve already tested them. Maybe the connections:I’m taking a look at this and see if it works.Tks a lot sir. CURSOR get_obs IS SELECT c.REMARK FROM IFSPET.SURVEY_ANSWER c where c.EMP_NO = '&NEW:EMP_NO' and c.DATE_CREATED = TO_DATE('&NEW:DATE_CREATED', 'DD/MM/YYYY HH24:MI:SS') and c.SURVEY_ID = 'CHK-CSB-001' AND c.QUESTION_ID = 3585;

2 years ago

lopespetroHero (Customer)

asked in Assets (Asset Management)

command_SYS.mail must be declared

Hi @lopespetro , If it works from plsql, it could be the event action conditions. Remove conditions and see if it works. specially check survey_answer_tab for what’s the value recoded for ANSWER column. It could be a different value which is in the table than it’s shown in the client. Regards, Damith Hi, one thing I could see is the date format in tab is datetime, but using the e-mail event format it shows just date. The conditions are OK, i’ve already tested them. Maybe the connections: I’m taking a look at this and see if it works. Tks a lot sir. CURSOR get_obs IS SELECT c.REMARK FROM IFSPET.SURVEY_ANSWER c where c.EMP_NO = '&NEW:EMP_NO' and c.DATE_CREATED = TO_DATE('&NEW:DATE_CREATED', 'DD/MM/YYYY HH24:MI:SS') and c.SURVEY_ID = 'CHK-CSB-001' AND c.QUESTION_ID = 3585; Hi,I think what I need it’s not possible this way.I’m trying to get the first answer. The key a have is emp_no, survey ID and date created, bu

2 years ago

hansendDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Application Server Task Quick Report Parameters

Hello Everyone, I have created a quick report for use in an Application Server Task. Everything is working fine, but I was curious if in the parameter section is it possible to have a dynamic date for the value? Are there any keywords that IFS recognizes that would allow me to have this report run for data from the previous day? The help at ...ifsdoc/f1doc/Foundation1/040_administration/230_bckgrnd_processing/030_app_server_tasks/default.htm#QuickReport_job_parameters just has “To be written...” so not a whole lot to go off of there. If there is not, the System Info doesn’t have any information regarding that form, but is it possible that there is an API that could be used to update that value? Thanks Hi,have you tried using the system variables?

2 years ago

meshfemiSidekick (Customer)

posted in Service (Touch Apps, MWO, MRO)

MWO Failed Transactions

Hi,Does anyone know about this failed transaction? ERRINV: Null value not allowed. (ORA-01400: cannot insert NULL into ("IFSPET"."MOBILE_WORK_ORDER_CFT"."ROWKEY") USING APPS 10 UPD12 - MWO MAINTENANCE 10 - 10.13.1360.0This happens as I incomplete the assignment. Tks.

2 years ago

AnjanaSidekick (Former Employee)

asked in Service (Touch Apps, MWO, MRO)

Service Engineer App Notifications - Not Working

Hi,I’m face similar problem USING APPS 10 UPD12 - MWO MAINTENANCE 10 - 10.13.1360.0. Tried the manual notification, the job works in background and has the state “ready”. But the notification does not show in mobile.Also checked the mobile permission and it’s OK.push is empty. Any other ideas?Tks

2 years ago

hansendDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Application Server Task Quick Report Parameters

Thanks @lopespetro for the response That’s what I originally thought. I did try #YESTERDAY# and I received this: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 With this as the parameters (that was sent in the exported excel): Parameters: (Fnd_View) cursor/OUT (Text) = from_date/IN (Text) = #YESTERDAY# to_date/IN (Text) = #YESTERDAY# So I am going to assume that it doesn’t work? I know that #YESTERDAY# format for custom events is YYYY-MM-DD and my quick report has this: TO_DATE('&From_Date', 'YYYY-MM-DD'). I’m not sure if it’s possible. But one thing I did and works is to set the dynamic date direct in the quickreport query. NVL(to_date('&start_date', 'DD/MM/YYYY'), TRUNC(SYSDATE)) AND NVL(to_date('&end_date', 'DD/MM/YYYY'), TRUNC(SYSDATE)) + (1 - 1 / 24 / 60 / 60)

2 years ago

lisa.gilesABSidekick (Customer)

asked in Assets (Asset Management)

Work Order / Work Task Dates

Trying to close down a Work Order with the Work Task Actual Finish Date of a date in the past (02/06/2021). Once the Dates are entered and Saved, User does RMB > Status > Work Done This error appears: How does the User get around this? How do they change the Work Order Finish Dates to match the Work Task? Hi,the status of the task or the work order?Go RMB > report in work order > report in tab and check the dates there.

2 years ago

Page 1 / 10

Replies posted by lopespetro

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded