Solved

Hi All, I am trying to test Push Notifications from the application(ServiceEngApp - Windows) as well as using Mobile_Push_SYS.Send_Notification.I can see Push Notifications from Aurena User Log.However, I cannot see any Push Notifications from the mWO app.Notification Parameters have default values.Any thoughts?Please refer attachments for further info. 

While updating Event Builders from ETM, not able to find usage field under “Record to update”.Is there any work around? Example:There are 2 Event Builders with everything same except usage. How can we discontinue Event Builder with particular “usage”?

Is there a way to identify user who are actively logging in and using the application.  Basically, i’d like to know who has logged in during the past 6 months.

Hi , I need your recommendation for a partner /vendor to provide IFS SLA support for 1 year in KSA Jeddah . Please share your opinion in the thread or whatapp +966555230144 .  Thanks  

Hello , I need to get the status of the approval of my customer ( approval routing has been set ) but i can’t seem to find the right way to do it .To be more clear , I have a routing approval that I copy each time a customer is created so in the key ref I dont have the customer_ID ('CUSTOMER_ID=&OLD:CUSTOMER_NO^')How can I recognize my customer so that I can query on approval_status in IFSAPP.approval_routing tab. Thank you ,Hanane

Is there a way to hard delete discontinued Event Builders? We are trying to do that from ETM but getting Privileges Error:You are not permitted to perform this action. Type: PrivilegeException.

Hi,I am currently testing a new API connection.One of values is passed as an attribute and not as a child element.     <content>            <function controlid="12345">                <create> Can anyone tell me how I can replicate this in the XML Mapping. RegardsAdy

When creating a new Customer Support Order based on a Serial or Tag, we expect an Open Calls Lookup to appear. It seems that this only appears if a serial match is found and selected from the list.The Open Calls Popup will not show if a valid Serial or Tag is entered, and then the enter key is pressed. It will show up if the Serial or Tag is entered and selected from the dropdown list, or if the item in the dropdown list is highlighted and then enter is pressed.Is this expected behavior, or a bug?https://x3200.media/DuplicatesBug.mp4

Hello,Is there a way to delete a Service Resource after it is created in Cloud? We are able to modify certain information but there is no option to delete a Service Resource. If the record was created using a wrong Resource Group or Site, we are unable to delete and recreate the resource.Please let me know. Kind RegardsPriyanka Cecilia

We use a three-character “location” id for Divisions (with Divisions segregated into Datasets), and want to display that three-character info on PSO Scheduling/Resources screen for each Resource.Unfortunately PSO enters a geocoded “city/state” under location, and it doesn’t appear that within Admin/Org/lists that we can get a Division label to display the three-character code.Under Planning/Divisions we have a label with the three-letter code, but can’t seem to make any association to display this under Scheduling/Resources.We use FSM to PSO, using ARP.Any shortcut way to get this automatically populated in a Division label (List) in PSO Scheduling/Resources?Thank you.

When the RMB “Validate Tax ID number” on Supplier>Address>Document Tax Information intermittently hits the below error.Tax ID Number ******** cannot be validated due to network problem.Further investigations:The error mostly occurs when the action performed perpetually The validation actually executes via the client (tbwSuppDocumentTaxInfo.cs) Looks like a client limitation (threshold for MS_MAX_CONCURRENT_REQ)Has this every happened to you?Any clue will be highly appreciated.Thank you. 

Hi,Is it possible to make changes to the calendar in the IFS FSM mobile app? Like adding tasks for example.  

Hi,I get the following oracle error message in ‘Customer Invoices with errors’ window since 3rd May. ”ORA-01400: cannot insert NULL into ("IFSAPP"."CUSTOMER_INFO_ADDRESS_CFT"."ROWKEY")” I have added a new custom field to CustomerOrder LU on the same day. Only CUSTCOLDEB (debit collective invoices) shoots out this error.Code in new CFSELECT 'Företag - Återstående limit' || CHR(13) || CHR(10) || cl.comp_limits AS "Företag och återstående limit"FROM (SELECT LISTAGG(COMPANY || ' - ' ||               CASE WHEN CREDIT_BLOCK = 'TRUE' THEN 'STOPPAD'                   ELSE TO_CHAR(ROUND(NVL((SELECT remain_credit1                                             FROM IFSAPP.customer_credit_collection_qry q                                            WHERE q.identity = c.identity                                              AND q.company = c.company), CREDIT_LIMIT)), 'FM999G999G999')              END, CHR(13) || CHR(10)) WITHIN GROUP (ORDER BY COMPANY) comp_limitsFROM IFSAPP.CUSTOMER_CREDIT_INFO_CUST c

Hello,I am looking for some input and see if someone can help me find a solution for the below PL/SQL Block that is used for a Right Click Menu.The blow Block is supposed to fetch 2 tables and then if a value is not in the Customer order table to add them in the 2nd custom table (CUSTOM LU) and ensure there are no duplicate records created. DECLAREp0_ VARCHAR2(32000);p1_ VARCHAR2(32000);p2_ VARCHAR2(32000);p3_ VARCHAR2(32000):= NULL;P_ORDER_ VARCHAR2(32000);P_VIN_ VARCHAR2(17):= NULL;C_ORDER_ VARCHAR2(32000);C_VIN_ VARCHAR2(17):= NULL;CURSOR PLANNED_VINS ISSELECT DISTINCT &AO.CUSTOMER_ORDER_LINE_CFP.Get_Cf$_Planned_Vin(objkey) FROM &AO.customer_order_line WHERE ORDER_NO = &ORDER_NO and &AO.CUSTOMER_ORDER_LINE_CFP.Get_Cf$_Planned_Vin(objkey) is not NULL ;CURSOR CHASSIS_TRACKER ISSELECT DISTINCT CF$_FULL_VINFROM &AO.C_L_U_CHASSIS_TRACKER_CLV WHERE CF$_ORDER_NO = &ORDER_NO and CF$_FULL_VIN is not null;BEGINOPEN PLANNED_VINS;OPEN CHASSIS_TRACKER;LOOPFETCH PLANNED_VI

Hi,Anyone knows how to clear send error messages? This customer has been setup as internal customer to send e-invoices but company AS has a default Document Address with zip code and city. The vouchers of these invoices have already been posted to GL but still these errors do not clear.But error says:1) Company Document Address must have a value.2) Company Document Address Zip Code must have a value.3) Company Document Address City must have a value. Appreciate if anyone can advise? Thank you in advance!RegardsNimesh

I am facing following error in database background job1)Job Name: Set Original Latest Finish custom field value. .2)Error Text: The Event Action "Execute Online SQL" on "WT_ORG_LATEST_FINISH_BJ" has failed. Please contact your System Administrator to manage the Event Actions. ORA-01400: cannot insert NULL into ("IFSAPP"."JT_TASK_CFT"."ROWKEY") ORA-20105: FndEventAction.EVENT_ACTION_ERROR. 

Hello,I have recently created a workflow that sends a text only user task to alert the user when a shipment has attachments that need to be printed off.The event and event action I have created for this sees when the shipment_tab’s del_note_printed field has been changed, and if it has, trigger the workflow. This event action was able to be turned on before I added the user task, but now I’m getting this error.What kind of error is this and how do I address it? Should I be using something else other than a user task to alert the user? They dont need to input anything, they only need to see the notification.Any and all advise would be greatly appreciated.Thanks,Bryan

A lot is been issued for multiple lots. After issuance there seem to be a non-conformance. The customer would like an easy to approach to create one NCR/MRB for the entire lot.Like your feedback and similar experiences with clients ?

Hi IFS Community,does anyone have a solution to export csv file without line breaks?I’ve seen topics about line breaks for data import but not for data export.I guess we need to replace line breaks with IFS but I can’t do that with the procedure CREATE_OUTPUT_FILE.There is no transformation option on FILE MAPPING tab.Maybe we need to use a rule like CALLEXTPROC (Call external procedure after each row) but I didn’t found information about this.If I have a solution to replace line breaks it will be possible to replace semicolons too and build a clean csv file.Migration Job RULES tabThanks

Refer to following “Quick Report” query which is taking 10+ minutes or even timing out on some occasions. Any ideas on increasing performance of this SQL query? SELECT DISTINCT sp.activeind, sp.catalog_desc, sp.catalog_no, sp.cf$_last_modified, sp.contract, sp.gtin_no, sp.List_price, sp.List_price_incl_tax, sp.sales_price_group_id, sp.sales_unit_meas, spc.cf$_last_modified AS char_lastmodified, spl.last_updated AS SalesPrice_LastUpdated FROM Sales_part_cfv sp LEFT JOIN Sales_Part_Characteristic_cfv spc ON sp.contract = spc.contract AND sp.catalog_no = spc.catalog_no LEFT JOIN SALES_PRICE_LIST_PART_PRICE spl ON sp.catalog_no = spl.catalog_no WHERE sp.contract = '201' AND (sp.cf$_last_modified >= '&datestring' OR spc.cf$_last_modified >= '&datestring' OR spl.last_updated >= TO_DATE('&datestring2', 'yyyy-MM-dd')) 

Hello,Can we have a high level daigram for IFS Cloud - K8S cluster.RegardsPankaj

Trying to get highest 20 rows of the below query based on “Net Amount in USD” column which is a sum column. Any clues? select  INVOICE.IDENTITY as "Identity", supplier.vendor_name,to_char(sum(INVOICE.ACTUAL_NET_DOM_AMOUNT), '$999,999,999') as "Net Amount in USD" from &AO.INVOICE inner join&AO.supplieron &AO.Invoice.identity = &AO.supplier.vendor_nowhere   INVOICE.OBJSTATE <> 'Cancelled' group by INVOICE.IDENTITY,vendor_name 

Hi All,Requirement:In ‘Receipt’ screen ‘Receipt reference’ is an IFS standard field and ‘Gate Entry Reference’ field is a custom field (persistent type). (Please check image1, fields highlighted in red boxes, ignore the blue boxes 😊 )image1 I need to create an event when user enters value(add/change/delete) to ‘Gate Entry Reference’ custom field. then the same value should be updated to ‘Gate Entry Reference’ field of other records having same ‘Receipt reference’ field value.Please help me to create this event (the event action) Thanks in advance.Best Regards,Hari

Hello my friends,We are using IFS 9upd4. Users only work through IFS EE. Making IFS more useful; We need to increase interest and relevance. There are many apps for sales or warehouse staff in apple and google store. Can anyone share the full list of these apps? Also, do we need anything extra to use these apps? Who can help with this issue?You should describe not only mobile applications, but also all kinds of add-ons that will facilitate the use of IFS, together with its use, under this post. Anyone who needs guidance can follow this post. Thank you for your interest. Thanks,Barış

Hi all,I have a problem on ms level 1 part.  After I entered customer order and ms forecast, I run ms one part. And some ms supply that within PTF turned to fixed status. Up to now all is ok however to see in detail the fixed row I right clicked on the fixed row where the ms level 1 part --> Supply and Demand page (type:ms supply) unfurtunately Supply Demand Details was inactive to click on the menu. What could be reason not to created  a shop order requisition by MS? To create shop order requisition what can I do?Thanks…