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

Hi, Community, Would like to borrow your mind, what is below error tells us? basically what we should do avoid it from happening in the future? 

The customer has created a new custom field based on another custom field in the same entity. The sql query is validated successfully. But when publishing, it gives the following error. In other posts which has reported the similar error had mentioned about the query returning null values could cause this error. Hence I’ve modified the query as below (PRIORITY is a NUMBER column). SELECT nvl(PRIORITY, 0)FROM ifsapp.CUSTOMER_ORDER_CFVWHERE ORDER_NO=SUBSTR(:CF$_ALIMEX_ORDER_NO, 1, INSTR(:CF$_ALIMEX_ORDER_NO, '-') - 1) But it still causes the error.Could someone please assist what could be the issue here?

Sometimes single configuration item needed to be imported.Follow below steps to achieve this.Investigate the item type and item name of needed itemExample: ShopFloorWorkbench Client Configuration got deleted Download the backed-up ACPFrom files locate the correct item like below Now go to Application Configuration Package/s → ImportSelect import configuration Now select the item file identified above Using this way is much safer than importing a bundled ACP. 

in cloud, a package created by PL/SQL Developer, how to make the procedure be available for projection custom action method and database task?

Hello, To design a customer project solution, we kindly request the following information. Please feel free to add your comments.1. Are custom fields still unsupported in 'Virtual' entities?2. Is there any documentation available on this topic?3. Is there a planned release date for custom field support in virtual entities and assistants?Thank and Regards,Pasindu

Assume an APP10 MWS horizontal cluster with following setup2 VMs1st VM - Main Node- HttpServer1- MainServer1- IntServer12nd VM - Secondary Node- HttpServer2- MainServer2- IntServer2What is the correct way of installing deliveries from below methods?Method 1:- Install delivery from main node- Stop all MWS servers- Create cluster.zip from cluster.cmd in main node- Delete secondary node- Unzip cluster.zip to secondary VM- Start services in main node- Execute cluster.cmd in secondary node with "create" option to create servers in secondary nodeMethod 2:- Install delivery from main node- execute existing cluster.cmd in secondary node with "update" option What are the best practices of installing deliveries, since most of the time there will be issues when starting servers?Are there any APP10 technical documentation on this? If available, please share.  

Hi All,I have created a custom entity that contains a saved image URL. I need to display the corresponding image on a custom page. How can I achieve this?I tried using the 'Image' control, but it is not working.

Dear All,Is the "ORACLE GOLDENGATE ARCHITECTURE" supports in IFS CLOUD 24.R1.SU3.If YES, pelase share us your recommendations for FULL flugged ACTIVE(APP/DB)/ACTIVE(APP/DB) & with DR Architecture from two different geo region with live sync using ORACLE GOLDENGATE ARCHITECTURE.

The documentation from 21R2 hinted at a great feature we could use:https://docs.ifs.com/techdocs/21r2/020_installation/010_installing_fresh_system/010_planning_installation/010_storage_tier_considerations/010_oracle_db_19c/ Oracle Edition-based Redefinition¶Beginning with IFS Cloud 21R1, IFS offers framework support for Oracle Edition-based Redefinition.Oracle Edition-based Redefinition (EBR) allows online application patching and upgrades with uninterrupted availability of the application. When the installation of the upgrade is complete, the pre-upgrade application and the post-upgrade application can be used at the same time and as soon as there are no sessions any longer using the pre-upgrade application, it can be retired.Note, framework support implies that all editionable objects meet the requirements for EBR and they are, from a database perspective, handled as if EBR is used in IFS Cloud. However, full support for EBR in IFS Cloud and the possibility to apply online service up

Today I’m trying to migrate data into INVENTORY_PART_UNIT_COST using a Migration Job (Migration Type = INSERT_BY_METHOD_NEW). I configure the job and map my fields as usual, but upon execution of the job ALL 3,054 rows fail with the error ORA-01003: no statement parsed.  No additional error descriptions, just No Statement ParsedI tried running this as a Background Job and looking at the job output but nothing useful is displayed there either.Is there something obvious that I’m missing? is this type of error an indication of something in particular? Any ideas on how to troubleshoot this? Thanks!

Hi All,I’ve been doing some testing with IFS Cloud cluster setup in 24R2. The issue I’m facing is that kubeconfig is only created for one node, even though 3 nodes are defined. Due to this limitation, powershell cannot connect and issue any kubectl commands if the first node is down.My expectation was that the kube config would include all 3 nodes or at least have 3 config files, but it doesn’t appear to be the case. What is the process to manage kubenetes when the first node is down? What is the way around of this?

Hello,we created a query using the query designer, but the parameters don’t show up in the Lobby Datasource Designer like mentioned in the 24R1 technical documentationhttps://docs.ifs.com/techdocs/24r1/040_tailoring/250_lobby_configurations/030_datasource_designer/020_Projection_Datasource/#data In the Query Designer the preview generates results correctly, but in the Lobby Datasource Designer the parameter section is missing  The preview in the Lobby Datasource Designer also gives an “Unexpected internal server error” IFS Web Version: 24.1.6.20241106081345.0Date: 2025-03-10T12:44:48.715Z---------------------------------------------------------------------------<none>/<none> (server error)Unexpected internal server error occurred.Error details: N/ARequest Id: 9bcecd51-ee96-4b57-a2ef-dfbd4d67d43cUrl: https://ifs-mig.maximator.de/main/ifsapplications/projection/v1/QueryProjectionXX_HR_EmployeeChange.svc/GetXX_HR_EmployeeChange()?$select=CountOfEmpNo,Lname,Fname,CompanyId&

Is there any reason why multiple Build-Homes can’t be used in the Remote Use Place to manage multiple Middle Tiers? For example, one Windows server would have multiple “ifsroot” directories, each one would be pointing at a different set of servers.I have found the following article Frequently Asked Questions (FAQs) on IFS Cloud Remote Deployment | IFS Community however it is 3 years old and refers to 22R1; does the same apply i.e. Logging would be the only issue or has that changed in later releases?

Is anyone aware of what fields IFS is using to calculate shop order op scrap?

Hello, We are unable to add a custom action to an autogenerated projection:  Is that possible? Thank you in advance

Hi, In IFS cloud is there a way to change the default date. For example in the customer order screen the default date for the field wanted delivery date is set to the current date, is there a screen in IFS Cloud were we can manually choose what the default date is set to? Instead of using current date we would like to change it to something like a week from today (SYSDATE + 7)

Hi Everyone , We are trying to connect PSO with IFS Cloud using IFS Optimization Framework Configuration Assistant. When configuration finishes all validations get successful, but Test connection fails saying ‘Failed to connect IFS Optimization Server’. Also gives below error to set data manually : Failed to connect to IFS Optimization server account Default. Error message was: 400 - Bad Request. The user IFSSCHEDULING and the parameters OpenIdAuthority, OpenIdClientId, UserNameClaim may need to be set up manually. Do you want to continue?Did anyone came across similar situation and can guide me solving the same? Regards,Nandani

 Hello Team, I have trouble to filter using “In Range” Option.When I try to filtrer by the method “In Range” and I write those informations it’s working.But after saving the query and trying to reactivate it shows me this error (screen 2)Do you know how to solve that issue ?I tried upper case, lowercase, changing the date format etc etc everything I can find in the Community but the issue still remains.Please help me  

Hi, i am trying to release purchase order with a REST call,i made an event action but i get the following message error : ExecutionException from Sender thread Caused by: java.lang.StringIndexOutOfBoundsException: begin 0, end -1, length 11 any one have an idea to fix this error ?Regards.

HelloI want to prevent all users from export data at all for any pageI can’t find any command related toPlease Advise.Thanks.  

Hello, Our client’s need is to be able to create users automatically (with all the related configurations ex site user, buyer, Procurement, Authorization, finance user, user group etc).Right now its a tedious task since it takes about 4 hours to ensure that all related parameters are configured.Is it possible in IFS cloud for automated process ex duplicate an existing user where all the paramters/configurations are copied automatically to a new user ? Client environment is now on IFS cloud 24R2. Thanking you. BRLakshmi 

I mean Workflow/BPA, Custom Events.For example to dynamically set default value to the field or column in Assistant (just an example).  

We are trying to customize the Barcode Label report which can be executed from the Shop Order screen:   The problem is when looking at the database to see the database view INVENTORY_PART_BARCODE, it does not contain the shop order number.  I am a little confused why this key information is missing.  Does anyone know how to link back to the shop order number for a report like this one?

in cloud, is there any quick way to generate configuration page? no need add field element one by one. in IFS10, if the custom logical unit have 20+ fields created, I can generate table/form page soon.like below IFS10 screen, I just add one custom pages record, it can generate a page soon. 

Hi,When IFS Cloud starts the user has a starting page which is also where the “blue house” sits. The user can then themselves change the starting page.What I would like to know is if we can centrally control which starting page the user should be on when logged in for the first time.The problem we are trying to solve is the following: The customer wants to build their own lobby page with links to other lobbies and with the ability to put in some information text if needed. The lobby will be adapted so that it works well on a phone.When the phone users log in the first time we want to put them on this lobby page hence it would be useful if there was some sort of user setting for this or some sort of system parameterWe really miss not having the base profiles in the system this would typically be the place where it would be solved if they were on Applications 10The Customer is on IFS Cloud 22R1 and expect to go live in April.