IFS Solutions

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

Hello,I am looking for API documentation for IFS Application 10 (UPD 22). Is there a link for that?Also, does IFS 10 UPD 22 support bulk and batch upload for fx rates using API?Product Version: UPD22Business Impact: (FX) rates are a critical component in financial applications, especially for organizations operating across multiple currencies. Accurate and timely FX data ensures proper valuation, reporting, and compliance with financial standards. The purpose of requesting API documentation from IFS is to enable seamless, automated integration of FX rates into the financial modules of the ERP system. This supports real-time updates, reduces manual intervention, and ensures data consistency across financial reports and transactions.

We have discovered a handful of shop orders that are not pulling in the phantom part number into that specific column. I have found 1 Customer Order that has 2 of the exact same cases on the order, one shop order has the phantom part no showing and the other does not.  Phantom ShowingNo Phantom ShowingThe shop orders were released on the same day. We use the CTO module; these are both the same configuration. In the past we knew it would not appear due to being a shop order brought over from IFS9 to IFS10.

I’m having issues saving Measurement for Object for some specific records. It doesn’t happen to all. I click save and it takes a long time and finally errors out.  Context:I am using a BPA Workflow triggered by a custom event when a measurement is entered The workflow event action is set to run asynchronously. I disabled this event action and I’m still seeing the same issue for specific records. The workflow makes multiple IFS API calls a IFS Rest Call includes JavaScript scripting includes looping through a collection of objects The mutating operations in the workflow include: Creating web app notifications Creating push notifications for MWO applications  Any insight on this would be useful. It could be a data issue, or it could be a side effect of the custom event action with the workflow.IFS Web Version: 24.2.5.20250402090305.0Date: 2025-08-18T18:08:11.775Z---------------------------------------------------------------------------MeasurementsForObject/Form (server error)Databa

A new version of Perfidia v4.50.217 has been released. The actual version can be downloaded here:https://www.perfidia.de/downloads/psa/psasetup.exePerfidia Forum can also be accessed with GuestAccess (Gastzugang)https://www.perfidia.de/Perfidia?action=forum

The Austrian government has mandated a change in the XML structure for the EU Sales List (S056 ZM Reporting) to comply with updated legal reporting standards. This adjustment affects only the XML output and specifically targets two elements within the file structure: DREIECK and SOLEI. The enumerated value for these elements must now be set as "J" instead of the previously used "1". This change is applicable for 24.2.8 - 24R2 SU825.1.2 - 25R1 SU225.2E.0 - 25R2 EAAPP10UPD29

I want to find the user who has created the manual suppier invoice.  Is there any way to find it through the sql query

The following changes in the output of the German Intra Community Sales Report (ZM) will be applicable: CSV Header Update (Version) VAT ID Output Clean-up (Zusammenfassung Länderkennzeichen und USt-ID New Country Code (Nordirland 'XI')  The changes are applicable for the following IFS Cloud/Applications Versions: 24.2.9 - 24R2 SU925.1.3 - 25R1 SU325.2E.0 - 25R2 EAAPP10UPD29 Encoding changes from ISO-8859-15 to UTF was already covered in IFS Applications 8 and is default in IFS Applications 9 and IFS Cloud.

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.

We are migrating from APP9 to Cloud. In APP9 we use prepare work order quotation and create the work order. When these migrate to Cloud, a work order is created with an attached service quotation. Migration also creates 1 work task per tool line on tools and facilities tab and a final work task which has all planning, materials, time reports lines. When I add new planning, materials or time reports line, go to Conclude Work Order, and create invoice preview I do not see any of the new sales or cost lines in the preview. This is an issue because our process will be to transfer all cost and sales lines (they are invoiceable on work task sales tab) to the customer order eventually so they can be recognized in financials. Does anyone have suggestions? This problem doesn’t exist when I create a new work order and work task. Creation of a new work task to overcome the issue will come with a lot of additional work because those planning, time report and materials lines will be needed on the w

Hi Experts,In work task time reporting, is there a way we can round the Reproted time bases on some increment setup.Ex:Technician report 1hr and 7 Minutes but we need to charge the customer in 15Min interval. so the invoice hours should be 1hr 15 Min?If Time Increment is 30 Min then it should be rounded to the next 30 min! Ex: 2.25 hr reported then Invoice Hour should be 2.5 hr This setup is there in Customer old system but I could not find any similar function in IFS Cloud?Thank you,KM

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?

Hi Allcommitting activity through schedule information tab when I change the status of an activity in PSO from Allocated to Committed, the change is being made, but after a few seconds the status changes automatically to Allocated again.Has anyone encountered something like this?       

Hi,I wanted to check if it's possible to uncommit bulk tasks at the PSO UI level. Could anyone please confirm?

Dear PSO Experts,We are experiencing very high values on Avg DTU percentage usage. Please see first screenshot.Yesterday the peak started at around midday and remained above 90% until the new automated load at 3:30 am today.Please see second screensthot for the current levels of exceptions. We have loaded 4,872 Activities in PSO with a dynamic window of 5D and an Appointment window of 21D. We are on PSO 6.13.Could the high levels of Exceptions have such a significant impact on the Avg DTU percentage usage?We are looking into the indexing of the database.I will appreciate any feedback from you if you have experience a similar scenario.Many thanksMiguel  

Hi,Is there any page or report in IFS that shows full traceability for lot/batch-tracked parts?Our top-level part is serial tracked, and all components/subassemblies are lot/batch tracked, including raw materials. Lot/batch tracking is order-based.The main goal is to have something that shows the full path from finished goods (serial tracked) to the raw materials used (lot/batch tracked). Many thanks 

How to change/edit “Send to Colleague ID” in app9

Hello,I’m trying to create an IFS Business Planning structure with multiple entities.We have numerous companies, each with different reporting currencies.I would like to create a planning unit for each company. (e.g., plan in local currency for each company, and consolidated to reporting currency USD)How do I best structure this? 1) Do I create a planning unit in each company? or2) Do I create planning units in one company and link them to the Business Plan? (But can’t import General ledger from each company)Any help is appreciated.Thank you!

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! 

Hello Community, I’m trying to find a solution for a “Saturday Paid Lunch” (0.5 Hr.) when the employee(s) are not present.  Every Saturday, I need 0.5 Hr. of “Normal” on the Time Cards, workers or not.  My solution at the moment, … I’m treating (and testing) the lunch time as PHC event, every Saturday.  Is there any other way to do this without weekly “trigging” for each time card??  Thanks!Cheers, Troy

Hello.I have a dependent drop down on a field (req_type) where if a certain value is selected, it will display options. The issue is that when a French user selects a req_type, the values default to English (see below 1.0). How do I get the message translation to work in my client script? 1.0 showProgressIndicator();var reqType = getControlValue('request','req_type');var emptyOptions = [];var options = createCodeTableOption('','');arrayPush(emptyOptions, options);setControlOptions('request', 'user_def22', emptyOptions);if(reqType == 'EMERGENCY') { var opt1 = []; arrayPush(opt1, createCodeTableOption('EXPLOSION','Explosion')); arrayPush(opt1, createCodeTableOption('FIRE','Fire')); arrayPush(opt1, createCodeTableOption('LEAK','Leak')); arrayPush(opt1, createCodeTableOption('OTHER','Other')); arrayPush(opt1, createCodeTableOption('SMELL','Smell')); setControlOptions('request', 'user_def22', opt1);} else if(reqType == 'PICKUP_TANK' || reqType == 'CYL_RECERT_PU' || reqT

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.