Archives by date

At the company I work for, we like to customize some basic things on the user interface of Oracle EnterpriseOne. The most important part of this modification is to better indicate that the user is signed into a non-production environment by changing the header color. With Oracle’s release of Tools Release 9.1.5, EnterpriseOne is now using the Alta UI framework. This brings E1 more inline with Oracle’s other software offerings. This change has caused us to redo our UI customizations and also look at how we are doing them.

Below we are going to look at how to Customize EnterpriseOne Tools Release 9.1.5 Look & Feel Using Javascript & CSS.

Since we have 7 separate installations for 7 different companies/industries, we also like to modify the logo in the upper left corner to display our companies’ names. In the past, I would have created at least 3 sets of modified files (1 for each environment). That’s 21+ sets of files because some of the companies have more than the standard 3 environments. You’ll notice from the image above that I changed the header color to purple and the corner image to some text.

Since I work in IT and can’t stand repetitive tasks, I don’t like having different files for different companies. Also, it would be much easier to maintain and easier to remember to make the modification when upgrading, if the companies could all just use the same files. So, to make that happen, I modified the e1.js file. This file is located in a directory on your JAS Server similar to the following:

I tried to use some comments within the Javascript, but if you need some help, either let me know or contact your friendly neighborhood web developer and they should be able to walk you through it and make any changes that you would like.

In a Market of Innovation, Sage and Oracle PeopleSoft struggle to keep up

THE BOTTOM LINE: Enterprise application vendors have continued to invest in making their applications more usable, as buyers expect support for broader user productivity and enablement. With leaders accelerating the pace of releases focused on user interface (UI), mobile, and in-application data to align themselves with Dark Cockpit principles, others have been challenged just to maintain their position.

BOSTON November 6, 2014 Nucleus Research has released the enterprise resource planning (ERP) Technology Value Matrix for the second half of 2014, showing significant shifts in positioning as vendors increase their investments in usability and functionality. Value Matrix leaders are also noticeably accelerating the cadence of release cycles with a focus on user interface (UI), mobile, and in-application data.

Leaders in this Matrix continue to make significant investments in new user interfaces, embedded analytics, and industry-specific functionality that accelerate time to value and drive greater user productivity, said Rebecca Wettemann, VP of research at Nucleus Research. Significant investments by leaders are increasing the gaps between leaders and laggards and challenging others to increase their investment just to keep up.

In addition to industry capabilities that drive faster time to value and embedded in-memory capabilities that make new realms of decision making possible, leaders are investing in new opportunities to make data richer and more current with Internet of things (IOT) initiatives and targeted, optimized mobile applications.

Were seeing IOT emerge as an area where ERP customers can drive greater automation, much richer data for decision making, and more proactive and predictive business execution, said Anne Moxie, analyst at Nucleus Research. Innovators are targeting key verticals and processes with roadmaps and partnerships that make IOT benefits a reality instead of just a shiny object.

Reflecting the advances in ERP, this Value Matrix highlights vendors that have further increased application usability and delivered embedded analytics and industry best practices that support better decision making. In contrast, non-leaders such as Oracle PeopleSoft are being challenged just to maintain their position despite investments in areas such as toolkits and incremental industry functionality. Nucleus also noted several significant shifts from vendors such as QAD and IFS, who moved into the expert quadrant based on their functionality investments.

The full Report is available at www.NucleusResearch.com

About Nucleus Research

Nucleus Research is a global provider of investigative, case-based technology research and advisory services that provide real-world insight into maximizing technology value. For more information, visit NucleusResearch.com or follow us on Twitter @NucleusResearch.

Since our installations of EnterpriseOne were installed and the data upgraded we have applied and installed thousands of ESUs. On 4 of the 7, we neglected to apply the ESUs to the Pristinepathcode (PS900/PS910). This made researching code changes a bit of a challenge.

So, the other day, I decided to rectify that and apply the many, many ESUs to Pristine. Because there were some very old ESUs and not all of them were registered with Change Assistant, it was a very time consuming. After I had finished, I noticed that there were several ESUs that had only been applied to PS & PD and others that had only been applied to PS, DV & PY. Rather than look through every ESU and risk missing some, I connected to E1LOCAL and wrote a SQL statement to get every ESU that had been applied to the system that was not in every pathcode.

SELECT * FROM (
SELECT A.SDPKGNAME AS ESUNAME,
A.SDSUDFUT2 AS SYS,
PS.SDSUDFUT2 AS PS910,
DV.SDSUDFUT2 AS DV910,
PY.SDSUDFUT2 AS PY910,
PD.SDSUDFUT2 AS PD910
FROM F9671 A
LEFT JOIN F9671 PS
ON A.SDPKGNAME = PS.SDPKGNAME
AND PS.SDSUDFUT2='PS910'
AND PS.SDSUDET = '90'
LEFT JOIN F9671 DV
ON A.SDPKGNAME = DV.SDPKGNAME
AND DV.SDSUDFUT2='DV910'
AND DV.SDSUDET = '90'
LEFT JOIN F9671 PY
ON A.SDPKGNAME = PY.SDPKGNAME
AND PY.SDSUDFUT2='PY910'
AND PY.SDSUDET = '90'
LEFT JOIN F9671 PD
ON A.SDPKGNAME = PD.SDPKGNAME
AND PD.SDSUDFUT2='PD910'
AND PD.SDSUDET = '90'
WHERE A.SDSUDFUT2='ALL'
AND A.SDSUDET ='10'
ORDER BY A.SDPKGNAME DESC
)
WHERE PS910 IS NULL
OR DV910 IS NULL
OR PY910 IS NULL
OR PD910 IS NULL