Solved

Hi All, Is there a mobile app for purchase approval on IFS, similar to the MWO for the engineering mobile app.

Dear All,   IFS recommended Oracle full DB cloning procedure <STEP by STEP>. Following DB Back-up and Restore process. How to take a DB back-up from one envorinment <STEP by STEP> How to restore a DB to another envorinment <STEP by STEP>   Thanks in advance.   Regards, Vivek NR.

We are looking for a way to limit access to confidential PO’s.  Is there anything other than company and site that can drive security roles?  Maybe a PO type or group?

Hello! I’ve a scenario in CRM where there a 3 users. CRM User 1 (only has access to Business Lead) CRM User 2 (only has access to Business Lead) ADM User (has access to leads created by CRM User 1 & CRM User 2. Additionally, has access to Customers/ Customer Orders). Now, CRM users only have to create the lead and perform business activities. The conversion of lead to customer and then creation of customer order is assigned to ADM user. But at the same time, ADM user must not be able to view all of the Leads, Customers as there will be other groups with 1 ADM & 2 CRM users(to achieve this, I’ve added the ADM user to Lead, Activity, Opportunity & Customer filters using Access Group). CRM users have to add the ADM user to each of the lead/ activity they create manually, so that it may be available to ADM user. (This is kind of a site based crm scenario which I’m trying to cater through Access Groups.) Is there any option to auto-add the ADM  users (supervisors) to each entry

Does anyone have a decoder ring for database objects as to what the symbols and colors mean? Some text is blue, some is black, some have a diamond that isn’t filled and others it’s filled. My assumption is that it means either granted or only granted query, but it would be nice to know for sure what it all means. Thanks!  

How to make  make in report designer simple condition/rule what to show value from another field if one is empty. Two variables CV_PART_NO SO_PART_NO I’d like to get one field condition that if CV_PART_NO have value, use that, other wise SO_PART_NO like in plsql NVL(CV_PART_NO,SO_PART_NO)

I have the following code, that updates the required date on Project Navigator Demand based on a custom field. It runs fine as a custom menu, but when i run it as an event on creation of a new demand line, it crashes with a mutating trigger error. I believe it’s because I’m selecting info from the table I’m trying to update. Whats the best way to get this to work? TIA.   PROCEDURE Update_ProjMiscDem_ReqdDate(MATR_SEQ_NO_ IN VARCHAR2) IS attr_              VARCHAR2(1000); info_              VARCHAR2(1000); offset_            NUMBER; objid_             VARCHAR2(1000); objversion_        VARCHAR2(1000); CURSOR get_parts IS SELECT p.objid, p.objversion, p.activity_seq FROM project_misc_procurement p WHERE p.matr_seq_no = matr_seq_no_; BEGIN info_       := NULL; OPEN get_parts; FETCH get_parts INTO objid_, objversion_; CLOSE get_parts; offset_     := work_time_calendar_api.Get_Work_Days_Between('*',                                 activity_cfp.Get_Cf$_Receive_Parts_By(activity_cfp.Get_Objke

when creating an IFS user how to select an oracle profile, by default it is selecting the oracle default profile, I have created an oracle profile to use password verification function. when I create a new IFS user I would like to select the oracle profile I have created instead of the default Oracle profile

Hi, I am doing some Report Designer changes to a layout and struggling adding a new table. I want to add a table in between existing two tables, but new table always goes to end of the Page Body. How can I move the new table where I want? Appreciate your comments.   Thank you.  

Between application 7.5 (or 8?! I am not sure...) and 9 I have seen a difference regarding object transformation. In the old release of IFS application an entry was made in the object connection list if a document was passed on from a source LU to a taget LU. Now it seems to be only displayed online. Can someone explain the benefit?

I tried a function ‘Amounts to words’ in report designer and I used like below ‘vldtmath:amountToWords(tns:NET_CURR_AMOUNT,'ar',tns:CURRENCY)’. When I used for german language code or other language codes its translating and showing in mentioned languages but when I tried in Arabic or Korean languages its is not translating in the report. if currency is 1000 means output for ar/ko : One thousands. Please suggest any solution or give me reason why its not coming in report.  

Hello,  I’m having an issue understanding the workflow in IFS as it relates to Sales Quote generation. Currently, we are starting the process at Business Opportunity. An opportunity line would be entered for a top line part, which would be saved as a Non-Existing Part. From there an Estimate is created for the part. The calculation is made and the Business Opportunity is updated via the connected object from the Estimate to the Opportunity. In order to create a quote, we have to register the part using Register Non-Existing Part in Business Opportunity. When that is done, you can then RMB the opportunity line and create a Sales Quote. The issue becomes when you need to change the quote for any reason, the Business Opportunity is not also updated to reflect the change. If you adjust Contribution Margin on the Sales Quote, that does not update the Business Opportunity. Additionally, if you need to modify the Estimate, when you update the connected object to the Business Opportunity, you

Hi! When a custom LU and fields are added, IFS automatically creates a package to insert, modify and delete custom data. Is there a way to safely modify e.g. CF_NEW__ procedure in the custom package to add extra validations? I assume the CFP package will be overwritten when e.g. a new custom field is added or reinstalled and all changes will be lost, so it is probably not straightforwad. Any ideas? Thanks!   Regards, Rafal  

I would be very grateful if someone could advise on the following: When we select In and then carry out the swipe, the employee id/name is not being displayed in the Welcome message and no records are being updated to Time Card.   Is there a way to debug Time Clock?

Hello Guys,   Does anybody have a doc/PDF or know any external link regarding creating a new RMB and link a report or window ?    Or If you can explain step by step also appreciated     

Under our part usage, i am trying to also add the description of the part which is unfortunately located in the part table. Since there is nothing connecting these two it cannot determine the path. i manually add it via the item path in the UI designer but it doesn't return any values. there are a lot of screens that i want to do this one. What would be the best way to go about this?    

Dear All,   Can we do the profile import/export of Aurena. If yes then how can we do the same.   Thanks in advance! BR, HA

Hi , I am trying to capture week numbers ( 1/1/20 being week 1 and 31/12/20 being week 52). This is so i can report breakdown time on a week to week bases and then display in a chart for, lest say 10 week and then see a trend. I have tried the DATEPART command  but with no success.   Any suggestions?     select JT_TASK_UIV.STATE, JT_TASK_UIV.TASK_SEQ, JT_TASK_UIV.ACTUAL_OBJECT_DESCRIPTION, JT_TASK_UIV.REPORTED_DATE, JT_TASK_UIV.ACTUAL_FINISH, JT_TASK_UIV.ERROR_TYPE, JT_TASK_UIV.PERFORMED_WORK, JT_TASK_UIV.SITE, JT_TASK_UIV.ITEM_CLASS_ID, JT_TASK_UIV.ACTUAL_START, JT_TASK_UIV.ACTUAL_OBJECT_ID as "Serial Object", JT_TASK_UIV.PRIORITY_ID, JT_TASK_UIV.DESCRIPTION, EQUIPMENT_SERIAL_UIV.MCH_CODE, EQUIPMENT_SERIAL_UIV.MCH_LOC, EQUIPMENT_SERIAL_UIV.MCH_POS, DATEPART (wk, JT_TASK_UIV.ACTUAL_FINISH) AS week from &AO.JT_TASK_UIV LEFT OUTER JOIN &AO.EQUIPMENT_SERIAL_UIV ON  &AO.JT_TASK_UIV.ACTUAL_OBJECT_ID = &AO.EQUIPMENT_SERIAL_UIV.MCH_CODE  WHERE STATE IN ('Work Done','Finished',

Hi,   i have issue about customization deployment. After f1 mage, the IFS 10 application does not download automatically. advice please. Thanks.

Is Oracle VMWare supported by IFS for IFS 10?

Does anyone know if there is  a way to create an outline around fields on a page?  There is an existing outline on the page but we want to create a new one for some custom fields that have been added.  This is an example of the out-of-the box outline.  We’d like to add one or more new ones.  

Hi, Are you able to advise how we setup automatic authorization of debit and credit postings on the Work Order tab?  We are using IFS Apps 8. Regards Shaun

I am trying to create a business rule that does the following:   When creating a task, look at the default brand on the request_unit and insert the correct template based on that model number. So if Default_Brand = FRANKE then put in FRANKE Task Template. I tried to do this  Right now - its putting it on all tasks. I figured this is because i set the value table name and column under the input properties. Must be just matching off all the table values instead of the request unit. The model/request unit isnt put on the task until AFTER the task is inserted so thats why im trying to look back at the request. If it was on the task before insert then this rule wouldnt be so much trouble

I have granted my user LTU_HR_SELF_SERVICE and FND_WEBENDUSER_MAIN but when I log into Aurena with my user and go to My New Expense Sheet I am receiving the following:     Can anyone please advise what I am missing?   Thank you

The Event is not able to send an email notification  Error While sending data… Caused by: SMTPSendFailedException: 550 5.7.60 SMTP; Client does not have permissions to send as sender