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

Hello IFS Community, I’m running into an issue with a custom PDF_REPORT_CREATED event action that needs to use a specific sender. I’m sending the email with this procedure: COMMAND_SYS.Mail( sender_ => 'YY_MAIL_PU', from_ => 'IFS@noreply',to_list_ => to_email_, cc_list_ => to_buyer_email, subject_ => 'PO ' || order_no_, text_ => mail_body_, attachments_ => attachments_ ); When I trigger an Event Action of type E-Mail, the message sends and the specified sender is used correctly.However, when I use Execute Online SQL (calling COMMAND_SYS.Mail as above) the email fails to send with the desired sender.Any ideas why sending via COMMAND_SYS.Mail would fail or ignore the sender, while the E-Mail event action works? If there is a default sender it will user the default one but it is not the correct sender to be used. Thanks in advance! 

When scheduling report below error appears. Does anyone know which type of security permission is required? This error also appears when scheduling report via IFSAPP user. Error (ID: 315a5654-e668-4120-8f76-fff01489fdf1) while invoking opertion: Insufficient privileges to export the quick report to Excel. Caused by: ifs.fnd.base.SystemException: Insufficient privileges to export the quick report to Excel. 

I added a new group to our Customer Order page by customizing the Customer Order Client through Developer Studio. After saving and deploying, the new group is now located all the way at the bottom of the page.How can I move the new group to a specific spot using Developer Studio? (it needs to be between two groups. These two groups are located in the core file)I’m guessing it’s going to be an Override but I can’t seem to find the documentation on how to rearrange a mix of custom elements and core elements on a page.

We’re implementing a Remote deployment of Cloud. The server requirements are very large. How would I go about deploying the Kubernetes cluster across multiple servers, not for fail-over purposes or for user-based load balancing but rather for load balancing the different pods?

Hi Community!I am aware, that we already got several posts here for a 404 message. But this one seems odd to me.History:I have created a new database and imported a cloud based database dump into the database.Using this db, I have now installed the MWS without issues. I did this for a MIG2 environment and then for a TEST2 environment.Interesting fact: MIG2 is working fine and TEST2 is getting the 404. Using the debug console at start, you can see that a db connection seems not to work In the logs, there are not really any hints for that HTTP Access log10.11.10.119 - - [13/Jan/2022:13:58:57 +0100] 00jD0m8LasS5mZ_5xRG7yW0001q400011B - "POST /main/default/clientgateway HTTP/1.1" 404 224 0Displays a 404 no hint in the http server logthe rest of the logs do not contain anything regarding this as the access is not working. the select which is pointed out here is working when connecting to the db directlyselect lang_code_rfc3066 from &AO.language_code where installed_db ='TRUE' AND enable

I’m grappling with finding Projection/Entity/Permission set combination for this ‘Close Shop Order’ function and wondering if I’m missing a trick.   Projections appear to be ShopOrderHandling and ShopOrdersHandling and ShopOrderMaterialsHandling. Query for Permission set/Projection combination in Projection Grants/Entity Action Grants... Select and Revoke... I’ve been round this a few times now but haven’t nailed removing the permission so think it must be granted somewhere deep or elsewhere or I’m missing something obvious.  Is there any way/query/trick of identifying the Permission set that has Granted=Yes on Entity=ShopOrd Action=Close? Any suggestions gratefully received! Linda 

Hi All,What are the exact steps to clone a DB in cloud/remote installation?(Ex: From PROD to MIG)

Seeing this repeating in the ifsalert log ...Unable to close statement ifs.fnd.sf.j2ee.container.weblogic.FndOracleStatementForWebLogic … timeout.  Users are also reporting the environment is very slow.  Any ideas? Will restart the middleware after hours at a minimum ... 

Hi,I have spent a lot of hours to get the AD integration to work.We have IFS10 hosted at our partner.VPN is setup, all rules inplace, and I see the traffic hitting our DC´s.I have followed the document provided from IFS, but I still not get this to work.Even replaced our DC to new once, now running 2022 (before 2019)The DC does reply, because if I test with incorrect credentials I get a message saying that.The docs does not saying anything about ADFS, but when reading a lot of KB´s it seems that it might be needed, is that so?Anyone have AD integration, IFS10, non-adfs up and running?I would like to have this in place to be able to provisioning users only from local AD into IFS.For Authentication we use SSO to Azure.Regards, PelleFor me it stops here. I click browse…. And after a minute i this error message  

Hello,we can define poll time for sftp reader. can we do the same in sftpsender also.KIndly suggest.regardsPankaj

Hello IFS Community!A script to enable History Logging on just about every table has been executed in an IFS Cloud 24R1 SU9 environment per the request of the business. I’ve been collecting table exceptions to disable for general system processing purposes, but I've encountered one that has me stumped currently.When on a form that presents a List element, normally users have the option to export the data from that List element to Excel. Currently, this History Logging is preventing users from successfully exporting this data. My question to the Community is what table is this data being (presumably) temporarily being inserted to before the data is aggregated into an Excel format and being passed back to the client machine?Here’s the error message stack and some screen captures illustrating the issue.Any help or guidance would be greatly appreciate.Regards,RandyError Message:IFS Web Version: 24.1.14.20250702093228.0Date: 2025-08-13T15:02:55.485Z------------------------------------------

Is there a way to select multiple values in a List of Values (LOV) field in IFS Cloud—not a Lookup or Enumeration field—so that the selected values are saved in the format Value1;Value2;Value3, and stored as a single string?I'm looking for a solution where users can choose more than one option from a LOV, and have the values saved as a semicolon-separated string. Any guidance on whether this is possible would be appreciated.Thank you in advance. 

Hi,I would like to mapFndUser.Identity -- > &UserPrincipalName (without domain)Like:jondoe  →  jon.doe          (not jon.doe@test.com)Is there a way to map attribute and exclude one part from the mappingBr, Pelle 

First upgrade pass from 23R2 to 25R1. Using IFS internal database for loginFollowing upgrade trying to log in gives 401-Authorization Requiredifsapp-iam kube is showing CrashLoopBackOffKube log showsFailed to send request - Connect to localhost:8080 [localhost/127.0.0.1, localhost/0:0:0:0:0:0:0:1] failed: Connection refusedIFSIAM not up. Retrying in 25 seconds…Another log is showing  

Hi All,We’re in IFS Cloud 24R1.3 and using SSO for login. we have several users with different email domain. those users are unable to login to the application using SSO. I’m not sure how to configure IFS application to solve this AADSTS50105 error.I would greatly appreciate any opinions or suggestions you may have.Thank you in Advance!

Hi All,Is it possible to map a network printer directly to a SSO configured IFS Applications and then print reports directly without a Print Agent?

I’m testing 24R1 in preparation for an upgrade from App10.In App10 i used custom events with pl/sql action to send application messages to an internal SOAP web-service. I understand pl/sql actions will probably be removed soon, so i’m looking for an alternative.I’m trying out Application Message actions; however i have a need to send my messages using a queue of their own. But it seems to me all application messages sent from a Custom Event Action are using the queue NOTIFICATIONS. If i create a routing rule to change the queue i get an error message on the application message “Matched routing rule XXX is not defined for queue 'NOTIFICATIONS’ that is already defined on message #nnn”.How can i change which queue is used for specific messages sent from a custom event action?

My scenario:In Page Designer: The “My Time Registration” page uses a “Report Time Dialog” This dialog has a group called “ReportProjectGroup” Within this group, there is a boolean field (toggle button) called “Show Project List” ← This is the field that I want to change the default for but I through Developer Studio In Developer Studio: I found the “TimeRegistrationEmployee” client and saw it was using fragment “TimeRegistrationCommonObjects” which uses the “TimeReportingDialog” fragment The “TimeReportingDialog” uses the structure “ReportTimeStructure” which defines the default for “Show Project List” toggle button My goal is to override this toggle button so that it is set to TRUE instead of FALSE in Developer Studio.How can I do that in developer studio since I cannot customize the fragment and directly override the structure?

Hello everyone,I’m working on a workflow which goal is to automatizes human operations.We using it for shop order operations subcontracting on other company of our group.The issue is :I recover a collection of filtered shop order operations, then I loop on those and I want to update the ParallelOperation field, which is an enum.I got an error : "java.sql.SQLException: ORA-06531: Reference to uninitialized collection ORA-06512: at "IFSAPP.SHOP_ORDER_HANDLING_SVC", line 28606 ORA-06512: at "IFSAPP.SHOP_ORDER_HANDLING_SVC", line 28617 ORA-06512: at "IFSAPP.SHOP_ORDER_HANDLING_SVC", line 12700 ORA-06512: at line 1 "If I try to update the Db value (field name : ParallelOperationDb), no error, but values are not updated.I already do this kind of action previously, not in a loop, to update OperStatusCode (I update this one, not the Db value field).I don’t understand what’s wrong. I tried different APIs (ShopOrderHandling , ShopOrderOperationsHandling) and different EntitySets and it’s not wor

Hello, I was hoping to dynamically change the signature based off the user id in report studio. I was looking through the documentation and found a DB Image function. This is the syntax: DBImage(‘report_logo_’,’image_data’,’item_id=[ItemID]’) When I tried it with this: DBImage('report_signatures','IMAGE' ,'image_name=JONEIL.jpg'), it took the syntax but it doesn’t work. I was wondering if there was something I was missing? Could this also be utilized for customer orders? For example, let’s say I wanted to print the signature of the salesperson. Could that function be utilized? Thank you. 

Good Day,We have some accounts that uses database authentication and those users are getting the Server Error 500 intermittently when trying to log into IFS (users using AD authentication is fine). The MIddleware Server Admin Console doesn’t show anything wrong and I’ve even reset their oracle profile to default, but it keeps happening. Does anyone know what could have caused this or how I can try and find the problem?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.AuthenticateCr

Scenario:I’d like to maintain a list of “Trade Shows” basic data with a status of active/inactive, and have a LOV only show the active records to pick from. Similar functionality to hiding/blocking coordinators, etc in other areas of IFS Cloud.  I have a custom entity with two columns:Column 1: Trade show (String)Column 2: Status (CustomEnum: Active/Hidden) On the Sales Lead entity (Business Lead), i have created a custom attribute that references the custom table. In my page designer, i’d like to add this field as a LOV, and have the LOV filter to show only the records where status = Active. I have found this page: https://docs.ifs.com/techdocs/23r1/040_tailoring/225_configuration/200_client_configurations/310_conditional_fields/200_filter_enumeration_values/But it doesn’t cover my exact scenario. Is this functionality possible to do without a customization? If not, is it possible to just Hard Code the values that i want to see manually?For reference, I am on 23R1.8

We would like to increase the Session_Idle setting to a larger value. We are currently using 1 hour with a 15 minute token lifespan. Are the any implications other than security if we were to increase this further?

Hello i am working in a IFS cloud instance version 23.2.5. I am trying to configure the mail sender. I have received the mail token and secret from our messaging team at my company. I have created a test event that generates an email when i create a new unit of measure within the app itself. Here is my current configuration of my mail sender and error i get when i generate a event. Host: smtp.office365.comPort587Timeout60 Authentication type Client CredentialsUserNoreply@mydomain.comAccess Token URLProvided token from my companyClient ID Provided Client IDClient Secretprovided secret Mail Scopehttps://outlook.office365.com/.defaultDefault Mail Sendernoreply@mydomain.comContent Typetext/html (Notification error)ExecutionException from Sender thread Caused by: ifs.fnd.connect.senders.ConnectSender$PermanentFailureException: Fatal error while sending data... Caused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Error while trying to get the Oauth2 Mail token Caused b

Our IFS cloud deployment of 23R2 is working fine. I’ve been using the OData APIs to build integrations with external software. So far, all of the paths I have used are for projections, with some form of:/main/ifsapplications/projection/v1/CustomerOrderHandling.svcHowever now I’m trying to use some entity paths like this:/int/ifsapplications/entity/v1/CustomerOrderEntity.svcThese are failing with this response: {  error: {    code: "ODP_SERVICE_IS_NOT_ACTIVE",    message: "Service is not active."  }}Anyone know how to resolve this?Thanks,-Chris