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

Hello,Here is the pattern I want to follow:I have a custom field of type enum (boolean) in the CustomerInfo entity named “regrouping nrc.”I have the same custom attribute, with the same name, in the CustomerOrder entity.What I want is for the value of the custom attribute from CustomerInfo to be selected by default.The problem is that I can’t set a default value by logic (PL/SQL) for an enum (boolean) type.It works for strings, but I need to keep the page design with a switch button, so I can’t use a string type.I could create a custom enum with a default value like null, which would allow me to trigger it by event and fall back on the CustomerInfo attribute. That would work, but we’re afraid that users might ignore this attribute when creating an order, which could lead to errors at the end of the process, especially for customer invoicing.If you have any ideas on how to implement a fallback default value for a boolean, please share them 🤙Have a good day,

Hello everyone,I try to add a navigation link between Shop Floor Workbench page and NRC Connection Objects page.The search parameter is the keyref of the nrc connection page, which contains Contract and PartNo (available from Workbench page), like : (startswith(tolower(KeyRef),'contract=vern^partno=ac130m39403'))The problem is I’m not able in any way to make it workIf I use the variables as filter value, it will add simple quote ( ‘ ) as prefixe and suffixe of the value, which break the search syntax.Like : (startswith(tolower(KeyRef),'contract=’vern’^partno=’ac130m39403'’))I can’t make a search by contract and by partNo because partNo is not available as search / filter on the NRC Connection pageIs there a way to make this link works ?

Hello, I am currently facing an issue when automatically trying to unblock a customer order via a workflow.I am doing the following call:which has worked in the past to unblock a blocked customer order, but results in the following error:ORA-00034: cannot COMMIT in current PL/SQL session ORA-06512: at "IFSAPP.ORDER_COORDINATOR_GROUP_API", line 1762 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_API", line 12697 ORA-00034: cannot ROLLBACK in current PL/SQL session ORA-06512: at "IFSAPP.CONNECT_CUSTOMER_ORDER_API", line 2381 ORA-00034: cannot SET SAVEPOINT in current PL/SQL session ORA-06512: at "IFSAPP.CONNECT_CUSTOMER_ORDER_API", line 2368 ORA-06512: at "IFSAPP.CONNECT_CUSTOMER_ORDER_API", line 2368 ORA-06512: at "IFSAPP.CONNECT_CUSTOMER_ORDER_API", line 272 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_FLOW_API", line 266 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_API", line 16585 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_API", line 13182 ORA-06512: at "IFSAPP.CUSTOMER_ORDER_API", line 6152 ORA-06512: at "IFSAPP.C

Hi,I'm trying to add preposting details to a work order using a workflow (we're currently performing this process manually through an assistant). When I check the projection call for adding a preposting, it appears as shown below.I attempted to add an IFS API type user task in the workflow, but I wasn't able to find any entity set or projection call that can be used to add preposting to a work order.Is it possible to perform the actions currently done through assistants using a workflow?Many thanks for your inputs on this issue.Best regards,Uvini

I have a custom attribute (Cf_Customerpo) in the ReturnMaterial entity. It is published and present in the Return Material Authorization page. I can see the field in the api doc for the ReturnMaterialAuthorizationHandling.svc/ReturnMaterialSet.  I want to use this attribute in a BPA workflow but it is not being recognized.   Any idea on how to refer to this custom attribute?  

Anyone know where that exists so I can change them to the right company address? 

Hi All, In the MWO Application, When we click on the 'Complete' Button in a task, it opens the assistant page and prompt the technician to answer a few pages as a sub-workflow. when ‘Complete’ button is clicked, it opened this assistant page. How can we configure this to achieve the same for custom logic?  Is it possible to create/ modify this assistant page through configuration?I am using IFS Cloud 24R2 environment.Thanks in Advance. Regards,Sandya S

hi Anyone knowwhat is the sql query of  fetching data from database in user sessions of  IFS_AURENAThanks a lot 

When debugging Oracle PL/SQL applications, understanding the call stack is essential — especially when dealing with deeply nested procedures or unexpected behavior. While DBMS_UTILITY.FORMAT_CALL_STACK has long been used for this purpose, it’s limited to ~2000 bytes and often truncates valuable information.In this article, I’ll show you how to use Oracle’s UTL_CALL_STACK package to log the full call stack automatically using a trigger and an autonomous transaction — a technique that’s especially useful in enterprise environments. 🔧 Why UTL_CALL_STACK? Oracle 12c introduced UTL_CALL_STACK, which provides structured access to:Full call stack without limits Lexical and dynamic depth Line numbers Fully qualified subprogram namesThis allows for precise and complete tracing of execution paths — perfect for logging and diagnostics. 🧱 Step 1: Create a Logging TableWe’ll store the call stack in a dedicated table:CREATE TABLE call_stack_log ( id NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY

I’m using a BPA to update the value in this field: The update is succesfully made in the database:But the page does not reflect the change: Is this a limitation of this particular assistant window? The page is Inventory Parts In Stock - select a row - Handling Unit - Attach to Handling Unit The virtuals are INVENTORY_PART_IN_STOCK_HANDLING_ATTACH_PARTS_TO_HANDLING_UNIT_VIRTUAL_VRTandINVENTORY_PART_IN_STOCK_HANDLING_PART_IN_STOCK_TO_ATTACH_HU_VIRTUAL_VRT

Hey! We receive customer sales orders via external EDI integration. The inbound JSON payload is correctly processed by IFS, and the sales order is successfully created in the system. The item EAN (GTIN) is included in the JSON and is correctly matched to the internal part using the Sales Part Cross Reference setup.Problem:Although the matching of the part using the EAN works as expected, the system does not apply the quantity or price conversion factor defined in the Sales Part Cross Reference (conversion factor field). As a result, the ordered quantity and unit price are not converted accordingly when the order is created.Question:Is there a specific field, tag, or switch that must be included in the inbound JSON for IFS to apply the defined conversion factor from the Sales Cross Reference? Or is there any setting or configuration that needs to be enabled to allow this automatic conversion?Goal:We want the conversion factor to be dynamically applied from the Sales Cross Part Reference

We have Java-based Print Agents on IFS Applications 9 UPD 13. When they crash, like during a Windows update, they produce files like $ROOT\agents\$ID\crash_logs\crashlog_0.csv.Is there a setting I can change somewhere to stop this from happening? End users resubmit their jobs that don't come out right away, so if a job dies, I want it to stay dead.As a workaround, we could remove the crashlog_0.csv file with a startup script, but it would be nice to avoid unnecessary complexity in our total solution.

In IFS Cloud, PL/SQL event actions ("Execute Online PLSQL Block") have a character limit. While the system allows up to 4000 characters (and this limit can be bypassed via direct edit), the effective limit for exporting Application Configuration Packages (ACPs) containing these actions is approximately 3980 characters. Exceeding this limit during ACP export results in the following error: JSON{ "error": { "code": "DATABASE_ERROR", "message": "Database error occurred. Contact administrator.", "details": [ { "code": 19202, "message": "ORA-19202: Error occurred in XML processing" } ] }} This issue is specific to ACP exports. If the event action logic is not delivered via ACPs, this character limit does not apply, as the underlying database column is a CLOB, which can handle significantly larger text blocks. Therefore, the problem only arises when exporting ACPs containing PL/SQL event actions that approa

I want to skip an error if any for single csv file row and log the error in the log file.Current behavior if an error raised from a row executing entire file is halted. There is a keyword called catch error but seems only works with test files.Is there any way to achieve this?

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------------------------------------------