Hi All.Is there any solution for signatures from MWO (Aurena Natives - MaintEngApp), that are more then 32767k Clob field (since they are stored in Clob “Picture _Data”)?In data base shows OK or partial. But After convert to Blob, it does not show in crystal reports.Signatures under 32767k works well.Tks a lot for help FUNCTION Convert_Base64_Clob_To_Blob( clob_value_ IN CLOB) RETURN BLOBIS blob_value_ BLOB; raw_ RAW(32767); buffer_ PLS_INTEGER := 32767; start_ PLS_INTEGER := 1;BEGIN DBMS_LOB.createtemporary (blob_value_, FALSE, DBMS_LOB.CALL); FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(clob_value_) / buffer_) LOOP raw_ := UTL_ENCODE.base64_decode(UTL_RAW.cast_to_raw(DBMS_LOB.SUBSTR(clob_value_, buffer_, start_))); DBMS_LOB.append (blob_value_, TO_BLOB(raw_)); start_ := start_ + buffer_; END LOOP; RETURN blob_value_;END Convert_Base64_Clob_To_Blob; ========================================================= PROCEDURE Convert_Blob_To_Base64( clob_resul
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
Hi All.Could someone help with the situation that I created a Workflow Configuration but after sync it’s not working.Running apps10 UPD14, mwo maintenance 10. One thing I have noticed after investigation is that as I query the views, the site access is not visible linked to the configuration seq field. Please take a look in the prints. In the WORKFLOW_CFG_FILTER view, the workflow ID is there, but in access not. Am I missing someting thing or it looks like a BUG?tks a lot
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.
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.
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_COUNTERThe 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.
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
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.
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.
Hi,USING APPS 10 UPD12 - MWO MAINTENANCE 10 - 10.13.1360.0 after press complete button on mobile, fill out the fields, fault desc, Error cause desc and Performed work, the info does not sync to IEE and there is no transaction failed. If I fill out those fields from debrief screen, it works well.Any ideas what may it be?Tks
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,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;
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.