Last Updated May 26, 2011 Oracle introduced the JD Edwards EnterprisOne Kernel Information Center! There you can find links to all things related to kernels, IPC, PORTTEST & UNIX OS kernel sizing – all the things that make JD Edwards EnerpriseOne run. You can work with the links along the left side of the page ...
You can start/stop the managed agent from the command line (green screen) by following the steps below: Start the QSHELL by typing STRQSH at the command prompt. Change to the JDE_HOME/bin directory by typing <install_dir>/JDE_HOME/bin. *** The <install_dir> refers to the installation directory in the IFS To start the agent enter: startAgent & *** The ...
To find out what users or groups have access to a certain environment run the following SQL: select * from sy811/f0093 where llll='<enviornment>' To find out what environments a user or group has access to run the following SQL: select * from sy811/f0093 where lluser='<userid>' ...
Oracle released the October 2008 Critical Patch Update. This update contains 36 new security fixes across 20 different products. A piece of EnterpirseOne, the Business Services Server, is included in this update. Oracle CPU – October 2008 Oracle CPU FAQ ...
Whether you are trying to change the processing options of an interactive version or a batch version. Sometimes you can run into issues where the application indicates that you do not have authority to change the version like the example to the left. To quickly get around this error, we can use SQL to change ...
We have our passwords set to expire every 90 days. Sometimes there are user IDs that you don’t want to change but don’t really want them to show up on the audit report as not having an expiration period. Here is a SQL statement that can help you: UPDATE SY811/F98OWSEC SET SCSECLST=<numeric date> WHERE SCUSER='<UserID>' ...
My current employer is a publicly traded entity. As such, we are subject to SOX regulations. Because of this we run many reports periodically to satisfy the auditing department. One of those reports determines if there are any terminated employees that still have active UserIDs. Here is the SQL that is used for the report: ...
We had an issue over the weekend… We built an update package successfully. However, we were unable to deploy it. The R98825D just kept running and running. It wouldn’t end. We did all the normal stuff: Stop services Delete SQLPKGs Start services Reboot Deployment server Deploy to a different port (we are using multi-foundations) Nothing ...
One of our installations of EnterpriseOne utilizes a piece of software from AllOut Security. ALLOut Security is an Oracle Partner and produces software that helps those that are responsible for World & EnterpriseOne security. During the application configuration phase of our implementation project we didn’t have users dedicated to the project. They not only had ...
One of the biggest things that the E1 security screens lack is the ability to see what users are in a particular group. So, here is the SQL that you can use: select * from sy811/f95921 where RLFRROLE = '<E1Role>' Pretty simple… but, helpful! ...