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

Community, kindly assist on the SQL query we are building for API method  Inventory_Part_Config_Api.Get_Latest_Purchase_Price()what parameters we should pass to method Get_Latest_Purchase_Price()?Thank you.

Unable to sort, filter or export IAM Sessions per client -> Client Sessions -> IFS_aurena data properly. Please see attached file for details. Not able to export data more then 100 rows.

Hi everyone,I’m working in the namespace and the pods are getting IPs in the 10.1.x.x range. This is causing some connectivity issues with other services. ifs-db-init-cjp5g                                               10.1.204.235ifs-virus-scanner-7698b7994c-q2g2w        10.1.204.228ifsapp-am-workqueue-7d895cf959-ps29f  10.1.204.252ifsapp-amm-55cd5bb94b-dmwth                 10.1.204.251 Does anyone have advice or experience on how to safely change the pod IP range to a different subnet (like `10.14.x.x`)? Any tips or best practices would be really appreciated.Thanks in advance!

We have created a simple navigation link with Navigation from Active Work Orders to Work Tasks in the standard View command groupThe command works perfect in CFG and UAT, but in PROD the settings above takes us to  page/WorkTaskSales/List instead. The url for my browser in other envoronments looks like this when the Work Task page has been opened:web/page/WorkTasks/List;$filter=WoNo%20eq%2010679460;path=0.1531594057.655302546.973537261.2023108696 In prod it also contains WorkTask/List and my WO(s) but also much more…. web/page/WorkTask/List;$filter=WoNo%20eq%2010679460;path=0.1531594057.655302546.973537261.1896085532.eyJmIjoiL1BhZ2UiLCJnIjoiV29ya1Rhc2siLCJpIjoiTGlzdCIsImEiOiJ2aXJ0dWFsLTEiLCJiIjoiMTg5NjA4NTUzMiIsImUiOiJXb3JrIFRhc2sgU2FsZXMgTGluZXMiLCJoIjoiV29ObyBlcSAxMDcwOTU2NSBvciBXb05vIGVxIDEwNzA5NTg0IG9yIFdvTm8gZXE

This topic explains some techniques that can be used to find out what is causing problems with your middle-tier, for instance Connect message problems, security issues, slow running system, etc.It has been created mainly for IFS Applications 8 with IFS Middleware Server  but it should be possible to apply techniques listed here to IFS Applications 9 as well. Some of the areas like Monitoring Console could look differently or have more functionality. Log files should be stored in similar locations as well.In general, in order to figure out where to look for problems, you have to understand which part of the system is involved. Is the middle-tier involved at all? The process where you have problems, is it a background job (Batch server involved) or a synchronous call? Is the client doing a direct call to the middle-tier or is the database invoking methods in the middle-tier (using the PL/SQL Access Provider)?In addition to the tools described here, IFS Solution Manager c

Hello Community,Is there a way to enable more detailed logging in IFS to trace all incoming API requests — including failed or incomplete ones?Currently, I only see entries in the access logs for successful connection requests.Example: Out of 16 calls triggered from Boomi, if 2 return “connection refused”, I don’t see those calls captured in the access logs. Similarly, API calls that eventually time out are also missing from the logs.other 14 calls were logged well with 200 status.Question: Can IFS be configured to log these failed/blocked/timeout API attempts as well? If yes, what settings or configuration changes are required to enable this level of detailed logging? Any guidance or best practices would be much appreciated.NOTE:- this is for IFS10 applications

Hello Team, I am trying to create quick report in 25R1 version. We have report which needs to be generate data with specific column values along with some null columns. When I am trying to prepare following kind of query then 25R1 is not allowing me to save the query.  I cant use Alise here as report needs to have specific structure.  May I know what would resolution here? Note- following query is given for example actually query needs to have many null column along with some actual data columns.  

Iam trying to create an event or even an api call would be fine for when a background job finishes.  Specifically "Create Pick List for Customer Order".  Our goal is to have the associated order’s PCKNOTE document text updated after the shipment is created from the background job.  I have a custom api call that updates it when I test from SQL but I can’t figure out how to get the event to trigger.  We tried when a new record is inserted into the FRT_SHIPPING_INFO_TAB table.

Hi!A customer reached out and asked about the the SMTP authentication for Event Actions in IFS Cloud 22R1. Are there an option to use a modern authentication (like Oauth 2.0) when connecting to Office 365 Exchange server ?  The background is that Microsoft are moving away from legacy authentication methods (in some areas it’s deprecated) and recommend upgrading your authentication method.  https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online 

We have an audit requirement which requires to report the last login date and time for a user in IFS. In APPS8 we could get this information from the SERVER_LOG_TAB using the log category “IFS Sessions’. However, IFS cloud does not have this category as a server log parameter.There are some details in the IAM_LOGIN_EVENT_DETAIL_TAB but seems like it does not keep the long-term history of sessions.Can you advise how to get this data recorded and retrieved on demand?

Dear Experts,We have developed a custom APIs to post transaction data (both header and line-level structures). These APIs have been tested successfully in DEV, TEST, and UAT environments without any issues.Recently, we cloned the UAT environment into a new environment (UAT2). However, in UAT2 the same custom integration fails with the following error:ORA-22813: operand value exceeds system limits The response is always 500 Internal Server Error.We already tried the following: Tested with the original payload (works fine in other environments). Sent a blank/empty JSON payload → still fails with the same error. Verified that standard IFS APIs with POST methods are working

Issue:Our warehouse makes Zebra label prints (ZPL) and there's a delay between the button press and the physical print. This is because the flow the document needs to go through is IFS → IFS Print manager → Print spooler → print. Does anyone else have this problem?  Or any tips on how we can optimize this? 

This is in Cloud 23R1.  Trying to create bookmarks using #USER_ID# and other search macros (that’s what apps 9 called them).  Purpose is to have a profile with a bookmark to active work reported by the current user so our operators can keep up with their requests. When you make a bookmark IFS replaces #USER_ID# with the current user...  SAVED SEARCHES do not do this, the macro value is saved... Is this a limitation or am I doing it wrong?  We need a bookmark, not a saved search.  This profile doesn’t require or use any saved searches.  We don’t want to introduce saved searches to this user group. Is there a way to make this work as a bookmark?  Perhaps I nee

We found the below document from a forum regarding IFS HA on ifs cloud, is this information still valid, do we really need minimum 2 node up to work with HA? High Availability of IFS Cloud Environment 24R1 and 24R2This document provides a detailed explanation of the High Availability (HA) behavior of IFS Cloud in the 24R1 and24R2 releases. It compares standard Kubernetes HA concepts with IFS’s recommended HA architecture, andexplains in detail how failures are handled.Normal Operating Condition (3 Nodes Up)- All three middle-tier VMs (which double as Kubernetes nodes) are active.- The load balancer distributes traffic across them on port 443.- Session stickiness ensures a user’s session is pinned to a backend node.- The cluster maintains quorum (majority of control-plane members available).Single Node Failure- Two nodes remain active; quorum is preserved.- Load balancer reroutes traffic away from th

Hi All, I am receiving the emntioned error, Any expirience with ?   

Hi All, I have configured Azure AD authentication for an IFS Cloud customer. During testing, some users are not able to log in as expected and are encountering the following error when attempting to access the application: The only thing I have noticed is that there is no IAM user entry inside the profile, and no entry has been created under the IAM Users page. Have you experienced this kind of issue before?

In my situation below function was helfull:SELECT fnd_user_property_API.get_value(p.IDENTITY,'SMTP_MAIL_ADDRESS') mail,p.* FROM fnd_user_property p 

In IFS Cloud, is it possible to generate an error when pressing the search button without entering a value in the search item? If the user does not specify search conditions, the search will take a long time. BPA, page configuration, profile, etc., other than add-ons.

Hi!I was wondering if it is possible to reference an API call to get the default system URL into a link list in a lobby element.My goal is to have our lobby link navigations reference an API that get the environment default such as PROD vs MIGR. So when clicking on a lobby link in PROD, it will take you to the PROD lobby and vice versa. I am using this API for reference:selectfnd_setting_api.get_value('SYSTEM_URL')from dual 

We have recently upgraded from Apps 9 to Cloud. The lobbies have generally been correctly lifted but we have issues with glitches in the funtionality.I wanted to add navigation from a list element to a page using a parameter. No matter what I did to the element, it never recognized a navigation was added. So the URL wasn’t wrong, it just didn’t aknowledge that you could navigate. I tested it on another environment recreating the element, and it worked fine. So, I created a new element with the navigation and added it to the orignal lobby - that worked, and I could now navigate while passing a parameter.A couple of days later I wanted to change the passing of the parameters but no matter what I did, the element didn’t recognize that I was changing the navigation. I even deleted the navigation, and it still navigated passing the parameter.I’ve cleared the cache of the lobbies multiple times, that doesn’t work, I’ve checked for errors in DevTools, it doesn’t recogn

Hi,In all the lobby data sources I receive the below error pop up. This happens for all data sources carried over from Apps 10 and some existing. I am quite sure the data sources and views are correct. 

Hi I am trying to navigate to the Purchase Requisition Lines screen in my bar chart lobby. I have the x-axis set as the Demand Code: And I would like to click on each bar individually and navigate to the purchase req lines page, and have the demand code filtering already applied. I have tried to include this filtering in the navigation section: However I am getting a type conversion error when I try to test the lobby navigation: “[{"code":"TYPES_NOT_COMPATIBLE","message":"The types 'IfsApp.PurchaseRequisitionLinesHandling.OrderSupplyType' and 'Edm.String' are not compatible."}]”which makes me think that ‘DemandCode’ is an enumerated type OrderSupplyType, and $[DEMAND_CODE] is just a st

Hi everyone,We’re building a third-party application that integrates with IFS Applications 10 and we’d like to use the same Report Designer outputs that our users preview or print inside IFS. Specifically, our goal is to trigger a Report Designer run with parameters and then retrieve the generated PDF via REST so we can display or store it in our own app. We’re looking for guidance on which REST projections or endpoints in Apps 10 support creating or submitting a print job, monitoring its status, and then accessing the corresponding entry in the Report Archive to download the PDF (ideally as a binary stream or a secure link). If there’s a recommended integration pattern—such as creating the job asynchronously, polling until completion, and then fetching the file—we’d love to follow best practice. Any examples of request/response payloads for starting a report with parameters and downloading the resulting PDF, along with notes on required roles and permissions for a service ac

Hello,each time we print a crystal reports instant invoice, the name is something like INSTANT_INVOICE_REP2322.0fr2598.0.pdf . could it be possible to customize this name with something like the name of the report called (instant_invoice_V2?rpt) ? Thank you in advance. Frédéric

HiDuring the installation of IFS Cloud 24R2, we faced a problem with Oracle RAC.The IAM container is not able to start—it fails when attempting to use Oracle Notification Services on port 6200.iam log:[   151.599418s]  WARN ThreadId(01) outbound:proxy{addr=192.168.2.66:6200}:rescue{client.addr=10.14.28.21:52924}: linkerd_app_outbound::http::server: Unexpected error error=logical service 192.168.2.66:6200: route default.endpoint: backend default.unknown: endpoint 192.168.2.66:6200: invalid HTTP version parsed error.sources=[route default.endpoint: backend default.unknown: endpoint 192.168.2.66:6200: invalid HTTP version parsed, backend default.unknown: endpoint 192.168.2.66:6200: invalid HTTP version parsed, endpoint 192.168.2.66:6200: invalid HTTP version parsed, invalid HTTP version parsed] Maybe somebody already handled such problem?