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

IFS is unusually slow, to the point you can no longer use lobby elements or perform simple query's. For instance the same query/lobby takes less than 5 seconds on Production and on the Satellite its takes up to 5 minutes. The database ran the Query in a couple of milliseconds. Some further information:1. No network issues, there server runs on a local network onboard. 2. slowness it experienced everywhere in the APP particularly Active Work Orders and Measurement Registration when loading records greater than 100 lines. 3. I am performing simple query's such as select MCH_CODE, PARAMETER_CODE, TEST_PNT_SEQ from EQUIPMENT_OBJECT_NEW where MCH_CODE like '3111%' and PARAMETER_CODE = 'ALARM' 4. The environment was restarted last Friday however no changes were made 5. This issue was noticed last week 6. There is very low resource usage in the MWS i.e CPU less than 5% We refreshed the Server yesterday as well as cleared the dictionary cache. Anyone have similar issues or have any solutions?

There are a few scenarios where we would want to schedule a workflow to run periodically. One in particular - Where the users have an LTU, they cannot do much with a workflow due to the limitations on the permission set. The workaround i have to use is to “schedule the BPA”, so that it runs as a different user with high privileges. As long as we have the LTU concept, we are going to have to do this to solve customer requirements. So, it would be good to have a proper approach to support scheduling a BPA. Currently we have to mess around setting up a dummy migration job so that we can use the job scheduler there. This is confusing to customers, looks pretty unprofessional and introduces a lot of baggage such as the need to import/export migration jobs. It would be quite straightforward to enable scheduling a BPA via Scheduled tasks. The method bpa_sys.register_async_bpa would work fine, but is not considered “schedulable” because the package ends in _sys, not _api. So it is not possible

We are getting the following error in Print Manager.Exception while generating Plugin Output Caused by: Error while rendering the report. 11 retries were made. The last error message is Server returned a status other than OK: 500 Message: Internal Server Error Report Title: Quick Report TemplateTwo different Scheduled reports runs in Background Job.The report(s) works fine when running it manually. Found this answer for similar issue Solution: ifsapp-reporting-ren pods in Kubernetes – Needs Restart We have restarted but error remains :-( We are running Cloud 22R1.

Hi How would it be possible to determine the current user in a workflow ? In PL/SQL we did it through the Fnd_Session_Api, but I am not able to find the correlating Projection in IFS Cloud. Any suggestions ? Regards, Pieter

Please check the following column visibility experiment for the standard list page “/page/CustomerOrders/List” and maybe you can help me answer the questions I asked at the end of the post. When I open the page in table view, not all columns are visible by default: As an IFSAPP, I have set the B2bOrder attribute to “Column Visible”, “Default To Previous” and “Visible”, but it is still not visible in the table view by default to IFSAPP and other users - see below. I have tried restoring the default table view settings and "Clear Mapping Cache", but it change. As an IFSAPP in a global context, I added 2 columns at the end of the list in the table view: The columns are visible to IFSAPP even after logging in again: But when I log in as a different user, these 2 columns are not visible: questions: What columns will be visible by default in the table view on a list page and what does it depend on? How can I make a column (which is hidden) visible to all users by default in the table view of

Hello, I am attempting to customize the code for the QuickRegisterCustomerAssistant in IFS Developer Studio. However, after clicking "Generate & Deploy," I encounter the error "ERROR: Cannot find required model [BusinessActivity.entity]" for the "rmcom" component. I successfully deployed the code for the other components without any issues. Do you have any idea what might be causing this error? Thank you.

Hello Everyone, I have added many custom actions to projections without any problem. However, I have this one now that will not populate the parameters that are in the PLSQL. What is really weird is that in the API Explorer it recognizes the parameters. Has anyone seeing something like this and know how to resolve this? I am getting this when I try to call the REST Service as labeled in the API Explorer, passing the parameter, and I can only think it is because the parameter isn’t showing up in the Projection. "error": { "code": "DATABASE_ERROR", "message": "Database error occurred. Contact administrator.", "details": [ { "code": 6550, "message": "ORA-06550: line 2, column 2:" } ] } Appreciate anyone who may have an insight as to what may cause the parameter to not be showing up. Thanks, Derek Hansen

We have an issue with 23r2 and it seems like it’s connected to the BPA/workflow engine spinning off and cause odata user session hanging forever in active state and consuming cpu load.The Active sql session are running the belove sql. It dosn’t happen all the time but 10 - 20 times pr day. We have seen this issue now at 3 different production environment runing IFS 23r2s03 and su05 SELECT A.concat_order_refs, A.order_supply_demand_type_db, A.order_no, A.line_no, A.rel_no, A.part_no, A.contract, A.source_info, A.line_item_no, A.project_id, A.date_required, A.order_supply_demand_type, A.status_desc, A.qty_supply, A.qty_demand, A.qty_reserved, A.qty_pegged, A.projected_qty, A.plannable_qty, A.proj_not_res_qty, A.plan_not_res_qty, A.proj_not_peg_qty, A.qty_short, A.plan_not_peg_qty, A.proj_not_res_or_peg_qty, A.plan_not_res_or_peg_qty, A.co_plannable_qty, A.condition_code, A.project_name, A.sub_project_id, A.sub_project_description, A.activity_no, A.activity_description, A.activity_seq, A.

We recently upgraded to 24R2. At the login screen there’s now a background picture on the left side - is it possible to change this?

We utilize Cloud 22R2 and we utilize logical printers for certain reports. When we have these print jobs go to a few specific BizHub type printers the local printer is requiring the selection of paper size. Is there a setting somewhere within the Cloud Logical Printer set up to select paper size to be letter?

Hi, Is there a way to print an address without the blank lines. I am producing an email which includes the delivery address but looks un tidy because of the blank rows in the address. I am using an event with plsql code. Thanks

Hi, The IFSCloud application is sending an unmanageable number of SFTP reader requests to the external SFTP server. Is it possible to reduce the frequency of SFTP reads in the IFSCloud SFTP Connect Reader? If so, could you please advise on how to adjust the request frequency? Thank you for your help and support! Regards, Mahesh

Hi, I want to send a data file from IFS Cloud to a Google Cloud Service Bucket using their REST endpoint. The google rest endpoint is authenticated via the OAuth 2.0 JWT mechanism, where the client has to create a signature using the given private key and send it to Google for authorization of the request. In IFS Cloud routing addresses, only REST Client ID & Client Secret Authentication (Basic Authentication) is supported, not JWT. Is there another way to authenticate using JWT in IFS Cloud? Best Regards, Charitha

Dear All, Do we have the option of Broadcast Meesage in aurena like the way we have in IEE. Thanks in advance! BR HA

While creating new instance in IFS Apps 9, getting the below error. Error in Ant-script: server/install_fndmws.xmlReported error is: The following error occurred while executing this line:/opt/ifs/repository/server/install_fndmws.xml:822: The following error occurred while executing this line:/opt/ifs/repository/server/install_fndmws.xml:1006: Failed to create IFS Middleware-instance. Error is: (Problem invoking WLST - Traceback (innermost last): File "/opt/ifs/tmp/_wls_config/asInstallerScripts/create_domain.py", line 415, in ? File "/opt/ifs/tmp/_wls_config/asInstallerScripts/./common_lib.py", line 37, in initConfigToScriptRun File "/tmp/wlst_module1234961478067662084.py", line 1239, in startServer File "/tmp/wlst_module31451089081594331975.py", line 240, in raiseWLSTExceptionWLSTException: Error occurred while performing startServer : Could not start the server, the process might have timed out or there is an Error starting the server. Please refer to the log files for more details.

Hello, I am trying to update a custom field on a custom page on IFS Cloud using workflow/BPA. The value needs to be set to the current user Id. Is there a way to get the current user Id by using a context substitute variable(#USER_ID#) in the value field? I am using - IFS Aurena client version: 21.2.1.20211105061905.0 Thanks in advance, Asheer.

Hello everybody, I got the following error message while processing a background job: This background job was set to state Error because the executing Oracle process was killed. ( Detected by cleanup process at 2024-04-22-08.04.09 ) Why does it appear? How can I enable the checkbox “Exclude from Cleanup”?

Hi, In designing lobbies in IFS Cloud we could use variable substitutions such as ‘#START_OF_THIS_WEEK#’. I encountered an issue when we use these variables in WHERE conditions with - (days). e.g. if we have a criteria to take the date before the start of the week, I would think that this would work. ‘#START_OF_THIS_WEEK#’ -1 but we ended up here with the following error. but, if we use the database method to retrieve the same value here. it works fine. Am I doing something wrong with the use of these substitution variables? or is this a bug? If we use the variables alone they works fine.

How to create an IFS user from command line APIs. We need to create users using the APIs in Oracle. Does anyone know what APIs we need to access? Thank you,

Hi, We have a need to use an Excel Migration job to create multiple quote lines within a Sales Quotation, some of our quotes run to around 600 lines long. Meaning that manual keying in is particularly cumbersome and not very productive. Therefore, an Excel migration job was setup to look to see if we could speed this process up significantly. However, we’ve hit an issue whereby the Unit Of Measure is a mandatory field within the migration job, but we wouldn’t always know off hand what that value was. Again this would mean having to look up potentially hundreds of parts whilst keying the lines in, is there a way to force IFS to do this lookup for the unit of measure when executing the job? We’re currenlty on IFS Cloud 23R1 Any help on this issue would be greatly appreciated! Thanks

Hi Does anyone have a better explanation for the C Query flag then the one IFS gives in the documentation? https://docs.ifs.com/techdocs/22r1/050_reporting/256_br_and_a/005_adhoc_reporting/010_quickreports/#query_flags_and_default_values_for_sql_statement_type

Hi All,This is a IFS Cloud and Aurena Issue.I have a question about how to allow user to enter a value that does not exist in the reference in case of dynamic generated LOV-s. As a reminder, in the case of standard value lists (based on an explicitly specified data source) this is possible by using the "freeinput" parameter:*.projection file:reference CustomerNoRef(Company, CustomerNo) to CustOrdCust6(Company, CustomerNo) { *.client file:lov CustomerNoRef with CustomerSelector using Customers { freeinput = [true] } In the case of dynamic LOV, the field structure is different and for this list of values, the "freeinput" parameter is not available in the client file:*.projection file: reference ControlTypeValueRef(ControlTypeValue) dynamic(ControlType) parent(Company); *.client file: field ControlTypeValueRef { label = "${parent.ControlTypeName}"; editable = [ControlType != "%"]; validate command { variable Description3Var Text; execute { call GetControlTypeDescription(Company, ControlTy

Hi All, I’m trying to configure Excel Plugin Report in cloud but getting a timeout issue. Can you please check the attached file and comment if there is any issue?

Hello, Maybe someone could consult me in permissions stets issue how to switch off the presentation objects in IFS Cloud. I know that there is presentation objects context in IFS Cloud, but then how to deal with the issue described below? For example, for the user role „TEST_1“ we granted the projection „SupplierAgreementHandling“, but do not want to allow execution of the function „Create Request for Quotation“ for that user role: So we didn‘t grant the projection „CreateRequestForOrderQuotationHandling“: In „Managing grants by Commands“ we also see that Request for quotation in not granted: But we still see this function in the Supplier Agreement for that user role: Of course it ends with the error message when executing it: This function in „Suppler Agreement“ form should be revoked for one user role, and should be granted for the other user role in the same form. How to hide such revoked function for one user role and still to leave it visible for the other user role (in the same f

Hi Community, Recently we have started Oracle 12c to 19c Database upgrade and we have used Database export method. After upgrading to 19c, we noticed that the PLSQL Access Provider is showing as red, and scheduled database tasks are not running. We are unable to troubleshoot the issues. Additionally, we observed significant differences in IFSAPP-related objects compared to the 12c database instance. Has anyone encountered similar issues after a database upgrade? Best Regards, Rusiru