- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Topics started by lopespetro

75 Topics

Most views

Recently active Most replies

lopespetroHero (Customer)

asked in Assets (Asset Management)

command_SYS.mail must be declared

Hi everyone.Trying to send e-mail based on event action. I’m getting this error. Could someone help please? Running in plsql it says that the command_sys.mail myst be declared. --testeDECLARE mail_ VARCHAR2(100); 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' and a.DATE_CREATED = TO_DATE('17/10/2021 09:50:21', 'DD/MM/YYYY HH:MI:SS') and a.SURVEY_ID = 'CHK-CSB-001' AND A.QUESTION_ID = 3584; CURSOR get_obs IS SELECT a.REMARK FROM IFSPET.SURVEY_ANSWER A where a.EMP_NO = '000048' and a.DATE_CREATED = TO_DATE('17/10/2021 09:50:21', 'DD/MM/YYYY HH:MI:SS') and

lopespetroHero (Customer)

asked in Assets (Asset Management)

UPDATE DATEFIELD EVENT SERVER

Hi,I’m trying to update a date the latest_start field based on the change of planned_finish by an event server but with no success. Inside the application. Using PL/SQL it works well runing the code manuallyCould someone help please?Follow the code: DECLARE 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;

lopespetroHero (Customer)

asked in Assets (Asset Management)

PM ACTION CONNECTIONS

Hi all.Could someone help with the situation bellow?I have 3 pm actions for the compress equipment and the trigger is based on condition hours.There are some equipments (instruments) that needs to be connected to the main pm action to be generated according to the compress hourmeter.the sequence of conditions are 2000hrs, 4000hrs, 8000hrs and so on.The instrument 01 4k hrs, needs to be connected to the compress 4k and 8k so I’ll not duplicate the pm action of the instrument.Not allowed to connect the same pm action under two different compress pm action. Please see print.Am I missing something or there another way to do this?I tried creating just on pm action including all conditions line in condition tab considering the maint triggers of the work task template but as I generate the WO, the system takes all the work tasks templates to the WO of just one condition (4k hrs for instance).Also tried the replacement function but it’s not possible as there is connection for the related pm ac

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

Conditional Custom Field Aurena native

Hi everyone.Is there an option to create a custom field or edit the logic of an existing one to insert a logical condition?E.g.: If the user choose NA of one field, the Remark field is required (like the eform type of answer (Yes/NO))Tks for help!

lopespetroHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

PERMISSION FOR BUSINESS REPORT IN EXCEL

Hi all.Which permission set should I give to user to let use Business report in Excel?I Already installed the add-in and give access to the information source needed.But after login, the user has the message: Note: Using my user I can login and run the report. but I have access to all permission sets. Tks a lot

lopespetroHero (Customer)

asked in Assets (Asset Management)

MWO survey answer set logic

Hi all.Could someone help me to understand the answer_set logic?I have a MWO survey that has been answered 4 times in the same day by the same employee.But the answer set has repeated 2 times.If this logical is correct, How could I group a snwer set in this situation?I thought the logic was 1,2,3,4 At the end of the day, I need to create a quickreport setting a parameter with one of the answers like the example bellow.I’m using this way in the select to do this but considering the answer set.min(v2.item_description) over (partition by c.emp_no, trunc(c.DATE_CREATED), c.answer_set ) as carTks a lot for help

lopespetroHero (Customer)

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

Send message from IFS to Whatsapp person or group

Hi All.Is there a way to send messages from IFS to Whatsapp?if yes, how may I do that? Like the application server functionality that we can send an e-mail with some information or a quickreport. Or like as an event server.My need is to send every morning the work orders schedule to be done for the current day.Tks a lot

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

MWO MAINT 10 - MOBILE NOTIFICATION

Hi all.I’ve just testing the APPS 10 UPD12 - MWO MAINTENANCE 10 - 10.13.1360.0 and the notification in mobile is not working.What may it be?Tks a lot.The push is not checked in mobile user;Sending manual notification works well in background but the user does not receive it.

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

Permission set filter for custom field MWO Aurena native

Hi everyone, I need to create a permission set filted based on a LOV custom field and apply to a certain permission set.But it’s not working,. The filter works just using core fields. Could someone help please?Tks a lot for help.I need to filter in mobile.

lopespetroHero (Customer)

asked in Assets (Asset Management)

Object levels create WO or PM action not possible

Hi All, I need to eneble a object level to create WO and PM but I’m getting the message bellow.I have just two objects created using this level and now i need to enable it.Why Am I getting this message? I don’t understand because I have no WO or PM action created for them.Tks for helping.

lopespetroHero (Customer)

asked in Assets (Asset Management)

PM ACTION STRUCTURE

Hi all.Could someone know if it’s possible to a maintenance plan of the “children” objects based on codition of the main object in structure?E.g.: I have a pump that works by hours.But bellow the pump, there are a couple of components that each one has a pm action.I need to generate work orders based onde the hours measured registered in the pump, and not in the components.if it’s not possible, I’ll need to set the parameter hour for all components and replicate the hours measured in the pump for all of them to have a maintenance plan.tks a lot

lopespetroHero (Customer)

asked in Assets (Asset Management)

WO Work Task new planning - server cannot serialize the data

Hi All.I’m getting this message as I press the + plus buttom to create a new line in planning tab inside the work task of a work order.This happen with the owner user.Does anyone know something about it?Tks a lot------------------------------------------------------------------------------------------Error while serializing contents.This error happens when the server cannot serialize the data to be sent to the client.A common cause is that one attribute's length exceeds the defined maxlength in the projection.To find more info, open Log Window or Debug Console, refresh and then check Network Tab in DevTools. In the response there can be more detailed information about the exception.Url: https://pettst.avcweb.com.br:64080/main/ifsapplications/projection/v1/WorkTaskHandling.svc/Reference_ActiveWorkOrder?$filter=WoNo%20eq%2085008&$skip=0&$top=2Request Id = 73f0e6bb-7261-44e4-adfe-2430f49601e6Date = 2022-10-04T13:28:31.496ZClient version = 10.14.127.0

lopespetroHero (Customer)

asked in Supply Chain

DIFFERENT BASE UNIT MEASURE INVENTORY PART

Hi all.I’m trying to create a part with same code for different site and different unit measure.I could see that the system allows do it just if the base UoM is the same.is there a way to disable it or another workaround?That’s because I have an integration with another system and this situation e commom.I already have lots of parts using those so that I can’t delete them and create others.Tks a lot.

lopespetroHero (Customer)

asked in Assets (Asset Management)

PM ACTION VALID FROM FIELD

Hi all.Could someone please clarify the logical of the valid from field in pm action? My situation is:I have a pm action tha was created 09/08/2020 with the same valid from date.The pm action is using a work task template. Now, the user has created another revision of the work task template and set the valid from date to the same as before 09/08/2020.Hi all.Could someone please clarify the logical of the valid from field in pm action? My situation is:I have a pm action that was created 09/08/2020 with the same valid from date.The pm action is using a work task template.The pm action is in interval 180 days. Considering the performed date based: Yes Now, the user has created another revision of the work task template and set the valid from date to the same as before 09/08/2020. After activate and Replace Obsolete Revision on PM Actions, the valid from field of the new revision on pm action has assumed the actual sysdate (11/10/2021), not the valid from date that has been set in the work

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

Survey signature location in view

Hi all.I’ve just testing the APPS 10 UPD12 - MWO MAINTENANCE 10 - 10.13.1360.0 and I’m trying to find the view name where the signature from the survey answer is.I need to insert it in crystal reports.Could someone help please?This is an employee survey type. So, there is no task number. Another thing is as I click to show the signature, it does not show on browser.Tried with Chrome and Edge. Tks a lot

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

Transfer Work Assignments to Mobile

Hello,Could someone please help with the situation bellow?I have set up a schedule to transfer the work assignments to mobile with transfer_window = 1.I understand that the system will transfer just the the of the allocated start.But the system has transfered all the assignments of different day.E.g. Allocated start to 08/21/2021, 08/01/2021 etc. Or the transfer_window means that the system will transfer all previous assignments till the sysdate as I chose “1” in the parameter field?Tks a lot

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

Instance of entity MOBILE_WORK_ORDER with objid not found in database

Hi All.I’ve just updated APPS10 from UPD14 to 17 and I’m getting this failed transaction in Aurena Mobile MWO Maintenance 10.The Assgnment is updated but the error occurs and also the flag “transfered to mobile” in worktask is still checked.Instance of entity MOBILE_WORK_ORDER with objid [AAAT4TAAGAAAXsMAAl] not found in database.Tried to find this mobile seq in tab but there is not anymore.Tks a lot

lopespetroHero (Customer)

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

Quickreport Aurena navegation with parameters from Lobby

Hi All.How could I add a navegation to a quickreport linking with the parameter in the lobby in Aurena?In IEE I use for example 2 parameters(date and equip): ifsrep:qr.636233?START_DATE=$START_DATE$&FINAL_DATE=$FINAL_DATE$&EQUIP=$EQUIP$ I need the same but for Aurena.Tks a lot!Br.Lopes

lopespetroHero (Customer)

asked in Assets (Asset Management)

Survey signature in plsql and crystal reports

Hi all.I’m testing the APPS 10 UPD12 - MWO MAINTENANCE 10 - 10.13.1360.0 and I’m trying to see the signature from the survey answer.In Aurena they appear.It’s a CLOB type but I can’t see it from plsql. Neither in crystal reports. Could anyone help please? Tks

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

MWO Entity taking too long time to sync

Hi All.I’m wondering why there entities are taking too long time to sync to mobile.Could someone help undertand it and how may I filter in permission set to not send the survey answer to the mobile user?A filter that looks like in object information that the user has access just for the worktask objects.E.g. &0.MCH_CODE in (Select distinct t.actual_object_id from Jt_Task_uiv t where t.task_seq in (select m.task_seq from Mobile_Work_Order_UIV m))the idea is that the user just answer the survey and send it back.Also a filter for the mediaLibrary.I want to improve the sync performance for mobile users.I’m using APPS10 UPD17 MWO Maintenance 10.Tks a lot for attention

lopespetroHero (Customer)

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

IEE/Aurena permission set Filter

Hi All.Is there a way to use permission set filter in IEE or Aurena (not mobile aurena native)?For mobile, it works fine.Situation:I have 10k objects in a site but some users needs to see just some based on the object level.Is this way OK, or I’m missing something? I tried to use in the activities bellow but not working?Tks for help!

lopespetroHero (Customer)

asked in Assets (Asset Management)

Object transformation - TaskTemplateWorkStep to PmActionWorkStep

Hi All.Could someone help how could I set up an object transformation from TaskTemplateWorkStep to PmActionWorkStep?My need is to transform an image from worktaskstep template to the pm actions and finally to a workorder. Also as I create a new revision from it.This is the transformation I’m using:TASK_TEMPLATE_ID=PM_ACTION_JOB_API.Get_Std_Job_Id(pm_no,pm_revision,work_list_no),TASK_TEMPLATE_REV=PM_ACTION_JOB_API.Get_Std_Job_Revision(pm_no,pm_revision,work_list_no),WORK_LIST_NO=ROW_NO,WORK_STEP_SEQ=pm_action_work_step_seqTrying to do but getting the error bellow: Tks a lot Server error messages:580416c0-2cbc-4384-b02a-337d04fabb24Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06502: PL/SQL: numeric or value error: character string buffer too smallFailed executing statement (ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at line 16ORA-06512: at "IFSPET.OBJ_C

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

MWO Aurena Assignment Start/Work Start cannot be later than Assignment Finish/Work Finish

Hi All,Does anyone know about this situation? The start time is not greater than the finish time, but I’m getting a faield transaction.Using apps10 UPD14, mwo maintenance 10

lopespetroHero (Customer)

asked in Service (Touch Apps, MWO, MRO)

MWO MAINTENANCE 10 failed transaction

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.

lopespetroHero (Customer)

asked in Assets (Asset Management)

Calendar days Aurena permission

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.

1
2
3

Page 1 / 3

Badges

jeckyjonhas earned the badge 1st Topic
carlbhas earned the badge 1st Topic
mghahas earned the badge 1st Topic
VirajWhas earned the badge 5th Reply
Yasanthy Kanagarajhas earned the badge 1st Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK