Solved

When do you plan to release the Excel-add in data migration tool with Apps10 Aurena Client?

Hi,I’m trying to raise an error to a Background Job.I have a procedure that is called by a background job.I’ll fetch an object, and sometime it doesn’t exist. Normally because the object is deleted by the user before the job has been run.    CURSOR get_Objid IS      select objid from project_transaction WHERE objkey = 'BB8A4E9B030B41DDABB62F8381C9DFFD';    OPEN get_Objid;    FETCH get_Objid      INTO objid_;    CLOSE get_Objid; I would then like to handle the exception and have a custom error message send back to the background job. So I use this one:    IF (objid_ is null) THEN        raise_application_error(-20001,'No value in objid!');    END IF;It works find when running the script in a terminal, but if I run it with a background job I don’t get the error.How can this be done?BR Kresten

Hi,Can we remove the post button from the Out of the Box FSM Mobile Stock Count Screen? As we don’t want our technician to post the stock Count.Can we do this with the New custom screen? Any help would be much appreciated !!!

In our production process we would like to have a different routing after each 50 units which are produced. This alternate routing should send the produced items to an external control center (outside operations) is there a way to implement the requested process in standard IFS. The lot size will not be higher than 10 pcs at the time. So, the alternate routing should be triggered based on the cumulative units produced.

Hello,I am attempting to create scheduled count reports that display 10 records per report. The issue with this is that most of the rows in every count report are for zero quantity part numbers / locations. Is there a way to exclude the zero quantity records? Thank you,Matt

When trying to update a record using the API for any Custom LU (_CLT table in IFS), we get this error. ERROR: MODIFIED2: The ‘LU Name’ object has been modified by another user. Please refresh the object and reenter your changes. The error is saying that a record can't be updated because it is already being updated, which is not the case. This happens regardless of which table the triggering action is coming from. The update method that is called using the API is 'PackageName'_CLP.Modify__( ). This modify method is auto generated when the Custom LU is made. We have verified that the New__ API call for inserting a record does work correctly for Custom LU tables, but the Modify__ or Remove__ API calls do not.To be clear, we are able to call the API methods to Update, Insert, and Delete records from IFS standard tables, (tables ending in _TAB), as well as custom field tables, (tables ending in _CFT) but we are having this issue with the tables made from Custom Logical Units, (tables ending

I have customers whose IFS Applications installations are on MS Azure VM, not IFS managed cloud.Now I should propose "backup strategy" to these customers. Since Azure VM is totally different from local servers, I wonder what resources should be backed up and how often.Could you please share your opinion about Azure VM backup?Thank you.Kazu

what in the line codes advise whether or not it is something to be sent to the voucher when being billed?i have billable unchecked but it still gets billed. We have codes that dont go over and we’ve done identical settings but they still come over. 

In FSM Mobile how  to configure the mobile db to shared NAS Drive?In FSM, Mobile_Database_Directory is set to the server default path like ‘C/inetpub/wwwroot/xxxx/mobiledb’ . Is it possible to set the Mobile_Database_Directory to the NAS drive mapped to the server. So the user db will be created in the Nas drive.?  

We use APPS 10 and IEE.  I am a new IEE admin.   I have a user that is requesting to have a couple of additional columns added to a view.  In this case it is the Fixed Asset “Object Balances Analysis” view.  The Columns exist in 2 other views:  “Depreciation Method” and the Fixed Assets > Object “Estimated Life” column.   The IEE Admin training did not cover this.  I am looking for any good information on adding data (columns) that already exist to other views.Thank you kindly for any info you can provide.

Hi,IPE is available to IFS partners, isn’t it?I’d like to know the cost of IPE for our customer projects. Could you please let me know what department of IFS I should ask the cost?Thank you.BR,Kazu

Hi guys,I’ve created a custom projection to which I’m attempting an authorized request via postman. I received the token using the ROPC method stated hereHow I got the tokenHow I’m trying to use the token (request is made to the int cluster), AS you can see, I’m getting a a 401 Unauthorized response. ​​​​​​​I use I tried using both Bearer and OAuth2 in postman and still ended up getting this. When I use basic auth and enter ifs credentials, I can access the projection data (I see the JSESSIONID cookie is returned when using basic auth, and this is what makes the difference).Am I doing something wrong here? or is OAuth2 not possible with projections?Cheers,Miraj

Is there any way to use dynamic component dependency if the component I am depending on is customized component and it is not installed.If the dependent component is customized and not installed then there would not be any component_<modulename>_sys package.In this case what needs to be done?

Hi,Once user click on the image, I need to show users’ info in employee file. After I set URL address, it directs to the Employee File window. But not showing users’ record. How to pass a parameter for the emp_id 

Can someone tell me what is the exact issue behind this type of error being displayed?No custom field or tabs are attached to it?

Does any one know how i can adjust the below SQL so that it rounds to the nearest whole number. i am trying to see 10% of records to count a month. Below is current SQL  I have tried adding Round in the front but it wouldnt work (CASE WHEN LAST_COUNT_DATE >trunc(to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' )) THEN '0' ELSE '1' END) *.10  

We are running IFS Apps10 UPD8 (planning to go to UPD10).  I’m looking for some ideas on how we can get IFS to support both the Canadian EFT format and the US ACH format for supplier paymentsBackground - we are in Canada.  And the Canadian EFT file format does not match the US ACH format.  The 2 do the same thing, but have different file formats. When we implemented IFS Apps8 SP1+, we needed a way to build the bank’s EFT file to upload to their site for electronic payments.  At that time, the recommendation was to write logic to redirect the ACH selection to our defined EFT format.  We uplifted that code to Apps10 when we upgrade.Fast forward - our finance department now has a need to do both EFT and ACH payments.  Our current solution is an either/or (either EFT or ACH, not both).I’m looking for suggestions on how we could design a solution so thatWe can revert to standard IFS ACH We can continue to create EFT payment files - in the format we already have setup We can keep (either as

Can someone help me rectify this query? Using Oracle 12CTrying to Pick Latest Activity date for each Customer Per state to use as subquery to gather rest of the dataHere is example data Customer_no State Activity_date 110913 CT 8/2/2019 110913 MA 9/22/2020 110913 MA 11/23/2020 110913 MA 11/23/2020  Desired result  Customer_no State Activity_date 110913 CT 8/2/2019 110913 MA 11/23/2020   The query I write  is following: looks like max() can’t pick one from same activity_dateDistinct is also not working… select customer_no,tax_State,max(activity_date) from table   where customer_no ='110913' group by customer_no,tax_State and it bring this data  Customer_no State Activity_date 110913 CT 8/2/2019 110913 MA 9/22/2020

Hi,I want to add a custom field to the Shipment Lines.This field needs to refer to the field ‘Customer PO No’ on the header of a customer order. I did build a SQL query to fetch desired field:SELECT c.customer_po_no FROM Customer_Order c, Shipment_Line s WHERE c.order_no = s.source_ref1 I don’t know what I need to add in the field ‘Arguments’. Can someone help?  

We use IFS Sales Quotations. Sometimes when we are printing them sharing internally, we need the price figures in it (Price, Net Amount) hidden or zeroed. We wouldn’t want to change the value in IFS to zero. Is there a way I can achieve it only when I am printing the report? 

Hi, We are having an issue with the contributions tab in payroll info where it is randomly suspending contributions when a future date is entered but is not then activating when it reaches the future date. This isn't happening consistently so just wandered if there is some set up missing somewhere, has anyone come across this? We are using Version 8 SP1. Thanks 

Is there a way to prevent special chars from being entered into IFS fields by users? For example, percent sign %, ampersand &, underscore _, etc. I seem to remember there being a basic data / system setup screen in IFS whereby you can list characters which you want to be “disallowed”, but I don't remember the name of the screen that holds this system setup/ basic data setting, and haven't been able to find reference to it in the help system. Thanks in advance,  

In IFS Apps 8, is it possible to create a PM elimination when both events are calendar based?  We have a PM trigger every 3 months for a minor vehicle service.  We also have an annual major service once a year so don’t want the minor vehicle service to trigger at the point the annual major service is triggered.Thanks in advance for any assistance with this.

We are converting some checklists that manufacturer require from us into surveys. However some of them NEED signatures. Is it possible to add the signature option to a survey?

Hi,Is there a place in community where we can suggest New functionalities? and based on the suggested functionality, everyone can vote and if the functionality get the highest votes, it will then be included in the next release or updates?