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

HelloIn the enterprise explorer in the advanced search we could use SQL Code like the attached example. What is the correct syntax to use it in Aurena?

I am trying to organize a dropdown of basic data alphabetically rather then the sequential number given by IFS.  I see there is a sortable selection under page designer but it doesn’t seem to do anything.  The end game is to get contact roles organized alphabetically. Any help would be appreciated.  

Hi,How can we find whether an IFS App8 application is SP1 or SP2, if it is not specifically mentioned in the landing page link ?Can it be determined based on the client version (see below pic) specified in the About information ? Or can it be found in somewhere in the application ? Thanks, 

We are running IFS 10.This is related another topic , since issues more cleared I’d like to create a new topic to get some helps.After tested with several scenarios, we found when processing is executed for 4 minutes or more, client (IEE) will lost response.It is only happens on clustered application server and database server environment. We use Azure Application Gateway to load balance accesses on Application Server, and use Azure Load Balancer to provide a stand-by database service.Environment and idle time setting:There is a timeout setting on the Azure Application Gateway (Application Server side), and currently it is set to 2 hours on the AGW. Since 7200> IFS setting value 5400, it is recognized that there is no problem. Azure Load Balancer (DB server side) TCP idle timeout is 10 minutes.Details of Issue:1st: Application server lost response from database when using Azure Load Balancer when processing is executed for 4 minutes or more.  Even if we have set Load Balancer TCP Re

Hi Community, I’m currently facing a customer demand to handle authentification through OpenID with Keycloak with IFS APPS 10.I know current supported authentification method are AzurAD, Adfs, DB.However have anyone of you already implemented authentification with Keycloak (Kerberos is also an option)  ?Thank you

Hi,Can we possible to delete a csv file which is located in database server using a custom event?File is located in this path. That csv file is created due to migration job failure. But customer needs to delete that file from db server before the next file will be come to db server.Thank you,Malan Jayanka

Hi, We recently changed our file server IP address, we were using the Shared option in file repository to store the documents on file server instead of database. How do i change the server ip address.Is it delete and reenter the path.

How does IFS Connect work , incase if i want to parse the file stored on remote network share or ftp server and write it onto a temporary table in IFS.

I know Oracle 19c is certified for Apps10 UPD6 and above.  Is Apps10 UPD11 supported on Oracle 19.8 yet?

How can I add custom field to Visual Shop Order Planning pageWhen you click operation you get card open, how it’s possible to add custom fields there?IFS APPS 10 UPD 10  

We have started an upgrade from App9 to IFS Cloud (2021 R1) along with replacing SAP.Although the Aurena client has loads of new cool features, there are couple of user friendly features in IEE which our users are heavily rely on in their day to day life.Advanced search with group by functions Conditional formatting Sticky notes Shortcut keysOur business is highly relying on these functions and we are having hard time getting the buy in for Cloud.Can we expect these features in later releases or are they any workarounds/new features which can support these?

Hi, Please give me some advice on how to debug effectively the PL/SQL side of an incoming OData REST webservice request when the input is a complex structure. As long as there are some simple parameters to the request, it is fine, I can specify them in the test window of PL/SQL Developer.However, it can be quite painful to build a complex structure (like several customer orders and their lines and their child rows) in PL/SQL before calling the request. Ways I tried:Remote debug with Oracle SQL Developer → could not get through the error: ‘insufficient privileges’ for DBMS_DEBUG_JDWP package (I granted everything and added ACLs) Tried to find within IFS how the conversion of JSON to Oracle types are done - that way I could copy the JSON part of the request to the test window of PL/SQL Developer, where I would convert it to the proper Oracle record type that is defined in My…._SVC package and pass it to the the appropriate method in My..._SVC packageAny recommendation is welcome.Thanks J

Hello,Can anyone provide the IFS Apps 10 recommended architecture diagram please?We would like to see the various servers involved and how they interact.RegardsShaun

We would like to get data from external source. We are using App 9.4. The data will send via XML. We are trying to understand consept of webservice. We started with settings of IFS. We set INBOUND as RECEIVER. There are a lot of way to do that. So we confused. We will create a new package and develope new page for it. What should be order to complete this task?   

If you're getting the following error while trying to import a SSL certificate to IFS Application, this article may help solve your issue. Parameter Error: Certificate verification failed. Path does not chain with any of the trust anchors.  Solution If you're trying to protect a *.corpnet.ifsworld.com internal service or *.ifsworld.com internal service, you must be using one of the following example certificates within the installer which can give the above mentioned error.wildcard_corpnet_ifsworld_com_2023-06-02.pfx wildcard_ifsworld_com_2023-06-02.pfx If you had selected one of the certificates like above certificates (Date of the certificate name may subject to update), use the one of the following certificates where the certificate name ends with _kcc.pfx and try again.wildcard_corpnet_ifsworld_com_2023-06-02_kcc.pfx wildcard_ifsworld_com_2023-06-02_kcc.pfx Providing one of the certificates like above example certificates (Date of the certificate name may subject to update) will so

If you're getting the following error when opening a large Heap dump file via Eclipse Memory Analyzer (MAT), follow the steps given to solve the issue.  ProblemError when opening larger Heap dumps. ReasonEclipse Memory Analyzer does not have enough heap space to open the Heap dump file. Solutionopen the MemoryAnalyzer.ini file change the default -Xmx1024m to a larger size (Ex: Xmx2048m)Now you’ll be able to open the Heap dump file.  Hope this helps. Cheers!

Please help how to find details of base profile in back end .. i cant see any views in system info 

I need to be able to use this API for the Consolidated screening list here https://api.trade.gov/apps/store/apis/info?name=ConsolidatedScreeningListAPI&version=v1#tab2.  Does anyone know of way to do this in IFSAPPS9?  It uses Bearer Authentications so uses Access tokens in the API request. Bascially what I want to do is at time of customer order entry, check to see if the customer is on the list and log that in order line history and give the user a message if it is on the list.

Hi By default when I try send report to email address I receive message as follow:The archived PDF file for Inventory Count Report report is ready and is attached in this mail.Customer wants this message in pl language but I can not enforce it.I checked following:1. OS locale is pl2. Solution Manager\Integration\IFS Connect\Setup IFS Connect -> Task Templates: PROCESSING_PRINT_JOB - locale is pl3. No print agent configured4. No reporting rule defined for specific report5. pl translation exist in Fndbas_Java-Core-pl.trs6. report locale is also pl7. IntServer1 is restartedDo I miss something or this is standard feature(or bug)?  

In the Entity-model we have the information if the access to a record should be restricted. (XML-Tag ‘DB_ROW_LEVEL_SECURITY’) While most information from Entity-model is stored in DICTIONARY_SYS_xxx, I can’t find the information from DB_ROW_LEVEL_SECURITY. Does anybody have a hint for me where this information is stored in the database?

  Hi All, Data is constantly increasing in APP9 tables SEGMENT_NAME OWNER SEGMENT_TYPE Size(MB)SYS_LOB0000071125C00006$$ IFSAPP LOBSEGMENT 11959.13 <<<<<<<<<<<<SYS_LOB0000070639C00009$$ IFSAPP LOBSEGMENT 6274.19 <<<<<<<<<<<<SYS_LOB0000071118C00005$$ IFSAPP LOBSEGMENT 5834.19 <<<<<<<<<<<SYS_LOB0000070604C00011$$ IFSAPP LOBSEGMENT 3135.19 <<<<<<<<< OWNER TABLE_NAME COLUMN_NAME SEGMENT_NAME TABLESPACE_NAME CHUNK CACHE LOGGING SEC SEG RETENTI RETENTION_VALUE------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------IFSAPP PDF_ARCHIVE_TAB PDF SYS_LOB0000070639C00009$$ IFSAPP_LOB 8192 NO YES YES YES DEFAULT >>>>>>>>>>>>>>>>>>>> 6274 MBIFSAPP FNDCN_MESSAGE_BODY_TAB MESSAGE_VALUE SYS_LO

The corresponding application message of the queue NOTIFICATION errors out with the following error when the recepient email address contains control characters (Ex : web­mas­ter@​minimax.​de) or umlauts (Ex: web­mas­ter@kältetechnik.​de). Error while sending data… Caused by : javax.mail.internet.AddressException: Domain contains control or whitespacesHowever, lot of our customers have umlauts in their email addresses, and it’s not clear which javax package IFS users within the framework for email sending, and supports which RFC versions.(Ex: is it javax.mail:mail  or com.sun.mail:javax.mail , etc)Do we have a pre-defined set of characters which should be escaped (marked as invalid for use within IFS emails) or if there’s knows control character limitation (or double-byte character limitation)?

I made some changes in existing page using the “Page Designer” in IFS Aurena. But I cant see the page called "Configured Pages", to add my configuration in to a ACP. I'm login as IFSAPP.https://docs.ifs.com/techdocs/Foundation1/045_administration_aurena/220_Configuration/450_configuration_lifecycle_management/100_Import_export.htm

Hello all, I need to remove or hide those Area, inside the red Lines at the belong picture (in the application version 10.10)I Want to see only form for handheld terminal.Is there any way u think? Best regards.  

Hi, Does anyone knows why we get runtime error while pressing the search in the “Change Order Summary” view?We have tried to open the Debug Console, and not sure if that was due to the resource file not being loaded: We don’t get this If we are using the Application Owner. The details of exception are:“Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> System.NullReferenceException: Object reference not set to an instance of an object.   at Ifs.Fnd.Explorer.Extenders.SearchExplorerManager.SearchExploreManager.Ifs.Fnd.Explorer.Interfaces.IFndSearchExploreManager.ShowSearchDialog(FndSearchDialogSettings settings, FndClientSearch& clientSearch)   at Ifs.Fnd.ApplicationForms.cDataSource.DataRecordSearchDialog()   at Ifs.Fnd.ApplicationForms.cDataSource.DataRecordQueryDialog()   at Ifs.Fnd.ApplicationForms.cFormWindowBase.DataRecordQueryDialog()   at Ifs.Fnd.ApplicationForms.cFormWindowBase.vrtDataRecordQueryDialog()   at Ifs.Fnd.ApplicationForms.cDataSour