Thursday, 22 December 2011

SQLServer table sizes and myArchive–native JDE data archival

This sort of information is priceless for comparative purposes.  This shows you a large installation of JDE and the size in rows and indexes and data for some of the largest tables.  The site will remain anonymous, as that is not important.  The relative size of the data is.

 

Table

Description

Rows

Reserved (MB)

Used Data (MB)

Used Index (MB)

F0911

Account Ledger

33271646

97354.38

32459.38

64810.5

F42199

S.O. Detail Ledger File

22424807

49727.8

45365.96

3923.2

F42119

Sales Order History File

6241321

22161.11

12260.99

9895.19

F4074

Price Adjustment Ledger File

27626864

20234.54

15417.78

4816.63

F49219

Sales Order Detail - Tag History File

24002854

18827.85

18752.41

75.18

F43199

P.O. Detail Ledger File - Flexible Version

9110611

18126.79

14235.55

3888.71

F4111

Item Ledger File

10363396

16472.47

8095.88

8374.5

F03B21

A/R Notification History Detail

23782360

14720.53

13271.45

1448.66

 

So in SQLServer a 100GB F0911 is about 35 million rows.

What else does this information tell me?

Of the 570GB of data in production 260GB (about half) is in the 8 tables above!

All these tables are susceptible to table scans.  All data above needs to be backed up and restored for copies of production.  This data spread is ripe for myArchive.  myArchive is the myriad JDE archiving solution. 

Some quick facts about myArchive

•Access your archive data using JDE screens and reports natively

•The ONLY change to the production environment is the removal of data. This removal must be vetted by functional people and tested thoroughly before implementing into production.

•The archive environment is read-only, no changes to archive or production data can be made.

•The archive data can sit in a different database or different schema within the same database.

•The process is completely reversible, if you want the archive data put back into JDE, the process can be run in reverse.

•Upgrade time will be quicker and easier. When it’s time to upgrade JDE, it’s simple to upgrade the archive data separately to the live data. This will ensure that the upgrade is completed on time!

•Using server and client specific scripts and criteria ensures the most efficient solution for each client’s needs.

•This can be achieved with NO additional software or hardware purchases

•Your archive environment allows you to have native E1 access to the superset of archive and production data.

What happens with a myArchive project:

image

myArchive gives you Native JDE access to all of your archive data and transactional data.  myArchive gives you all JDE screens and reports to query your data with.  You do not need to set up data warehouses and custom queries to interrogate your information.  You just use JDE.

We have customers live on this solution –  working in a production environment with half the data that was previously there.

Use our contact page to get more information on myArchive.

Thursday, 15 December 2011

My first impressions of 9.1

Wow!

I think there are some great changes that make the application much easier to use.  Remember, I’m technical and my limited application experience might sway my thoughts in different directions.  First I like it, it’s very clean and crisp.

image

The tabs down the bottom are controlled with cookies, so it remembers what you were using last time you where in the application

I still jump left for fast path, but I like the new position.

Enhancement to my favourites? Please

There should be something under tools for “Add to favourites” when you are in an application.  I fast path to many applications (maybe all) – but I’d love to add them to my favourites…  How – cannot do it.  I still need to traverse the menus.  If one of the JDE design Gods reads this and thinks “That does not really breach our UI design guide lines”, let me know when it’s in.

image

This is a bit of a diatribe and I should not digress so readily with my wants.

What else is cool

General

it works with google chrome (well it did with 8.98.4.5 too, but this is good for me)  I’m addicted to chroming!

Inline lookups are excellent and a long time coming.  Who else forgets what they are looking up or why?

I believe that the application is faster!  We have it running locally and internet based and it really flies.  I’ve been super impressed with the interactive performance.

WSJ

WSJ I use a lot, a couple of small changes are great.  Firstly goes straight to the list of jobs – great (uses default UBE OCM).  Secondly it has “clickable” fields to view the PDF.  No slowing me down with click row, click row exit, view PDF…  Print with the click of a button too.  Drag and drop of columns is super simple.  Create your own fast and easy to use grid!

image

Advanced Query Functionality

The ability to save custom queries on any form is very powerful

image

So I only want to see the jobs for today – you can do it!

Only R0010P from today, no problems either.

image

So I now have these tabs on WSJ to quickly look at the jobs for today and yesterday!

image

These are saved as AQ type records in user overrides.  You can copy them to all your users.

How about this for a new default for Public?  My jobs that were launched today!

image

Perfect!

Auto Suggest

You now have the ability to create “auto suggest” lists from any field with config not code!

You need to be 9.1 application release – what a tease!

image

Pages and flows

Powerful graphical representation of flows and processes.

Oracle is making it easy to graphically represent a business flow with a highly configurable framework.

Turn this:

%Financial Planning Forecasting and Budgeting%
@A:Forcast Growth Patterns\runE1App('P1406','W1406A')
@B:Assign Patterns to Business Unit\runE1App('P1405','W1405A')
@C:Generate Forecast Basis\runE1UBEBlind('R1403','XJDE0001','0')
@D:Generate Forecast Results\runE1UBEBlind('R1404,'XJDE0001','0')
@E:Apply Forecast to Budget\runE1UBEBlind('R1407','XJDE0001','0')
@F:Requested Budget\runE1App('P14102','W14102A','ZJDE0001')
@G:Approved Budget\runE1App('P14102','W14102A','ZJDE0002')
@H:Final Budget\runE1App('P14102','W14102A','ZJDE0003')
@I:Budget vs. Actual Reporting\runE1App('P09210A','W09210AA','ZJDE0001')
A--->B-,
|
C-'->D--->E-,
,-------------------'
`->F--->G--->H--->I

image

Which can be seen from the users landing page!

We’ll be looking at these in more detail soon.

Wednesday, 7 December 2011

Twitter me this, twitter me that…

I’ve finally got onto the twitter bandwagon, and am very impressed by the medium of information dissemination.  I think if you want to keep up to date with the latest and greatest, twitter is the way forward.  I’m now going to be posting all my blogs to the Myriad Website (and to here), but also tweet the Myriad links. 

Use the above link to follow MyriadIT and you’ll find out the blog posts as soon as I make them.

Tools release 9.1 is GA

Read more here:  http://www.oracle.com/us/corporate/press/1397069

I’ll be providing some value add analysis on the tools release and the improvements over the next couple of days.

Thursday, 1 December 2011

E1 upgrades, where’s the ROI?

Introduction

I’ve said it…  Now who is going to put up their hand and answer the question?  “Where is the ROI in my ERP upgrade?” Why is someone going to take a 9.02 application upgrade at the moment?  Why is a client going to wait around for 9.1?  There are not many function reasons for doing so [of course 9.1 might blow our doors off].  There are a LOT of technical benefits though, all of which are exposed by the advances in tools releases and supported technology.  The expansion of “oracle technology foundation” has also played a large part in giving customers a reason to upgrade.

I’ve been involved with a number of pitches to clients, where the question (The elephant in the room) is asked – tell me why I should do this?  Tell me what I will gain from this upgrade?  Unless they have specific functional needs – which I will address in some detail, the answers are going to be based upon technology, supportability and compliance.

Very rarely these days the IT departments of large organisations have their own budget for an ERP upgrade, so getting the mandate for an application upgrade needs to come from the business.  If IT do get the budget, you can be sure that this will be based upon compliance reasons.  The business does not easily recognise the technical advancements or compliance issues when considering a new upgrade – the business wants cold hard advancements that are going to increase productivity or efficiency in their organisation.  How can this be done?  A journal is a journal, a sales order a sales order – the list goes on. It’s difficult to impossible to make these processes change dramatically, as it have the side effects of making upgrades harder and change management more difficult at upgrade time – which slashes the benefits of an upgrade.

Back to the old question – why upgrade.  We’ve just heard how leaps and bounds in existing modules are hard / expensive to implement as part of an upgrade.  New modules are a great idea, but generally for net new customers – rarely as a reason to upgrade.  If a fashion house is running JDE and want to upgrade because of apparel management module, then this is a reason – but they probably would not have bought JDE in the first place. 

The real reasons to upgrade (for JDE at the moment) are technical by nature, but what we must remember is that they generally have large functional benefits.  They can also have company side benefits if they are analysed carefully.

Lets see some of the enhancements in this simple table below and what are the technical and functional benefits:

Reasons to Upgrade

Technical

Better reporting tools – JDBC connectivity, interactive BI publisher

  • You can have graphs on JDE forms
  • You can have graphs on JDE reports
  • You can host native BI portlets in JDE forms
  • You can use type 4 JDBC driver for BI reporting
  • BI publisher is available and a real alternative for third party products (option / create)

Optimize the execution of batch programs

  • drill down into batch programs for performance and debugging
  • real time logging and real data in terms of run time and what time
  • Additional spread sheet based “BI for batch”

iPad support

  • Native support for Safari on iPad – go mobile with JDE!

User Productivity increases

  • Cut and paste between spread sheets and grids
  • Right click context sensitive menus for form and row exits
  • Parameterized URL

      The Simplified Parameterized URL is a feature that enables an external system to launch native JD Edwards EnterpriseOne application through the use a simple URL. This provides external applications the ability to have nearly seamless user interface integration with any available JD Edwards EnterpriseOne application

No downtime package deployment

  • Certain packages do not need to lock the kernels on the server and can be deployed without fear of production BSFN timeouts.

Expanded platform options and support

  • an ever increasing list of support
  • Finally virtualisation is supported (OVS)
  • Stay supported by all of your vendors

Simplified portal integrations

  • JD Edwards EnterpriseOne WSRP Portlet Producer Running on Oracle WebLogic Server
  • WSRP portlets can be deployed automatically when installing a JAS server
  • The WSRP portlets can be exposed easily to Oracle Webcentre Spaces

RIA – Related information architecture

  • simple way of linking the outside world with data on a form.  NO CODE simplicity
  • An excellent enhancement for getting more out of JDE

Security Enhancements

  • address book privacy
  • media object security
  • Oracle Enterprise Manager Data Masking Pack for JD Edwards EnterpriseOne
  • Configuring webcentre security for E1

Grid Control management improvements

  • You can chart metrics from E1 enterprise servers and web servers using oracle grid control framework
  • Log file monitoring through Grid Control
  • Application pack metrics

Better integration options

  • Support of Oracle Enterprise Repository is a searchable repository that manages assets and relationships between assets Functional
  • documented golden gate configurations for E1

Functional

Financial Management Enhancements

  • Interest Invoice Print
  • Journal Entry Voids
  • IBAN in Payee Control
  • Expense Management Usability

Human Capital Management Enhancements

  • Many US centric enhancements

Project Management enhancements

  • JD Edwards EnterpriseOne Business Accelerator for Engineering and Construction – General Contractors

Supply Chain Management

Integration to Primivera

  • If you’re in the construction / project management industry, then you’ll know about Primavera.  Pre-built supported integrations to Primavera are ready to go in JDE.

Compliance / Support

Taking the risk out of your software is a massive reason for upgrade, and many upgrades are performed for this reason alone.  When this is the case, most clients to not consider the enhancements (technical or functional) they don’t look at the release notes – they begrudgingly accept the upgrade so that their browsers, server OS’s and databases are all supported.

 

What does all of this mean?

Are any one of those reasons compelling enough to sign up for your next E1 upgrade – for some people – YES!  For many customers, no.  Although if you were to consider the overall improvements that each of individual enhancements could do for you, the case becomes more compelling.

If you were to carefully read the technical enhancements that have been made between the tools releases and carefully read the functional enhancements – there are things that will make a difference to your business.  Some of them might be bigger than others.

I find that when I read the release notes, I learn more and more each time I get into the details.  There are so many great technical advancements in the tools, it’s difficult to know how much you can take advantage of.  You can get your finger on the pulse of fusion and where things are going when you look at how the JDE toolset is being integrated into things like Oracle Grid Control and Oracle Webcentre Spaces.  The abilities to display data graphically, not just in numbers is often forgotten.  Clients are going out buying expensive BI tools, when much of the basic functionality is exposed natively in JDE.

Oracle BI Publisher has been around JDE for a while now, bust must be considered to replace any 3rd party forms tools.  The volumes and complexity that BI Publisher produces makes it an obvious choice for large volume, high complexity reporting.

Simple things like cut and paste, right click sensitive forms and improved grid format processing will save users time.  These enhancements, when advertised properly, internally will make a productivity improvement and can change the way users interact with E1.

These are all good reasons to upgrade (tools at least).  

Summary:

It’s very critical to consider the architectural implications of upgrading your ERP and how these improvements can improve your business and your ability to respond to a changing environment.  Compliance might be the reason for your upgrade, but do not get blinded by this.  Look for other improvements that the business can make by doing the upgrade, look at least for the low hanging fruit.

Someone from the business needs to drive the need to research the new technology.  The use of BI, the use of real time open integration are great for the entire business.  It’s difficult to find the representative from the business with the budget to implement this type of technology. 

Integration alone should be reason enough to get on the latest tools release, use BSSV – get real-time.  Choose an integration methodology involving coordination and don’t be locked down by any of your vendors – because you can swap them out in a heartbeat.  Open integration will allow you to foster a “best of breed” mentality.  I’m not saying that an ERP is not the way to go, but sometimes it’s a competitive advantage to be able to chop and changes pieces of your architecture. Having a best of breed WMS that can talk realtime to SAAS vendors, to your ERP to anywhere.  Have your integration layer find you the best transportation deals / lowest supplier prices – this is the future.

References:

8.98 Update 4 Tools and Technology Documentation Overview
Provides a central location for the supporting documentation resources for the JD Edwards EnterpriseOne Tools and Technology Update 4 release.
Note: 1268837.1

8.98 Update 3 Tools and Technology Documentation Overview
Provides a central location for the supporting documentation resources for the JD Edwards EnterpriseOne Tools and Technology Update 3 release.
Note: 1082706.1

Extending JDE to generative AI