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

Hi All, Seems quick report SQL does not allow DBMS_RANDOM.VALUE. Error Message: Forbidden PLSQL code rejected: "DBMS_RANDOM" FNDSQLFORBIDDEN: Forbidden PLSQL code rejected: "DBMS_RANDOM" Is there an alternate to get a random value in a quick report? Cheers!

Hi, I asked this question on openIFS in November. Now openIFS seems obsolete, so I try here. I wonder whether we could introduce fourth layer next to CORE, EXT, CUST in order to allow modifying the PL/SQL packages by the customer. Assuming the customizations would be done carefully, they would survive upgrades to new UPDATE. For the moment I have created new component and I created some procedures which are executed as scheduled tasks. It would be sometimes convenient to modify the logic in some areas specific to our needs. Asking IFS for doing the customizations is much slower. What do you think ? Regards, Marek

Hi All We applied Update 15 and 16 to our Live APPS v9 environment this past weekend. Our users have reported that when they attempt to attach a Document (in this case a PDF, but does the same for all) to a Customer Order (and possibly other records), they receive the following error: This was not the case before applying the latest updates. Checking the defined extensions, all looks fine: Has anyone else seen this issue after applying the recent updates? The issue is also in out Test instance, but we clearly missed this one from our testing! Regards Mike

Installer process get crashed when doing a reconfiguration in TEST environment. reason to do the reconfiguration is that the database has been refreshed from the LIVE environment. not done any changes to the IFSHOME. After the database refreshed, cannot perform the reconfiguration. here I attached the Installer log and the java crashed log. Track : IFSAPP7/JBOSS anyone know the reason for this?

Is it possible to publish IFS10 Business Analytics Excel Client on a windows RDS environment?

We have an issue whereby emails OUTSIDE of our company domain aren’t able to be sent from IFS. An example is where the Purchase Requisition line(s) to Authorize notification sits in a Waiting status with Application Messages with the error message of “Unable to relay recipient in non-accepted domain”. So lets say we want the notification email to go to Hotmail or icloud for example… Is there a way to make different domains accepted?

Dear All, When we press “.” key in Aurena, dialogue is open with commands. Wanted to know if this is a replacement to RMB option in IEE. Please share all the details related to this. Cheers! Thanks

I tried to do it with Event Action on EDM_FILE_STORAGE_TAB but without success

I have created a new Crystal report to be run in the client as a quick report in Apps 10. I have followed the IFS Crystal guidelines and used the stored procedure CR_WEB_INIT. I have made sure it can be run in Crystal as IFSAPP and IFSPRINT and have granted permissions to be able to run the quick report. The issue is that when I run it in the client I am asked to provide sign on information for IFSAPP. Any ideas on how to resolve this issue would be appreciated. Thanks!

Hi All I noticed whilst testing the application of Update 15+16 to our Apps 9 test environment, that after completion, I got the dreaded single sign on Security Error message (see below). Ok, I am sure it is not always SSO that causes this rather generic error, but thats when I tend to see it. If I manually type the domain username/password it works. After previous updates I had not seen this issue. I found that running a straight reconfigure without changes resolved this issue, but find it a little alarming. Has anyone else seen this behaviour after applying 15 or 16? SSO scares me! :( Regards Mike

Hi, We had not problem on Windows7. Recently switched to Win 10 1903/1909 and IFS EE crashing randomly without error to enduser. Windows eventviewer shows event 1000 and 1026 Anyone having same issue? Greetings, Jos 1000 Faulting application name: Ifs.Fnd.Explorer.exe, version: 4.80.33.0, time stamp: 0x5465b84a Faulting module name: clr.dll, version: 4.8.4075.0, time stamp: 0x5dd8a356 Exception code: 0xc000041d Fault offset: 0x0002137a Faulting process ID: 0x5a80 Faulting application start time: 0x01d5d06a41a05e40 Faulting application path: \\193.210.165.190\runtime\Ifs.Fnd.Explorer.exe Faulting module path: C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll Report ID: f92d931e-2780-486f-9615-09f6c3581c2b Faulting package full name: Faulting package-relative application ID: 1026 Application: Ifs.Fnd.Explorer.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Runtime.InteropServices.SEHException at System.Re

Hi - Hopefully I'm in the right area and also I hope that I am not asking a redundant question. I did search forums did a search here. I am working with a view/screen that the user wants a field inserted via column chooser that exists on the form that is used to populate view/screen. Yes, you can create a custom field which inherits the value of existing field on form and have it become a visible column in screen/view. I've already done that and that works. But it's READ-ONLY. This new column/field needs to be editable from screen/view as the field it's referencing is editable when viewing the form. Thoughts? Thank you all for your consideration.

Currently our task table doesnt have anymore spare User_Def fields. is there any other way to add fields to this table or do we have to create a brand new table and link them together? Our sister company ended up creating another table (CUST_TASK) but the user defs all work the same. In the UI designer you’ll see all these in the task selection However were trying to do insert business rules using the CUST_TASK table and running into issues. If we could do this on the task table that would be great but there are no empty user defs left

Custom objects are one of the fantastic functionality IFS application provides. Are there any self-learning materials or any guidance for learning custom object functionality? (Videos or well-maintained pdf or a word document) Some basic examples can be found in the IFS help documentation. But I would like to get a deeper understanding with basics to complex examples of creating custom objects and the standards that we need to follow, the best practices, etc.

Hi All Are there any current versions of Oracle that IFS still supports on app 8 ? Many Thanks Colin

Anyone had this problem with around 600 active users? While the installer is reconfiguring ManagedServer1 logs keeps emitting ####<14-Mar-2020 13:41:03,816 o'clock GMT> <Warning> <FndOracleLoginModule> <PCS-CHE-IFSM-1> <ManagedServer1> <[active] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <92d739a2-9094-47bb-85f4-b3ecafbbe788-00001974> <1584193263816> <[severity-value: 16] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <Password has expired.> and the access.log file emits for each user IP Address - ******[14/Mar/2020:13:41:51 +0000] "POST /fndext/clientgateway/AccessPlsql/Invoke?frmMyWarehouseTaskMain HTTP/1.1" 200 571 While this is going I have check passwords for active users are not expired.

We’re upgrading from Apps9, where we use AD Sync to create IFS users authenticated through LDAP, to Apps 10, which doesn’t have that option. We are actively exploring the other authentication options (ADFS, Azure AD) as well as DB Authenticated. At this time, we have 200+ AD user accounts. Recreating these users as DB authenticated accounts is not an option. Is there a way to change a user that was created from AD Sync to a DB authenticated account?

In the API PROJECT_CONNECTION_TEMP_API there is an Insert method. I don’t know where in IFS this is called from but I need to know. I have searched every trigger, database task and custom event for references to PROJECT_CONNECTION_TEMP_API but there is no mention of it. Can someone tell me where this API is called from? I am using Apps8. Thank you.

Hi, If I make a request to an SOAP endpoint via the IFS SOAP Gateway. Where would I find the response message from the endpoint?

I am currently looking at a way to implement an extra day’s Holiday entitlement for employees with more than 20 year’s service. The maximum limit I can generate at the moment is 25 days. I am trying to raise this to 26. The HOL absence limit considers the assignment type in the employee record: The maximum work time value is 1, Ideally I’d assume that I would be able to increase this to 1.04 but IFS doesn’t allow that. So my question is, where is the figure of 25 days coming from? Is this a default value in IFS? Is it generated from a calendar? Thanks in advance, Tom

Ifs.Fnd.FndSystemException: Utforskare: Ett ohanterat undantag inträffade ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method ManageDocumentObjectConnection/QueryDocRefObjExtDetails ---> Ifs.Fnd.FndSystemException: ifs.fnd.gateway.GatewayException: Exception thrown by handler operation: EJB Exception: --- IFS Extended Server exception stack trace --- at ifs.fnd.gateway.GatewayException.raise(GatewayException.java:112) at ifs.fnd.gateway.client.EJBServerConnection.invoke(EJBServerConnection.java:145) at ifs.fnd.gateway.client.ServerCommunicator.invoke(ServerCommunicator.java:162) at ifs.fnd.gateway.client.IfsClientGateway.doPostImpl(IfsClientGateway.java:830) at ifs.fnd.gateway.IfsAbstractGateway.doPost(IfsAbstractGateway.java:253) [...] at ifs.fnd.gateway.IfsAbstractGateway.service(IfsAbstractGateway.java:186) Caused by: javax.ejb.EJBTransactionRolledbackException: EJB Exception: [...] at ifs.application.objectconnectiontransformutilities.ObjectConnectionTrans

When creating a new instance of MWS I get this error in log: 2020-03-10 11:28:26 Post process IFS Middleware Server 10.3.3.0 2020-03-10 11:28:26 Running ant script F:\IFS\ifs_home\repository\server\install_fndmws.xml, target post for component server [java]: Java Result: 1 Error in Ant-script: server\install_fndmws.xml Reported error is: The following error occurred while executing this line: F:\IFS\ifs_home\repository\server\install_fndmws.xml:262: Failed to configure Middleware Server. Error is: Error when creating IFS Middleware Domain: com.oracle.cie.domain.script.jython.WLSTException: null @org.python.core.Py.JavaError(Py.java:368) Anyone have some tips for solution? It´s a server that had an MWS before but that is removed and now replaced by a clone.

Hello! We’re looking to start using the SOX tools built-in with Apps 9. We work in the US Defense Industry. Anyone got anything that could help out? I have some documentation, but it’s for Apps 10. I didn’t know if people had set ups already that they’d be willing to share. -Kay

Hi, We have IFS Applications 9 and run the application mostly on Win 10 computers. We have a problem with dialog boxes not being “on top”. The dialog box gets stuck behind and locks the entire computer with no possibility to access the task manager or any other application. The only thing to do is to press the power button on the PC. Very frustrating! Anyone have any experience of this problem and (hopefully) a solution? Thanks in advance!

We want to install a new TEST-environment and name it to IFSTEST3 (the copy is from IFSTEST2). I have already made a RMAN restore and have the new DB copy ready. But how to create a new instance the easiest way? We have 139 deliveries and I don´t want to install all these manually.