Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Hello, Starting a discussion on this topic as we seem to have uncovered a bug not previously noted on IFS community which is impacting SQL Quick Reports.  We have raised this as a case with IFS who are currently investigating.  In the meantime I am keen to hear from other customers on IFS Apps 10 Update 23 using EE who may or may not be experiencing this issue. Specifically, when running “SQL Statement” type Quick Reports the Parameter’s Screen is blank.  Previously this would provide inputs for the various parameters held within our SQL statement, such as Order No.  The SQL code from the reports has not changed, and this happens on all existing and any new reports created.  Crystal Report type Quick Reports are working, prompting for parameters correctly as expected.  I can confirm that the SQL code is

I am using IFS Apps10 and have a problem with Purchase Orders being emailed to the Requisitioner without them requesting it. It appears in the  requisitioner’s inbox with the subject “PDF file for Purchase Order report for result key <result key> is ready”When I check the Report Archive it says it was ordered by the Requisitioner but he has not ordered it. There is no custom event or scheduled task triggering it. I think it is occurring when the PO is closed but I am not sure. I don’t think it is occurring for everybody, just this one person and has only started occurring recently. The only way I am aware of that you can receive this mail is if someone sends it manually from the Purchase Order screen by selecting RMB-“Print Order” and then ticking the “Send Email to” box and entering an email address in the text box below that.I can’t see how it can be happening in an automated way., I have checked everywhere. I need to stop it however.

Hi, How do I get the date to be displayed with leading zeros in IFS Cloud? I would like the format to be 01.10.2023.Thanks!  

Hello, All- We are looking for feedback on preferences between Samsara & SmartDrive (and/or other software packages) that provide driver analytics.   This integration would include certification tracking as well as tracking for safety/discipline activities, maintenance costs, etc.  

Hi All,I would like to monitor special oracle users IFSAPP, IFSINFO and IFSDBREADONLY when users login using1. Aurena client2.Any database browser like Oracle SQL developer or PLSQL DeveloperI would to know their IP Address, location of the user if possible and other information like time, session duration etc.Customer is in IFS Managed Cloud so have limited options like lobbies, quick reports etc.How can we do that?

Customer asks if there is a possibility to translate the new item in Page Designer in Cloud to other languages. How to create the translation? 

We are trying to call the external rest API from the report rule but unfortunately don’t know how it will work.If someone already tried then please share how we can set it up. We already have an external rest api and that is working. We want the same working from the report rule. Report rule Application message but in error Thank you in advance for your help and support.

We have some problem to importing IFS Swagger files (OpenAPI V2), generated from API Explorer, into API Manager tool Sentinet (by Nevatech) that we are using.We get a lot of errors saying “uniqueItems is not a valid property at <and then the information about where the error occurs>…” We also get multiple errors with the error saying “The UriTemplate <see below example> is not valid; the UriTemplate variable named ‘Class’ appears multiple times in the template ….” for paths that look like"/SomeDataSet(Class='{Class}',Part='{Part}')/SomeSubSet(Class='{Class}',Part='{Part}',Item='{Item}')".Has anyone experienced this issue?Are the generated Swagger files from IFS fully compatible with OpenAPI v2 standard?

Our customer is using Apps 10 UPD 11 and is sending JSON messages to external REST endpoints. The JSON is generated as a PL/SQL document and sent via Plsql_Rest_Sender_API.Call_Rest_EndPoint. The message undergoes a transformation using an XML to JSON transformer.We have observed an issue where leading zeros in the JSON message are being omitted during transmission.For example:XML message:<Barcode type="Text">0123456789</Barcode>Receiving Json:"Barcode": "123456789"During debugging and sample unit testing, we confirmed that the transformer functions as expected. However, by the time the message reaches the endpoint, the starting zeros are no longer present. I have found sim

I am getting a “Comparison method violates its general contract” error when running the installer for IFS Developer Studio 18 that prevents it from working:  I obtained the installer from this website: https://developer.ifs.com/tools/devstudioI’ve spent hours trying to get the installer to work, but I have not been successful. I have attached the log file for the installer (please see the attached IFSDeveloperStuidoInstalllFail.txt), and the stack trace for the error begins on line 233. 

Hi All, I found an issue about the searchcontext.Please refer to the following steps to reproduce the issue. Do you have any solutions? Thanks!check the box of "Show Only Valid Rates"Create a new record and set a future dateuncheck the "Show Only Valid Rates", all the records were shownBut when checking 'Show Only Valid Rates,' the new record, which is an invalid rate, was still shown.

I have a Workflow on the TravelExpensesManagerHandling projection.  It is invoked via a button/command.  Whenever I want to undeploy the Workflow to change something, I’ve always deleted the item from the Commandgroup in Page Designer in order to allow the workflow to be undeployed.  As a result, it has to be recreated in Page Designer each time the workflow is redeployed.  Is there a way to just “disable” the command in order to allow it to be undeployed so it doesn’t need to be recreated each time? On 23R2SU10 currently.

Is there some setting that determines how many decimal places apply when a user exports to Excel?  User exports Customer Order lines - prices appears to 4 decimal places; I do the same and prices appear to 2 decimal places?   Thanks!  

Will there be a future release with the ability to choose to sort Purchase Req lines by Supplier Name?  Our Buyers are somewhat put out by the Account Number/Supplier Name concatenation.  We are on IFS Cloud 23.1. Thanks 

Hi all, When I would like to stop a background job that has executing status, I get an error message which is "Job does not exist". How can I stop the background job via PL/SQL developer? ThanksOzge

I am getting an error when trying to navigate to a page from a lobby element. When I check the sql query, it seems to be ok and I can get the data from the database correctly. But when I click on the lobby element, it says that some columns are invalid identifier.An example:I have this element. When i click on the preview button, i can see the data:This is the SQL query:select CF$_EXPLANATION,  CF$_MODE,  CF$_DATE,  CF$_TYPE,  CF$_CREATED_BY,  CF$_MOORDERNO,  CF$_MO_ORDER_NO,  CF$_ASKED_PERSON CF$_QUESTION_ISSUE,  CF$_ORDERNOfrom  &AO.REVISIONS_CLV.REVISIONS_CLVwhere cf$_type ='Question'and cf$_o

Hi community,since updating the report designer to the current version, we receive the following error message when opening one layout. The layout then closes again. What does this error message mean and can the error in the layout file be corrected? RegardsAndré

Hi, I got error when trying to query data from ProjectTransactionsHandling.svc. One of the parameter I want to filter is TransactionSource. However, I got below error: {    "error": {        "code": "ODATA_PROVIDER_ERROR",        "message": "An internal server error occurred. Contact administrator.",        "details": [            {                "code": "TYPES_NOT_COMPATIBLE",                "message": "The types 'IfsApp.ProjectTransactionsHandling.TransactionSource' and 'Edm.String' are not compatible."            }        ]    }} Please advise how to get pass this. IFS APP10 UPD19RegardsHami

Hi  We are facing an error when logging into IFS, with following error: Ifs.Fnd.FndSystemException: Server Error    at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)   at Ifs.Fnd.AccessProvider.Interactive.FndLoginDialog.AuthenticateCredentials(FndLoginCredentials loginCreds) ---> System.Net.WebException: The operation has timed out   at Ifs.Fnd.AccessProvider.FndConnection.CallGetResponse(String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Byte[] requestHeade

How do you assign a functional permission to an end user permission set? I want to create a new End user permission set and I want to assign multiple functional permission set to it?Can you Help?

New to IFS Connect.Does anyone have any details of what needs to be done?I have tried creating a Reader pointing at the external SFTP Server and a Routing Rule. This is enabled but I am not seeing anything on Application Messages for this? What other steps are required?Inbound Routing Rule and Reader Set Uo Any help appreciated.Cheers,Graham 

Hello everyone,does anyone know if it is possible to change the word “set”? Thank you,Anastasiya

Hello, how can I create in IFS quick reports filtering by som value even before executing whole table? For example, when I want to filter by some part no, something like this: 

I’m trying to create a WF to calculate the InventoryTurnover KPI.I’m executing a call to InventoryTurnoverRateHandling → GetCurrencyAndTurnoverRate. The call executes successfully if I hardcode the numeric params (from/to Period / Year) However if I wanna use the variables that I set in the previous step → ${fromYear} | ${fromPeriod} | ${toYear} | ${toPeriod} I get an error that Int to BigDecimal cast is not possible: When I look in API explorer I see the API call is expecting numbers. Which is what I already provide. Any ideas what I can do to execute the Projection call inside the workflow using variables and not hardcoded values?

Hello, I need help in concatenating SQL queries. My aim is to connect 11 columns together in one view or table. First 6 columns is from one view, column 7, 8, 9, 10 and 11 are from different views. How can I connect this columns together? Should I use JOINs or UNION? Because in both cases I have problem. My columns are: SELECT        PART_PRODUCT_FAMILY "Skupina príbuzných výrobkov",         UNIT_MEAS "Merná jednotka",         ACCOUNTING_GROUP "Účtovná skupina",         PLANNING_METHOD "Metóda plánovania",         Purchase_Part_Supplier_Api.Get_Primary_Supplier_No(contract, part_no) AS "Primárny dodávateľ", Supplier_Info_Api.Get_Name(IFSAPP.Purchase_Part_Supplier_Api.Get_Primary_Supplier_No(contract, part_no)) "Názov primárneho dodávateľa"FROM INV_PART_CONFIG_PROJECT_ALT SELECT NVL(SUM(pole.QTY_SUPPLY),0) "Množstvo dodávok NO" FROM PURCHASE_ORDER_LINE_EXT pole WHERE pole.CONTRACT = x.contract