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

Hi,In Excel plug-in order reports, the excel is not previewing/downloading when the number of records are more. It is showing PDF not created error in Aurena, and stream not readable error in IEE. The report output was having 60k + records. Is there any size limitation for the excel plugin reports? Or any solution is available. I am using IFS 10 Aurena. There is no issue when running the same report for smaller set of records.

Is there a way to configure to open a link in a lobby element in a new window? Currently navigates to the link and open it in the same tab  

Dear all, does anyone know which table stores lobby element statement?We need this information to make impact analysis on all lobbies when we modify the usage of data (ex: adding a new employee category). Thanks a lot for your help KR

I need to find the table name where I can find the data related to command buttons in IFS cloud.  

Hi,we would like to report the picking via the REST API in the shipping process. (I know how the API basically works and we have already been able to implement other interfaces with it). As we often have shipping processes with more than 100 parts and do not pick them in one day, we would like to confirm the picking item by item. This works in the web interface via ‘Report Picking of Pick List Lines’: When I display the history in the ‘Log Window’, ‘ReportPickingOfPickListLines.svc/FndTempLobs’ is called up. Here I cannot enter the line, article, location, lot or quantity. It is unclear to me how IFS works at this point.I then looked at the functionality for the mobile scanners (Warehouse Data Collection):You have to confirm each step individually, which is too much for us. That's why we want to simplify the whole process for the user via the REST API. But again, I don't understand the REST API. For example, ‘WarehouseDataCollectionHandling.svc/ScanningClientVirtualSet(Objkey=’2311377A

Hi Does anyone know what does it mean this message? By default final one is Accepted but I do not understand transition Accepted to Acknowledged. Any business process requires that?

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!

Hello, I have made a Custom Field on a tabular model table and while the data shows up when I run it in SQL but when I go to add it to the Power BI report, the field is there but no data populates for that field. Any suggestions to get data to populate in Power BI as well? I’ve ran a data load and did a “Full” Process Definition refresh for my tabular model as well. Thanks,Jay

Hello everyone,To run a BPA from an API, I have been using this URL for a while:main/ifsapplications/projection/engine-rest/process-definition/key/BPA_NAME/startAnd in the body of the API, I pass it the property:“withVariablesInReturn”: trueThis allows me to directly retrieve all the variables used in the workflow in the API return.However, I have noticed that this no longer works beyond SU6 in 25R1.Have you encountered this issue?Thank you.Theo

Dear Community,We are facing an issue in IFS Applications 9 where the DBA_NETWORK_ACLS configuration is getting reset after each reconfiguration or installation.Due to this behavior, we are required to manually reapply the ACL settings every time using the following DB command: exec sys.dbms_network_acl_admin.assign_acl( acl => 'IFSAPP-PLSQLAP-Permission.xml', host => 'xxxxxx.com', lower_port => xxxxx, upper_port => xxxxx);This manual step is becoming repetitive and error-prone after each deployment activity.We would like to understand:Which configuration file or component stores the ACL settings? How can we ensure that custom ACL entries persist after reconfiguration or installation? Is there a recommended or supported approach to maintain these settings in IFS Applications 9?We would greatly appreciate any guidance or best practice recommendations to resolve this issue.Thank you in advance for your support.Best regards,

I’m having trouble triggering a workflow from a projection call. When a button is clicked in Aurena, it launches an API call in batch mode — for example, when creating a customer order line or closing a period.  However, I can’t find the specific call within the batch process to link it to my workflow. Does anyone have any ideas or guidance on this? Same issue when creating a customer order line.  Thank you for your help. ​@kamnlk ​@dsj any help would be appretiated :)

Hi I am trying to enable the subscription functionality for the document revision page. Idea is that I want to receive notification when the status of the document revision is changed. I can do this per document revision but I am trying to enable it for the entire page. So I dont have to do it one by one.Anyone know how we can achieve this in IFS? Thanks,Chamath

In IFS Report Designer, If you are trying to add a logo into report, there is another specific way to do that. Here I’m going to explain how to add any static image into report. But you also can use this method to add logo as well.Steps: * Note : From now I will use ‘img’ as the image file nameFirst you need to create Media Item on application. - Navigate to the Media Item Window and create new, fill all the mandatory fields then save. - You created a new media item, now you need to upload an image into this media item. Also image should be in JPG, JPEG or PNG format (img.png / img.jpeg / img.jpeg).        --Browse(01) and select appropriate image, then save(02).   You can now display this image in the report you want. For that first you need add attribute into the .REPORT and create new cursor and update the RDF.CURSOR get_img(img_name_ VARCHAR2) IS       SELECT item_id    company_logo       FROM   media_item       WHERE  name = img_name_; img_ VARCHAR2(100);   After that, you ca

We are in 25R1.  Our scheduled data load jobs are showing as submitted but are not actually starting in the DB.  If we manually start them, they run fine.  Has anyone else come across this issue and found a solution?  

The user has access to the function “Manage Widgets”. The user see only ths Widgets. How I can add the other Widgets like “Daily Project Time Reporting” and “Work Task Time Reporting” to the User Permission Set?   

Hi all,during a 25R1 to 25R2 upgrade, we converted several custom materialized views to the new declarative .views syntax to make them EBR compliant.The generated `CREATE MATERIALIZED VIEW` statements use:EVALUATE USING CURRENT EDITIONThis is expected according to the .views documentation.However, we found that materialized view creation can terminate the DB connection with:No more data to read from socketIn our case, this happened when the source view dependency chain contained constructs such as:DISTINCT ORDER BY ROW_NUMBER() OVER (... ORDER BY ...)After rewriting the affected source views to avoid these constructs, the materialized views were created successfully.Examples of workarounds that helped:Replaced DISTINCT with GROUP BY Removed unnecessary ORDER BY clauses from view definitions Replaced ROW_NUMBER() OVER (... ORDER BY ...) logic with MAX / GROUP BY logicWe also found one deployment-order trap.Calling Database_SYS.Prepare_M_V_For_EBR from a CDB file was problematic, because

Hi all,It's regarding, how to get Logged-In User Id in Workflow.I have successfully fetched the Logged-In User Id with single block workflow (Thanks ​@dsj for guiding). However, workflow returns the null value with same script when adding another block to read ApprovalRouting data. I noticed another behaviour as well. If I test workflow just after validating the BPMN for Workflow Command, sometime randomly it works. ​@dsj will appreciate your input.  

Hello Community,In IFS Cloud, while importing multiple permission sets, the system gives us a summary and allows us to select whether to merge, skip or replace the permissions. We need to do this for each permission manually. Is there an option to select one option for all permissions or a group of permissions? Thanks in advance!

Hi All,We need to change the format of BOC payment file from UTF-8 to ANSI by doing through the batch process in IFS Cloud.The approach is to use the batch process (background job) with defined character sets if we need to generate file encoding with ANSI format.Could you please explain and let me know how to apply a defined character set to the job when it runs?Regards,Vignesh

Is their a certain way I need to be wording the visible conditions when comparing dates? The documentation for Report Designer is absolutely awful with nothing about coding structure in Visible Conditions. This is what I’ve been trying to get working: tns:DUE_DATE >= vldtdate:currentDateTime()Nothing works and Report Designer will just fail to preview a layout so often when trying out conditions.

Hi everyone,I'm working on a customization in the WRKTSK component where I need to add custom columns to an existing table (JT_TASK_TRANSACTION_RTB) and extend several views to include these new fields. The deployment via IFS Developer Studio works perfectly, but when generating the SU3 package through the Lifecycle Portal, the Sanity Build fails with the following error:ORA-00904: "JD_WORK_START": invalid identifier Problem DescriptionI've added 8 custom columns to the JtTaskTransaction entity and created the corresponding .cdb file for the table changes. I also created a .views file to override JT_TASK_TRANSACTION_EXT and several other views that depend on it.The error occurs when the .apv file tries to create views like JT_TASK_TRANSACTION_UTIL, JT_TRANS_BUNDLE_ALL_WO_UIV, and JT_TASK_TRANSACTION_SRV_UIV. These views reference ext.jd_work_start (and other custom columns) from JT_TASK_TRANSACTION_EXT, but the column doesn't exist at the time of view creation.Important observation: Ac

I’m currently working on a Workflow for a customer.The Workflow shall create Purchase Orders with Purchase Order Lines for different parts.For this I need to pass the buy unit price but before I can do that, I would like to fetch the correct price first.From debugger I can see that IFS calls PurchaseOrderHandling.svc/ValidateBuyQtyDue.When trying to call this api from the workflow I get the following message:This references unsupported datatype(s)and I cannot seem to get it to work. Any expirence with this or suggestions to other api to use?OBS: price list are used for some Supplier for Purchase Parts.  

Just out of curiosity, I would like to understand the naming convention for deliveries in IFS Cloud. We received a delivery to apply in one of our customer’s environments and found odd that the ID was changed from 3.X.X to 4.X.X although they both were created in the same product version, as you can see in the picture below:    I thought the first number changed only when applying Release Updates…  Thanks in advance…Elaine Berenguer

How do I export a Business Reporter report from IFS so that non-IFS users can see it?  When I run it and Distribute it to myself, it downloads, but if I send that to a person who does not have business reporter installed they get a blank workbook.

Hi Team, I am trying to invoke a workflow when the new records are inserted or when the objects changes (invoking through database) in the Survey Answers screen (JT_TASK_SURVEY_ANSWERS_TAB) but the event doesnt trigger at all although the workflow debug works fine and no issues with the workflow added  any idea why this behavior of the custom event on this table? Regards,Rakesh