Solved

HiI got an error with the below  line in red when execute. Any clues please. select X.*,IFSAPP.SUB_PROJECT_API.Get_Description(x.PROJECT_ID, x.SUB_PROJECT_ID) Sub_Proj_Des,x.budget_base_curr/120 ITD_BUD,x.actual - ITD_BUD as  "Deviation",IFSAPP.ACTIVITY_API.Get_Description(X.ACTIVITY_SEQ) activity_des,IFSAPP.Project_Forecast_Item_API.Get_Project_Cost_Element_Desc(x.FORECAST_ID, x.PROJECT_COST_ELEMENT) cost_elm_desfromproject_forecast_item_all Xwhere project_id = '20062' and forecast_version_id = 'M1003' RegardsHousseiny 

For a single user the coordinator is not auto-populating. In the prepare work order screen, CO information tab, the coordinator does not fill in automatically.  The default coordinator is setup for the user on site.

Hello, The IQA button does not appear on the web client. It seems like the functionality is limited to the Smart Client. I am using release 6 and update 23. There are a couple of FSM client scripts that hide the IQA button (REPAIRCENTER_HIDE_IQA and REQUEST_HIDE_BUTTONS).Is there any chance of this functionality being made available in the web client going forward?  ThanksRegardsNeville

Hello, I am attempting to have Business Opportunities automatically close when it passes their expiration date. I have used workflows and scheduled database tasks before, but there does not seem to be a way to create a database task to schedule it to run every day to check for expired Business Opportunities, and there does not seem to be a way to schedule a workflow to run every day. I’m not aware of any projection actions or event actions that get run every day.What can I use to achieve what I’m looking for? Any and all advise would be greatly appreciated.Thanks,Bryan

Has anyone come up with good ways to enable alerts/notifications using the IFS Assyst Mobile App?We have support personal who want to be alerted especially during off hours whenever a high priority incident or outage occurs. So, we want a push notification not simply that they check email on a regular Candance. 

Hello, I am attempting to trigger a workflow via a database task, so that I can schedule the database task to run daily. My end goal is to have a workflow that gets triggered every day. It does not need parameters.Is this possible with FND_WORKFLOW_CONNECTION_API.START_WORKFLOW? I am creating a database task to use this method. I am not sure what it’s asking for, for its parameters. Would anyone be so kind to provide an example of the formatting this is expecting?Any and all advise would be greatly appreciatedThanks,Bryan

I am trying to set up a survey in IFS assyst using an event query. When I run the query in event monitor, it returns a list of events, with then Affected user field populated.When I add the query to the survey, and click on Issue Request, i receive an error “Event Query returns no users.”Am I missing something? 

Hello, How can you get Business Opportunities to automatically close once their expiration date is equal to the current date? This seems like a pretty basic feature but there doesn’t seem to be any options available on IFS Cloud

Hello,How would you set up emailing to notify a customer when a Business Opportunity or Sales Quotation has expired? Any and all advise would be greatly appreciated. Thanks,Bryan

Hello,What is the purpose of the expiration date for Business Opportunities? Do they auto close once they go past the expiration date? if not, how do I get them to automatically do this? I have a scheduled database task that uses the “Set_Closed” method of the Business Opportunity API but I cannot set this to only occur when the Expiration date = SYSDATE. This results in an error that makes IFS think the opportunity is already deleted, because its not coming up with a result. Any and all advise would be greatly appreciated.Thanks,Bryan

Hello,I would like to set up a process that notifies the customer that their Business Opportunity is going to expire in a week, 5 days, 3 days, and when the BO has actually expired. I can set up an event action to handle when a field has changed… so I’m thinking about having a daily database task that updates a custom field that represents how many days until this BO expires, and basing the event off of that.My only issue is the email portion, for the Business Opportunity, the contact email is not available for the entity. How can I set this up so that field appears on the BO? Obviously IFS has the entity connection set up since the Contacts appear on the BO page, but I cannot access that BusinessObjectContact entity from the BO entity, to add in a custom field that references the email.How should I approach this? Any and all advise would be greatly appreciated.Thanks,Bryan 

Hello,I’ve been looking for so many ways to execute a workflow on a daily schedule for IFS Cloud. There have been some IFS Employees that have mentioned that they don’t know how to, but I still want to believe there is a way to do this. I am trying to close expired Business Opportunities and Sales Quotations by running a workflow I built. I also would like to send an email out when Sales Quotations and Business Opportunities are 7, 5, or 3 days away from expiring.Is there any way to accomplish this? It seems like IFS Cloud is so limited in what you can do. In Apps10 you had some workarounds for accomplishing this but it seems like there is no way to do this in IFS Cloud. Any and all advise would be greatly appreciated. Thanks,Bryan

Hello Everyone, There is a requirement to send Attachments  with the same email of the Purchase Order’s Print Order...The mail should contain the attachments of the Purchase Order as well as the Purchase Order report.This should be happen only if the attachments are in specific document classes eg: 4600 - 4699.This should be work in Aurena as well. Please let me know if you have any idea of how to do this.  Many Thanks,Denuka

I have done some changes to the list of my work for mWO in the past. I made the changes in the context global (understood: discussable). Now I want to make another change and there is no content available:Three dots below Content show the Order by option, which has a grey > sign which means nothing there as well.I do have a page configuration that is published: I see the work done, in the past, in mWO. If I unpublish the global context I see the standard overview in mWO on the MyWork page.Anyone an idea why I don't see any content?

Hi,I have added Command Group in Automatic Tax Proposal projection to generate a report. When executing the action, it is giving an error saying “14:24:04 ERROR - line 2, column 2: (Server Error) Database error occurred. Contact administrator. undefined14:24:04 ERROR - Command error: (line 2, column 2) - , details: undefined undefined”Method has two parameters and values are passing correctly. To make sure parameters are not causing the error, I created a test method without parameters and attached to Custom Group. It is still giving the same error.Any suggestion to rectify the issue is appreciated.(custom RMB created in EE works fine with the same method)Thank you.

What does this mean? We have created the Quotation, updated all the Work Orders and Task Information, calculated the costs etc. but when trying to Release the Quotation this is appearing? Thanks, 

Hi IFS community, We would like to add a small message to the tax code so it would appear on the customer invoice which we create via Instant Invoice tab.How is it done? Please see the picture below to see what I am talking about. Thank you in advance. 

Hi All.Does anyone know how to change this sort to MchCode asc, not Mchname?Using Apps10UPD17 MWO Maintenance 10There is no option to change the field.Tried to add another Orderby item but it’s not working.Tks.Br.Lopes

Hi, I am looking for any best solution for below case. ( mapping in IFS)we place PO to supplier A ( 10 m, bar) and asked to delivered to supplier B location.we place PO to supplier B ( supplier B uses the 4m bar , supplied by us from supplier A and deliver the final material)  ( remaining 6, bar will be lying in supplier B place and uses in next PO). how we can track material locations/ remaining qty/paper work - sending material from supplier A to supplier B)Thanks

Hello,We’ve changed some of our parts to be Primary Supplier Transit on their Sales Part Record. We have Customer Orders currently in the Planned state that contain these parts. I had assumed that if I change the Supply Code of these parts on the Customer Order to be Purch Order Trans, that their PO’s would be automatically created when the job was released. I’m finding that this is not the case. Automatic PO creation was working in our TEST environment if I created a new Customer Order with the changed parts on them and then released the Customer Order. The automatic PO creation just doesn’t seem to be working on Customer Orders that were already created before the parts’ Sales Part sourcing option was changed. Anybody have any ideas?

During the Cloud Launch in 2021, Stephen Jeffs-Watts did a presentation of the future plans for FSM in IFS Cloud.https://info.ifs.com/cloud-launch-on-demand-videos.html?_ga=2.18333948.478674707.1616167306-1371162318.1616167306&wchannelid=h0gd1m5rp6&wmediaid=otkpwg9w5d#ValueAs the final stages of development, Depot repair and Reverse logistics was scheduled for Cloud 22R2. What is the present status?  (Se presentation: 3:25 – 7:00)

Hello,Checking if this is correct in our version IFSAPP9.The PO order quantity was reduced manually by the buyer after partial receipt to match the quantity received, but neither the PO header nor the line item closed automatically. Both had to be closed manually by the manager.Is it because of the manual change in the PO qty after the receipt?Normally, for us, when the quantity received is equal to the PO quantity, the PO line and the header closes automatically. Angelo DiSipio

Hi,    I am working on a SQL query related to  view PROJECT_FORECAST_ITEM_COST. When opening the project forecast, there is a SQL column address as “&AO.SUB_PROJECT_API.Get_Description(PROJECT_ID,SUB_PROJECT_ID)”. How do I include this column in my SQL query with PROJECT_FORECAST_ITEM_COST table?I would like to understand how API works in general as well when it comes to SQL queries.  Many thanksHousseiny

Hi All,Can anyone support me on how  to get sum of last month closing balance and current month closing balance to one column in Business Reporter.Thank You 

Hi There,I have created a Purchase requisition authorization rule and routing templates, and for some reason all my routing steps are not being displayed on the requisition or routed as per the steps. I’m at a loss for what I may have missed. What could I be missing that I am not seeing by chance?I have been under the assumption all steps will show especially if I have “Include All Steps and Consider Limits” selected on the auth. Rule general tab. Auth. Rule 1 - Priority 1 <$500k - Maximum amount $500kRouting template linked to auth. Rule 1, using project roles, all with auth. limit of $500kStep 10 Step 20 Step 30 Auth. Rule 2 - Priority 2 >$500k - Min $501k to Maximum amount $10mlRouting Template linked to auth. rule, using auth. groups, all have max auth. limit of $10mlStep 40Step 50 Once the requisition is released only the following steps appear when I need all the steps 10-50 to appear (Screen shot below)Step 30Step 40Step 50