IFS Solutions

I am trying to run cust_age_analysis_rpi.Cust_Detail_Age_Analysis in pl/sql to generate the archive data for it, and then I am going to pull it into an SSRS report. I had done this years ago at another customer and this code worked, but not sure what I am doing wrong now. Getting this error.“end;Error report -ORA-20111: Archive.FND_RECORD_NOT_EXIST: The Archive does not exist.ORA-06512: at "IFSAPP.ERROR_SYS", line 140ORA-06512: at "IFSAPP.ERROR_SYS", line 366ORA-06512: at "IFSAPP.ARCHIVE_API", line 845ORA-06512: at "IFSAPP.ARCHIVE_API", line 849ORA-06512: at "IFSAPP.ARCHIVE_API", line 235ORA-06512: at "IFSAPP.ARCHIVE_API", line 240ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1285ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1294ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1327ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1331ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1745ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1751ORA-06512: at "IFSAPP.CUST_AGE_ANALYS

We tried to setup the PO Change Industry Lobby KPI but it looks like the workflow IndustryLobbyKPIProcurementPOChange is always failing with following error in the BPA_ASYNC_SYS_AUDITBpaBaseException--BPA_RESULT_SET_LIMIT_REACHED_EXCEPTION_ERROR Same error occurred when we try to debug the workflow using same parameters It looks like the error is with the Get Total Value of Purchase Order Change Orders projection call.This call  doesn’t have any parameters so it fetches ALL the change order details.The same applies for Get Total Value of Purchase Orders task as well since it also doesn’t have any parameters.Will IFS provide a usable version of this workflow in a future release?IFS Cloud version: 24.1.8 Best Regards,Damith

Hello, in the fact_customer_order_line_bi . I cannot see the correct amount if I have a credit that was made at the order level following an RMA. I can just see the amounts on the order line side and not on the invoiced line side and that creates an imbalance at the sales level.Exemple : Customer Order line  Side :fact_customer_order_line_bi : in power bi  fact_customer_order_lineCustomer invoiced Line side :  The  question : is there a way to resolve this issue and get the customer order line amount correctly

We are in the beginning stages of a migration from an AS400 ERP to IFS Cloud. I’m an enterprise software engineer who is new to the IFS world.Our current warehouse shipping process involves a piece of custom software that screen-scrapes from an AS400 terminal session into a Windows application called ClipperShip. This software handles all the carrier specific logic, including printing labels, etc., then another piece of custom software gets the data out of ClipperShip and back into the AS400 ERP.We would like our new solution to be as simple as possible for warehouse employees. Ideally it would be completely web-client based. We have started evaluating some API-based shipping solutions like ProShip and ShipEngine. Here are my questions after reading through the technical documentation: 1. It seems that the shortest path to getting something functional would be to use a solution that already provides a client user interface, build a piece of custom middleware that uses the OData REST AP

Hi,I’m trying to save and publish a report to the IFS Cloud environment, but getting the below error. Kindly help me to resolve this. Error when saving the report in ifs cloudRegards,Deepal.

Just a rant for whoever experiences the same.I'm trying to get IFS to fix exporting and importing ACP's with event actions of type Execute online SQL where the statement has more than 4000 characters.And the ticket turns into a discussion about why I'm not using workflow and if I can supply a list with issues which caused me to use sql instead of alternatives.Excuse me what?The fact here is with the implementation of the workflow in our company we had a huge list of issues and design flaws which I had to call out and struggle to get corrected. And by no means I'd say that in the current state in the version we're about to go live it's a stable solution. I don't get thanks for this, I get to pay to get things fixed and struggle to keep tickets open as well.For me the problem with IFS in this regard is that they have the balls to say this SQL feature is deprecated while fully knowing that the alternative is a steaming pile of ….. Why not be honest and set a date when it can actually be d

Good day.  We are migrating/loading Employee Data and have encountered the following error:Anyone that can perhaps assist to resolve this?Thank you.Anya

This issue is encountered by one user only and there were no permission changes recently .They mentioned that when they click view button normally the Document would then appear in a separate application / window but this is no longer happening. Need your kind input on this issue.ThanksUdanee

Community, Does Shipment Order can be functioned as transport task or distribution order, which can be automatically created in the system?  Thank you. 

Hello everyone,The task at hand is to send picklist report in email without physically printing it to the printer.I have a report rule that kicks off and send email only if Printed column in Report Archive has value 1. I tried to use Set Property, preselect Property and default Property to print the report on a No PRINTOUT logical printer but that does not help until user click on ‘Print Pick List’ menu option and OK on the print dialogue box.In our shipment type we have Print PickList set as an Auto function.What's the best way to achieve this task without forcing the user to print picklist on a noprintout printer which is couple extra clicks and one extra step in the process to remember. Thanks 

PSO shows the resources incorrectly as available when they are not. PSO Region filters are not respecting the availability times.  It shows resource in Region if ANY past or future-dated availability exists. Current functionalityWe have 4 resources assigned to region AA1A. One resource is only available from 5/5/2025 – 5/25/2025. (This is filtered by adding the ‘valid from’ and ‘valid to’ dates in the scheduling resource regions). In PSO we are filtering the resources assigned to region AA1A and available for the next 7 days. The result still shows the resource who is only available in May as well, which is incorrect. The same issue exists when we use availability patterns as well.  Current time filter only applies to the resource shifts. This needs to be fixed so it will consider the availability of the regions as well, if filtered by the region

Is it possible to automate deployment of permission sets in IFS across different environments (Dev, test, UAT, traning) using IFS.ai?

Hello, I would like to know which custom expression to use in order to schedule a database task to run at the end of each month at a specified time. I am currently using the custom expression LAST_DAY(sysdate+1). Is there a way to add a time into this expression? We are running IFS Aurena 10.  

In PSO 6.13 and now 6.14, we are noticing that when recurring (daily, weekly, etc.) unavailabilities are created in PSO, the info and display on the Gantt is consistently skewed by 33m52s.  Has anyone seen this or can anyone offer ideas as to where this might be coming from? Thanks,Richard Gantt info Unavailability on resource

I matched three invoices in the Supplier Check window and successfully created a Supplier Check. However, when I navigated to the matching details of the Supplier Check, all three invoices were visible, but the Voucher Type and Voucher No fields were not displayed.Could you please clarify why this is happening?Application Service Update: 24.1.4Framework Service Update: 24.1.8Please refer to the attached screenshot for reference.  

Hi everyone,I'm trying to create a bar chart forecast in IFS Lobbies that shows the total net amount of planned spares (SUM(UNIT_PRICE_INCL_TAX * QTY_INVOICED)) grouped by custom delivery periods rather than standard calendar months.We have predefined customer order delivery months (e.g., "Jan-25", "Feb-25"), each covering specific date ranges rather than full months. I need to map planned delivery dates to these periods for proper grouping and display them on the X-axis of the chart. Here’s the query structure I’m using: -- Name: Customer Order Forecast Per Month-- View: &AO.CUSTOMER_ORDER_LINE-- Where:EXISTS (    SELECT 1     FROM (        SELECT '01/01/2025' AS start_date, '01/01/2025' AS end_date, 'Year Opening Period 2025' AS period FROM DUAL        UNION ALL SELECT '01/01/2025', '24/01/2025', 'Jan-25' FROM DUAL        UNION ALL SELECT '25/01/2025', '21/02/2025', 'Feb-25' FROM DUAL        UNION ALL SELECT '22/02/2025', '24/03/2025', 'Mar-25' FROM DUAL        UNION ALL SELECT '

Hello again,I’m trying to create a Persistent Custom Field (Boolean) in Preliminary Supplier Invoice screen to identify some feature for a newly created invoice. The process goes smoothly, CF is published without errors, but when trying to create a new record with the checkbox ticked for this CF, system displays the error: In DetailsServer error messages:809f34f0-4b7d-4301-a0a3-6578e0a9262dIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01410: invalid ROWIDFailed executing statement (ORA-01410: invalid ROWIDORA-06512: at line 16ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 699ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 578ORA-06512: at line 10)   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)   at

Hi Community,Is there a way to convert a multi-company project transaction into a regular project transaction? If so, what steps are required to achieve this? Any guidance would be appreciated!We’ve created a correction transaction and changed the activity to a non-MCPR linked activity but it results in the following error.The error message seems to suggest that there is another view where the transaction can be converted from MCPR transaction to a regular project transaction.Our version is IFS Cloud SU 24.1.3.

Hi All, Is it possible to create a manual supplier invoice for an a project activity line ? ThanksDivya

Hi,I am seeking some general advice and insights regarding our transition from IFSAPP10 to IFS Cloud.Currently, we utilise all 10 of our defined code strings within our accounting rules. While I won't delve into the specifics of each code string, I can confirm that they are all essential for our business requirements (details can be provided if needed).We are concerned that this extensive use of code strings might pose challenges as we migrate to IFS Cloud. Therefore, I have a few questions that could influence our decision to either re-implement or upgrade:Is it possible to repurpose one of the optional code parts we have defined for future use? What impact does using all 10 code strings have on our system, aside from limiting future requirements? Is there a way to use more than 10 code parts (either standard or customized)? Are there any guidelines or recommendations on the number of code parts to define within a string?Any general advice and the importance of getting this right for

Hi CommunityIn the process for Clear Revenue/Cost Balance, IFS is currently configuring with the GP8 Posting Control based on a Fixed Value.We would like to use the “GC3 - Ledger ID” control type for add a 2nd option (One in case of profit, one in case of loss)I can’t figure out how create a new Ledger ID to use it correctly, could you please help me to solve this problem ?If you have another idea to solve this problem it would be perfect.Regards

Hi1) Is it possible to expose endpoints from Grafana and Kibana to external tools? currently the endpoint https://ifs.xxxxxxx.eu/grafana/datasources is used but only metrics for Memory are visible (CPU and filesystem are unavailable)2) Is there a way to quickly export and import dashboards from kibana and grafana to a file/files? The thing is that when updating certificates (at least once a year) it is necessary to reinstall Cluster Kubernetes and we have to install the namespace ifs-monitoring again together with the dashboards.Product Version: 24.1.5regardsDaniel

Hello,  Is it possible to import and external supplier invoice as an advance invoice ?  Best regards

How issue project stock in bulk?

Hi all, We have recently implemented IFS Cloud. As an organisation we have centralised follow-me printing, so a single print queue with multiple multi-function printers which you release your job on your printer of choice. If you Preview your document, you can print to directly to the print q as yourself.If I send the print job via the Print Agent, it sends the job to the print Q from the cental Print Agent as Administrator, so gets lost as a none-user job on the print server. It has been suggested that I have the Print Agent installed on every device, which isn’t really a viable option. Does anyone have any suggestions or experience of this Follow-Me style printing and Print Agent? TIA