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

Hi Community, While working on our ERP processes, I developed a PL/SQL function to simplify the creation of the attribute variable. Writing scripts can be time-consuming, especially when you creating an attribute like: client_sys.add_to_attr('PART_NO', 'TM-SERVER', attr_); Instead, in this way: p3_ VARCHAR2(32000) := 'PART_NO' || chr(31) || 'TM-SERVER' || chr(30); We can significantly reduce the time and effort required to prepare scripts with the function below. FUNCTION generate_attr_script(p3_ IN VARCHAR2) RETURN CLOB IS output_ CLOB := ''; line_ VARCHAR2(32000); key_ VARCHAR2(200); value_ VARCHAR2(200); pos_ INTEGER; input_ VARCHAR2(32000);BEGIN input_ := p3_; WHILE instr(input_, chr(30)) > 0 LOOP line_ := substr(input_, 1, instr(input_, chr(30)) - 1); pos_ := instr(line_, chr(31)); key_ := substr(line_, 1, pos_ - 1); value_ := substr(line_, pos_ + 1); output_ := output_ || 'client_sys.add_to_attr(''' || key_ || ''', ''' || value_ || ''', attr_);' || chr(10); input_ := substr(input

I know the installation script can grab ACPs from a folder location, but this requires downtime. I know the Aurena GUI application can accept ACP ZIP files, but doing this in a web browser requires a mouse and can’t be scripted. When deploying a lot of ACPs, it’s too easy to miss one. I’d like a process for deploying ACPs in a brutally repeatable fashion (i.e. scripted) without causing end user downtime. So far, I figured out I can POST to this entity set to create a new object: AppConfigPackageHandling.svc/AppConfigPackageVirtualSet This gives me the Objkey to use for GET requests: AppConfigPackageHandling.svc/AppConfigPackageVirtualSet(Objkey='0123456789ABCDEF0123456789ABCDEF') I can’t figure out how to build the correct payload for this PATCH request. The debug consoles in Chrome and Firefox aren’t showing me the request payload. What payload does this ImportFile request need? AppConfigPackageHandling.svc/AppConfigPackageVirtualSet(Objkey='0123456789ABCDEF0123456789ABCDEF')/ImportFi

Hello, We are trying to update a value on some supplier using a data migration job The value is BlockedForPayment and we would like to pass it to TRUE. Trying to implement that using a datamigration job with IDENTITY_PAY_INFO_API.Modify__ method The line is read but value won’t update. If i call the method directly from Oracle SQL Developper the value will update any idea why please? or how to update the BLOCKED_FOR_PAYMENT value please? Thank you in advance

We are experiencing an issue with IFS version 10. We changed the ERP authentication to SSO. In this case, Notify-me keeps expiring the token all the time. Previously, when authentication was done via the Oracle user, this behavior didn't occur. We are using Android for this case. I understand that with SSO authentication, Notify-me should no longer handle token expiration, since the authentication security is now managed by AD (Active Directory) and not Oracle anymore.

For Single Sing On (SSO) in IEE we have the possibility to use IEE Admin page and bypass the SSO mode and login with a user. But do we have the same possibility for Notify Me 10?

I have primarily worked on Data Migration Jobs and Workflows. IFSConnect is unfamiliar to me. Are there any documents or tutorials available that can help me achieve the following tasks? Read a file whose name always starts the same but ends with a different suffix (e.g., filename_timestamp). Process the file and populate either a custom or standard entity. thank’s in advance

It’s easy enough to set a default homepage, but how can we unset the default page so the user is shown the ‘Welcome’ page again with recent screens? I don’t see anything in Account Settings analogous to the IEE homepage that I can clear. Clearing the user profile does not clear the default homepage either. Is there another way? I think I’m going to check the path to the ‘Welcome’ page with another user account who hasn’t made a default selection so I can copy/paste it, but that’s not feasible for everyone.

Hi All, I'm currently attempting to run a migration job in a Linux-based environment. As part of this process, I have created an FTP location on a separate file share server, mounted that path to the Linux database server, and assigned ownership to the Oracle user. However, when executing the migration job, I encounter the following error: Has anyone here performed a similar procedure for a migration job? I'd like to confirm whether I might have missed anything. Additionally, are there any limitations, such as requiring the configuration file path to reside on the Oracle Linux server itself?

Since today morning IFSAPP user is showing the jobs from only one end user. No issues from the IFSADMIN login. Any idea why this is happening? Tried clearing the query Clearing the IFSAPP profileClearing APP data cache. But issue remains the same.

We have a prblem when trying to open URL links from Lobbies in App9 WHen we click the link, we get and users are stuck. They can get round it by cpying the url and pasting into a browser, but that is a faff on. If we put the same link/URL into a menu item, that works perfectly, because the menu setting has to ption to use an external browser I can only assume IFS was written to use Internet Explorer and knows nothing about other browers. Does anyone know if there is a way to get Lobby links to open in another browser? Thanks Roger

Hi, A customer is using Tableau reporting tool and they are asking if Tableau can be configured to work with IFS Cloud. Has anyone setup Tableau to work with IFS Cloud? Scott

Hi, all. We’re trying to move from 23.2 to 24. In the correct path, using the correct YAML files. .\installer.cmd --values E:\[CORRECT PATH]\ifscloud-values.yaml --values E:\[CORRECT PATH]ifs-cloud-24.1.0-paqara3-5.0.0-20240619T133210Z-success\InstallationFiles\solutionset.yaml --set dbinstaller.sysPassword=[CORRECT PASSWORD] We’re getting this error, but we’re definitely on 23.2. Has anyone experienced this? Why doesn’t the installer recognize the correct version? [Tue Jul 30 12:45:26 EDT 2024] - SEVERE: The delivery not in sequence! Last delivery installed is ifs-cloud-23.1.5-paqara3-2.0.0-20231103T130434Z but expected is ifs-cloud-23.2.2-paqara3-4.0.0-20240213T220018Z[Tue Jul 30 12:45:26 EDT 2024] - SEVERE: Validation failed. When I login to IFS, it definitely says we’re on 23.2. Ideas? Thanks!

Hello Everyone, I was wondering if anyone has any experience with the Column Visible and/or Visible flags on the attributes for custom fields? I have added a field on the Customer Order Lines Tab of the Customer Order and I have tried both of these attributes with record.Contract = “XX” or record.parent.Contract = “XX” and no matter what combination I try, the field shows up regardless of the Contract value. This Visible attribute works like a charm on groups. I can make that work fine, but on lists columns it must require something different as I can’t get it to work. Edited for clarification just in case. This is what the “Column Visible” flag actually has in it. Same thing has been done for the “Visible Flag” Thanks for any help or insight that you can provide.

Hello. On the shipment screen (url : ifsapf:frmShipment_Ext ), I would need to make an event when the user runs the deliver process to forbid the delivery when the total amount is less than a certain amount. How can I make such an event? I don’t even see what might be the triggered table.

Hi all Seems in 24R1 that the copy selected rows is no more allowed in the Posting Proposal projection while still there for other screens. Did anyone encounter the same ? Is it a feature in 24R1 ? Thank you This is no more existing in the Posting Proposal projection (Lines or Posting Lines) : For example, copy selected row exists in Authorizer projection :

Hello, I have a question. I noticed that on the CUSTOMER_ORDER_JOIN view that the SITE security was removed in IFS Cloud. This means that if a user can see all of the customer order lines even if they don’t belong to that particular site. I noticed that the site security was still available on other views (CUSTOMER_ORDER, SORDER_QUOTATION,PURCHASE_ORDER, etc.). I was wondering why was the site security removed from CUSTOMER_ORDER_JOIN (Customer Order Lines) in Cloud but other views kept it? Thank you.

Hi, Does the “Facture-X”, “UBL” and “CII” file format are managed by ifscloud for e-invoicing? thanks

Hello Experts, We want to change the label of the tree structure navigator on some pages ie: Project Deliverables Design page. Currently it is showing the “item no - Item Name”. However we want it to show the “Part No - Part Description”. How can we do this? We tried changing the label for the selector in Page Designer, but it didn’t change anything. Appreciate your advices/tips/suggestions. Thank You in Advance,

Hello everyone, We have frequently encountered the following pattern in IFS SQL traces: DECLARE result_ background_jobs_handling_svc.entity_dec; BEGIN result_ := background_jobs_handling_svc.crud_delete('*', 8189760, 'DO', deferred_job## => '');END; We would like to know how to execute the following directly from SQL Developer: background_jobs_handling_svc.crud_delete('*', 8189760, 'DO', deferred_job## => ''); When attempting to execute it using a SELECT statement with dual: select Background_Jobs_Handling_SVC.CRUD_Delete('*', 81897606, 'DO', deferred_job## => '') from dual; We receive the following error: https://docs.oracle.com/error-help/db/ora-00902/00902. 00000 - "invalid datatype"*Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid.*Action: Correct the syntax.Erreur à la ligne 1, colonne 8 Any idea please?

Hi all, I hope you all doing well. In my IFS developer studio there is no options for select IFS projects. How to fix this?

Hi, is there any possibility to enable/disable the Edit/Remove buttons in the Card based on a condition using the value from one of the fields in the Card? Thanks

Hi All, I need to create a json payload inside a workflow to send to an external Rest API. I used the org.camunda.spin.Spin.JSON according to the camunda documentation. Below is my script var SpinJSON = org.camunda.spin.Spin.JSON;var jsonObject = SpinJSON("{}");var customerId = execution.getVariable("CustomerId");var eventType = execution.getVariable("ifsBpaProjectionOperation");jsonObject.prop("CustomerId", customerId); jsonObject.prop("event_type", eventType); execution.setVariable("varJsonBody", jsonObject.toString()); In the Debug mode, everything looks fine Trigger for this is an event and we are trying to sync customer records with a 3rd party system But in the execution, it gives an unexpected server eror Looks like it Spin.Json prop() doesn’t work. Is this a bug? IFS version: 24.1.3

We are a fresh migrant from IFS 7.5 to Apps 10 UPD11 (we know, update soon). Disclaimer that I’m very beginner level with IFS, so please bear with me. We had a custom event written for our 7.5 environment to email customers when a customer order was marked as delivered. We understood this may be a standard function in Apps 10 and would like to recreate this. However, when I go to create an event action, I’m puzzled what to use for the “TO:” field. We aren’t using a report for this - just a simple body of text to a customer specific email address notifying them that an order was delivered including the number of that order. I see in “available substitution fields” that we can use variables to insert, but as usual, they are not clearly defined/labelled/documented so we don’t know what they are or where they are configured. Ideally, each customer would have a “contact” or address defined that would receive these notifications. From what I can see, we would have to create a new event actio

Hi IFS Community, We have set up a demand plan server in a remote 24R1 environment. The demand plan server components is also installed inside the database server (windows). The demand plan server is up and running. Below is the output when we navigate to the Demand Plan Server Metrics URL.(http://DP_SERVER:PORT/metrics) According to the technical documentation, the above should be expected output after a successful installation. However when we try to login through the demand plan client, the below error was noticed. The user which is logging in has been granted access via the ‘user demand access’ window on the ifs application. Has anyone noticed a similar issue before? Your input is highly appreciated.

Hi all, I'm having a set of data as shown in the below table. Stock count according to the type for each month Currently, this data is showing in the lobby as below where it splits according to the type for each month. But, I actually want the y axis to be split according to the type for each month. In this example i’d want it to look like below. Is there any feasibility of getting a chart like above in IFS lobby? If so, any ideas on how we can do it? Thanks, Sachinthani.