Highlights: JD Edwards Release 9.2.2.5

The latest release of JD Edwards (9.2.2.5) is packed full of important updates. What does this mean for you? Our team of Oracle Certified Experts has reviewed the enhancements, providing highlights for both User Experience and Tools:

User Experience

  • Enhanced UX One Roles: Drilldown Navigation Capabilities on Analytic Components
    Additional roles and their Analytic Components now provide drilldown and right-click options on context menus with a selection of applications that can be launched. This allows users to easily navigate from analytic graphical presentations to review and act upon detailed master data or transaction information.
  • Adding Business View Columns to Form (query only)
    EnterpriseOne continues to empower citizen developers by providing frameworks to personalize and extend their EnterpriseOne implementation. Citizen developers can add available business view columns on the form header, grid, or both dynamically as user defined objects (UDOs).
  • Grid Personalization
    EnterpriseOne now supports the capability to personalize grid labels as part of the Grid Format user defined object. This will be very helpful for customers to personalize grid labels with more intuitive names for their user base without the need of development.
  • Application Exit Personalization
    This enables customers to further simplify form navigation and personalize their experience to meet specific role, industry, and user requirements. With the User Defined Object citizen developers can show, hide, and rename form exits as part of the Personal Form experience.

Tools

  • Delivered Notifications
    In October 2017, JD Edwards announced our EnterpriseOne Notifications capabilities. This new functionality is more than just a pop-up alert; the notification system enables workers to remain in touch with critical conditions and events that happen continuously throughout the enterprise. Notifications are available to subscribers even when not signed in to the JD Edwards system, raising awareness and enabling quick action. In this TR JD Edwards has delivered 35 EnterpriseOne notifications that will make it easier to quickly adopt this new functionality and bring immediate business value to our customers.
  • Assigned Subscriptions
    This allows a manager or business analyst can assign subscriptions by role to groups with a common interest or common security settings, removing the requirements of an end-user to individually subscribe to a notification.
  • Delivered Orchestrations
    This release includes business orchestrations to help automate a Procure-to-Pay process with a supplier portal system that previously would have required integration customizations. Customers can quickly adopt these orchestrations and drive immediate business value in your organization.
  • Orchestrator Process Recorder
    This tool provides a simple, intuitive method for a business analyst to create an Orchestrator form requests from within JD Edwards EnterpriseOne applications; making the process of creating service requests a very natural, familiar process for any user who knows how to use JD Edwards EnterpriseOne applications.
  • Launch a Report (UBE) as an Orchestration Step
    This enhancement adds the ability to launch a JD Edwards EnterpriseOne report or batch job as an orchestration step, thereby giving the business analyst even more capability to automate and simplify business processes.
  • Confirmed Completion of Orchestrations
    This feature enables Orchestrator to record the status and details of its successful and unsuccessful REST service requests, allowing successful requests to be confirmed and unsuccessful requests to be retried or debugged.
  • Orchestrator File Transfer
    With this feature business analysts can use Orchestrator file transfer features to either retrieve a file or send a file to a known location using FTP, SFTP, or REST protocols.

Dev 101 Part I: Setting Up a Business Function Debugging Session In Visual Studio

As a Senior Managed Services Developer, I find myself in this sort of conversation all the time with my Apps teammates:

“Mike, can you figure out why X won’t work?”
“I’ll need to run that in debug to be able to see what is going on.”
“Can you just look at the code and get an idea of what is happening?”
“Kind of…”

Hence, the topic of this blog.
But first, let’s step back a little further in that conversation.

“The customer says when they exit the row, the extended weight is not being converted into the correct unit of measure. They expect this value, and they are getting this value”.
(That’s an important sentence, because if it wasn’t offered, the developer would have asked for this information eventually.)

“Can the scenario be reproduced?”
(That question is what the developer truly wants to know first thing off the bat.)

“Yes and no.”
(That’s the last thing a developer wants to hear.)

“I’ll need to run that in debug to be able to see what is going on.”
“Can you just look at the code and get an idea of what is happening?”
“Kind of.”
“What does it LOOK like is happening?”
“It looks like it would be a lot easier to see what is happening if I was able to run it in debug.”

And so it begins.

In JDE, all the modules are constructed in a basic sort of way. They call it Event Rule Logic, because the logic/code is executed based on user executed events, like in an application, or events that occur within a report or a UBE.

Given the scenario above, the developer would open the application in the Form Design Aid and look at the code behind the Row is Exited and Changed event on the grid. There will be a lot of code there. The tool JDE uses to debug Event Rule code is the ER Debugger. It could be run over that event and a “watch” placed on the desired grid column or variable that is being calculated.

Stepping through the code, the developer watches the values change from what it is, to what it will be, once the event ends.

In the case of the scenario described above, the developer would discover that the value is being calculated in a call to a Business Function.

The ER Debugger can only take the developer so far when troubleshooting this type of issue. He/she can see the value before the function call and see the difference in value when the function is returned, but there is no way to tell how the value was calculated without having the ability to debug the Business Function in Visual C++.

 

Definition Time:

A Business Function is a consolidated program that can be called from multiple places, so code does not have to be reproduced in the application or UBE every time that functionality is required.

Business functions are created in two ways, but ultimately end up in the same format. Whether is a Named Event Rule Business Function or a Business Function written directly in the C programming language, they are debugged in the same way using Microsoft Visual C++.

Now we are at the meat of the story.

In order to debug a Business Function in C, a project has to be set up Microsoft Visual Studio.

These are the steps this developer follows to set up a project in Visual Studio:

    1. Open Microsoft Visual Studio
    2. The first time it opens, no matter what version, it will ask you to select a Project Template. Select Visual Studio C++
    3. From Start Screen, select New Project.
    4. Next, Select Makefile Project

    1. Enter any name (I use Default)

    1. Click OK and Blank out Default.exe (or whatever you named your project) and click OK.

    1. You’ll now have a project that looks like this:

    1. You are now ready to begin adding C Source files to your project.

    1. Select Existing Item then find the Source directory.

    1. Find the function you wish to debug and select it.

    1. Now the function is in your project and can be debugged.

There are a few more steps required to begin debugging, but the setup is complete.

The process to this point will allow you to setup a project, view the code and get a feel for the structure.

Next time, I will demonstrate the process of Attaching to the Process (Activeconsole.exe) and actually debugging a Business Function!

Happy Developing!

UX One: Alert, Analyze, Act

UX One is the latest advancement in the JD Edwards EnterpriseOne user experience. Utilizing the Alert, Analyze, and Act model, JD Edwards is transforming the User Experience and maximizing productivity. These 3 principles in UX One empower you to be more effective and efficient, while performing your day-to-day tasks. With Alerts, you will be notified of what needs your immediate attention. With Analyze (charts), you will be able to view the status of key metrics at-a-glance. Lastly, with Act, you will have access to action items for a quick and easy response.

UX One includes a set of role-based solutions across the broad portfolio of JD Edwards products, and delivers the tools you need to personalize and create your own solutions, so that end users and citizen developers can make the user experience their own.

For more information, review the UX One Data Sheet

Collaborate 2018 Highlights

For those of you who made it to Collaborate this week, we trust everyone had a safe trip home after a very intense week full of great sessions. With 200+ JD Edwards Education Sessions available, I felt overwhelmed with the amount of information provided. I promised myself to summarize what I learned as soon as I got back home, this way all the information would be fresh and available when I needed it! Also, I wanted to share this information with those of you who could not make it out to the conferences this year.

From my point of view (based on the sessions I attended), this year there were 3 main tracks:

  • Maximizing the 9s
  • Continuous Delivery
  • Orchestrator and Notifications

Let’s dive in a bit on each category, and use the links provided to get more information.

Maximizing the 9s

No matter what version of JD Edwards you are on, it is important that you maximize the use of all tools available to you. From real business cases (learn from others) to Oracle’s latest, the overall experience was to convey the idea of taking advantage of the features and functionality available to improve user experience and ultimately maximize your investment. Many sessions highlighted the key features that have been delivered in previous Tools releases and how customers are leveraging these features.

Keynote Presentation:
https://docs.oracle.com/cd/E84502_01/learnjde/pdf/JD%20Edwards%20Collaborate18%20Keynote%20-%20You%20Make%20it%20Happen.pdf

Keynote Case Studies:
https://docs.oracle.com/cd/E84502_01/learnjde/pdf/JDE%20C18%20Keynote%20Case%20Studies.pdf

Features and Tools by Tool Release:
https://emeraldcube.com/2018/04/highlights-from-the-latest-jd-edwards-e1-tools-release/

UX One Highlights:
Proving an Intuitive, Efficient, and Effective Way for Users to Perform Their Day-to-Day Tasks Using UX One:
https://emeraldcube.com/2017/12/jd-edwards-2017-highlights/

New Functionality:
Announcing JD Edwards EnterpriseOne User Experience Enhancements, New Mobile Features, Modern ERP Enhancements, and Tools Digital Transformation Features (TR 9.2.2.4)
http://www.oracle.com/us/products/applications/jd-edwards-enterpriseone/jde-ga-april-2018-4438322.pdf 

Announcing JD Edwards Lease Management Enhancements for Equipment and Other Non-Property
http://www.oracle.com/us/products/applications/jd-edwards-enterpriseone/jde-ga-april-18-4473628.pdf

User Experience: Form Extensions (new in 9.2.2.4) – Oracle Support Document 2384606.1
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2384606.1

Continuous Delivery

Oracle’s commitment is to continue to enhance the 9.2 release with incremental enhancement packs, two or three times per year. The questions are, what does this mean and how will this approach affect us? The goal is to create a strategy to move from the “upgrade” to the “update” mentality.

The “Simplified Upgrade” was introduced in TR 9.2. In contrast with the “Traditional Upgrade”, where all the EnterpriseOne objects were replaced, the Simplified Upgrade process identifies and replaces only specific standard JD Edwards EnterpriseOne objects that have changed between application release 9.0 Update 2 or 9.1 and 9.2. The concept is to simplify the upgrade in terms of diminishing the requirement to retrofit custom changes.

JD Edwards Product Roadmap (Doc ID 1317204.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1317204.1

Oracle Support for JD Edwards EnterpriseOne Now Through at Least 2028
https://blogs.oracle.com/jd_edwards/oracle-support-for-jd-edwards-enterpriseone-now-through-at-least-2028

Understanding Upgrade Types after Tools Release 9.2 and Simplified Upgrade Process (Doc ID 2061189.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2061189.1

Additional Tools available:

  • Customize Object Analyzer (TR 9.2.1)
    The Customization Object Analyzer (COA) utility can be used to list EnterpriseOne objects that have been customized. This information is then used to determine the impact and level of effort needed to retro-fit the customizations into a newer application release of the system.  A review of the information, prior to performing modifications within the software, allows for a smoother and more predictable upgrade.
    Understanding Customization Object Analyzer and Application Configuration Analyzer (Doc ID 1499756.1)
    https://support.oracle.com/epmos/faces/DocumentDisplay?id=1499756.1
  • Application Configuration Analyzer (TR 9.2.1)
    This tool that was introduced with applications release 9.1 and Tools Release 9.1.2. ACA will generate reports to identify differences between environments or data sources for: Processing Options, Data Dictionary items, and User Defined Codes. Comparing these between two environments or data sources is helpful for upgrades as an audit type tool or for helping to diagnose an issue that occurs in one environment but not another.
    Understanding Application Configuration Analyzer (Doc ID 2013069.1)
    https://support.oracle.com/epmos/faces/DocumentDisplay?id=2013069.1
  • Object Usage Tracking (TR 9.2.1.2)
    This tool provides information to determine frequency of objects being used within a path code. Object usage is captured by User/Role/Environment/Path code each time an object is launched by the user or the system
    Object Usage Tracking Functionality (Doc ID 2267215.1)
    https://support.oracle.com/epmos/faces/DocumentDisplay?id=2267215.1
  • Simplifying Stay Current (TR 9.2.2)
    • Object Tracking and Enhanced Impact Analysis: This new capability provides tracking and visibility of business functions (BSFN) execution within JD Edwards EnterpriseOne. Business functions are the core logic processing for JD Edwards EnterpriseOne interactive/batch application, hence providing greater insight into their usage simplifies upgrade/patching processes, assists with troubleshoot performance, analyze issues, and manage compliance. Similar to tracking usage of interactive/batch application, business functions statistics are consumable by out of the box UX One analytics and helps customers identify business functions used in their business processes. WATCH VIDEO: https://www.youtube.com/watch?v=9CYTR4WOS_c
    • Batch Deploy of UDO Packages: This streamlines the process and reduces the effort of applying and deploying key enhancements such as UX One and other User Defined Objects (UDO). Customers can now deploy multiple (UDO) packages at the same time and to multiple environments along with a generating a deployment summary report.
    • Customization Workbench enhanced to support ESUs: The streamlined process of retrofitting customizations which was earlier available for Simplified Upgrade is now extended to support all customized JD Edward EnterpriseOne objects impacted by Electronic Software Updates (ESU).

Orchestrator and Notifications

Orchestrator is an integral part of an Internet of things (IoT) configuration with EnterpriseOne, supporting various integrations such as integrations with Cloud services, third-party applications, custom programs, and more. Combining the power of the JD Edwards EnterpriseOne Orchestrator and AIS Server enables organizations to:

  • Connect IoT data to your business data. The Orchestrator enables customers to collect, filter, analyze, and act on real-time data as it is being transmitted by IoT devices.
  • Simplify the integration of IoT data with the JD Edwards EnterpriseOne Orchestrator Studio. Available starting with EnterpriseOne Tools 9.2.0.2, the Orchestrator Studio is an intuitive, easy to use web-based application that business analysts can use to create orchestrations that tie IoT device data directly to JD Edwards EnterpriseOne applications, thus eliminating costly, mundane, and error-prone manual input.
  • Extend integrations to other solutions. Starting with EnterpriseOne Tools 9.2.1.4 and Orchestrator Studio 5.1.0, the Orchestrator functionality has expanded to support various integrations including integrations to Cloud services, third-party applications, custom programs, and many more. Keep using it for integrating JD Edwards EnterpriseOne with IoT devices. But start using it for all you REST-based integrations to JD Edwards.

Fresh out of the oven with Tool Release 9.2.2.4 

Process Recorder

With Orchestrator Studio 6.1.0 and Tools 9.2.2.4, you can access the Orchestrator Process Recorder in EnterpriseOne to record business process steps directly in the system and save the steps as a form request, which you can then open in the Orchestrator Studio and add to an orchestration. The Process Recorder makes it easier than ever before to turn traditional manual business processes into automated functions with orchestrations. 

Confirmed Completion of Orchestrations

This feature enables Orchestrator to record the status and details of its successful and unsuccessful REST service requests, allowing successful requests to be confirmed and unsuccessful requests to be retried or debugged.

Launch a Report as an Orchestration Step

This enhancement adds the ability to launch a JDE report or batch job as an orchestration step, thereby giving the business analyst even more capability to automate and simplify business processes. 

Orchestrator File Transfer

Business analysts use the Orchestrator Studio to create orchestrations that enable automation of their previously manual business processes, as well as pass and retrieve data between JDE and external systems. Many automated business processes require the movement of physical files from one system to another. To accommodate this requirement, business analysts can use Orchestrator file transfer features to either retrieve a file or send a file to a known location using FTP, SFTP, or REST protocols. These features enable you to create a FTP connector or REST connector in the Orchestrator Studio, that when added to an orchestration, enables the transfer of files to an external server. For example, a business analyst could create an orchestration that runs a JD Edwards EnterpriseOne report and then sends the report output (PDF file) to a document management system via FTP, SFTP, or REST.

For more information and tutorials:

https://docs.oracle.com/cd/E84502_01/learnjde/cross_applications.html?4

Notifications enable you to stay connected to your business by pushing valuable information to you. More than just a pop-up alert, the notification system enables users to remain in touch with the critical conditions and events that happen continuously throughout the system, and to quickly act upon those events even when they are not signed on to the JD Edwards system. Using Orchestrator Studio, business analyst can design notifications specific to their organizations processes, rules, and required action. Users can subscribe to available notifications and receive updates by email, by text, as browser pop-ups, within the new notification list on the EnterpriseOne menu bar, or in the Work Center. A scheduler allows the notifications to run periodically and automatically, and continuously monitoring the system for critical conditions and events. When a critical event or exception is detected, the notification system will notify the appropriate users via their preferred delivery.

WATCH VIDEO: https://www.youtube.com/watch?v=qjoEgdUpNDc&feature=youtu.be

Delivered Notifications

Many notifications have been created and delivered for use by JDE customers via UDOs (User Defined Objects). Each system has its own set of notifications that can be downloaded via the Update Center or Change Assistant. Use the following link to review and download them:

JD Edwards EnterpriseOne Delivered Notifications – 2365066.1
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2365066.1

Fresh out of the oven with Tool Release 9.2.2.4

Assigned Subscriptions

Assigned Subscriptions remove the requirement for a JDE users to subscribe individually to receive a notification. Now a manager or business analyst can assign subscriptions by role to groups with a common interest or common security settings. The assigner can allow subscribers to opt out of assigned subscriptions, or the assigner can disallow subscribers to opt out, thus ensuring that they receive critical notifications.

For more information and tutorials:

https://docs.oracle.com/cd/E84502_01/learnjde/cross_applications.html?6

Highlights from the Latest JD Edwards E1 Tools Release

As you know every JD Edwards EnterpriseOne Tool Release provides a handful of new tools and enhancements. With Oracle’s concept of release a new TR every 3 to 4 months, it makes difficult for everyone to keep up with what’s available. Use this document with a quick reference of what’s available on each Tools Release. Our hope is that will help you to plan your TR upgrade accordingly.

Features & Tools by TR

  • Tools Release 9.x GA
    Release Release Date Status
    Tools 9.2.2.4 09-APR-2018 Premier Support
    Tools 9.2.2.2 22-JAN-2018 Premier Support
    Tools 9.2.2 13-OCT-2017 Premier Support
    Tools 9.2.1.4 28-JUN-2017 Premier Support
    Tools 9.2.1.2 25-APR-2017 Premier Support
    Tools 9.2.1 16-NOV-2016 Premier Support
    Tools 9.2.0.5 26-JUL-2016 Premier Support
    Tools 9.2.0.3 08-MAR-2016 Premier Support
    Tools 9.2.0.2 13-JAN-2016 Premier Support
    Tools 9.2 06-OCT-2015 Premier Support
    Tools 9.1.5.5 21-JUL-2015 Premier Support
    Tools 9.1.5.3 21-APR-2015 Premier Support
    Tools 9.1.5.2 27-JAN-2015 Premier Support
    Tools 9.1.5 09-DEC-2014 Premier Support
    Tools 9.1.4 17-DEC-2013 Premier Support
    Tools 9.1.3 08-APR-2013 Premier Support
    Tools 9.1.2 18-SEP-2012 Premier Support
    Tools 9.1 06-DEC-2011 Premier Support
  • TR 9.1.2 and above
    • Customize Object Analyzer (ESU required, Xe thru 9.1)
    • Application Configuration Analyzer (ESU required, 9.1 and above)
  • TR 9.1.5.x and above
    • Alta UI Adoption
    • Media Objects drag & drop
    • Simplified Navigation (KIOSK Mode)
    • Email and Calendar Integration
  • TR 9.2 and above
    • OMW Web (P98220W)
      • To promote UDOs between path codes or environments
      • To Import/Export .zip files containing UDOs
    • Application Interface Services (AIS) Server
    • Simplified Upgrade Method: from 9.0 Update 2 to9.2 or from 9.1 to 9.2
  • TR 9.2.0.x and above
    • Orchestrator Studio – TR 9.2.0.2
    • Watch List Pane for Composed Pages – TR 9.2.0.3
    • List View Grid Formats – TR 9.2.0.5
  • TR 9.2.1 and above
    • UX One
    • Springboard for Composed Pages
    • Watchlist for Databrowser
    • Enhanced Media Objects
  • TR 9.2.1.x and above
    • Object Usage Tracking – TR 9.2.1.2
    • MO store in DB or File System – TR 9.2.1.4
    • Enterprise Search: enabling task search from Fast Path – TR 9.2.1.4
  • TR 9.2.2 and above
    • Orchestrator Studio: Notifications, Subscriptions and Scheduler
    • Server Manager Enhancements
  • TR 9.2.2.2 and above
    • System Simplified Upgrade on a One-Click Provisioned Target
  • TR 9.2.2.4 and above
    • Adding Business View Columns to Form (Query Only)
    • Application Exit Personalization
    • Grid Label Personalization
    • Assigned Subscriptions
    • Orchestration Enhancements: Confirmed Completions, Process Recorder, Launch UBE as step in Orchestration and File Transfer

More Tools

  • Runtime Features
    • Auto-Suggest –TR 9.1 and above
    • Hover View –TR 9.1 and above
    • Change Confirmation –TR 9.1.3 and above
    • Dropdown (UDC) –TR 9.1.3 and above
  • Setup
    • P958973 – Definition
    • P958974 – Authorization

UDOs Available

There are 11 UDOs available:

  • Grid Formats
  • Advanced Queries – TR 9.1
  • One View Reports – TR 9.1
  • E1Pages – TR 9.1
  • One View Watchlists – TR 9.1.3
  • Composite Application Framework (CafeOne) – TR 9.1.3 (URLs and BI), TR 9.1.4 (E1 Apps)
  • Composed Pages – TR 9.2.0.2
  • Personal Forms – TR 9.2.1
  • Images/Icons – TR 9.2.1
  • Search Groups – TR 9.2.1.2
  • Orchestrations/Notifications – TR 9.2.2
  • More to come…

Manual Rollback Functionality

As an EmeraldCube Application Managed Services Consultant, I get a lot of tickets and questions about incorrect inventory commitments.  And I’ve found that a lot of users are not leveraging the Manual Rollback functionality for F41021 – or maybe are completely unaware of it.

What is the Manual Rollback Process of Item Location (F41021) File (P42210/R42210)?  And when should you use it?  I’ll cover both; let’s get started.

When a transaction error occurs in a Distribution application, all files except the Item Location (F41021) will roll back.  This means that the transaction will be “undone” or removed from the tables such as F4111 Item Ledger, etc.  However, since the rollback is not automatic in the Item Location file, this leads to incorrect commitments in the F41021.

It is common to run the Sales Order Repost (R42995) and the WO Repost (R3190) in attempt to update or correct your commitments.  However, if I have potential rollback records for F41021 hanging out there, I could cause a bigger mess if I don’t deal with those first.  So, before I run either Repost job, I always look in the Work With F42210 Commitments Recover (P42210) for any F41021 records that may need to be rolled back.

For Example:

Item 1144 has a Qty -12 SO Hard Committed.  However, there are no Open SO’s for this item.  I could run the SO Repost (R42995) in attempt to realign the commitments, but I would first have to create a dummy SO for this item to get the system to “see” a commitment, and then later delete that dummy order. ***Unless you are on 9.2 – more on this later…

Instead, l check the Work With F42210 Commitments Recover (P42210) and I find a record I can roll back.

I select the record and Row Exit to “Roll Back.”

Now, I can reinquire on my item in Detailed Availability.  That -12 SO Hard Commitment is gone and my commitments are updated correctly.

*** (9.2 Enhancement) I mentioned earlier that if you ran the SO Repost (R42995) you would need an open SO for that item or you would need to create a dummy order and later delete your order.  What a pain!  On 9.2 and later you can run the Refresh Inventory Commitments (R42990) instead.

The R42990 can be run at the same time you run the R42995.  These 2 UBE’s run over different data sets, so they are mutually exclusive and designed to run in tandem.  The R42990 runs over F41021, F4101, and F4102, refreshing commitments for those items that do not have an active sales order.  The R42995 runs over F4211 and updates commitments for those items on active sales orders.

So, do you want to wait until you notice a discrepancy before looking for records to roll back?  Or do you want to run the F41021 Commitments Recovery (R42210) on the scheduler?  It would be best practice to run the R42210 before you run the reposts,  and it would be best to run all of them while nobody is creating new transactions in the system.

Before you set the R42210 up on the scheduler though, you will want to consider clearing out the F42210 or at least reviewing each record one by one.  There is a possibility that some of those incorrect commitments were cleaned up using SQL.  If so, rolling back the commitment could create a new problem requiring SQL clean up.

Nichole’s Commitment Correction Checklist:

  1. Review P42210 for potential rollbacks.
  2. Research each rollback, and match it to an invalid open commitment in F41021.
  3. Ensure no SQL fixes have been done.
  4. Perform necessary rollbacks, and delete unnecessary ones that have been corrected via other means.
  5. Either schedule or regularly run R42210, followed by SO/WO reposts, to keep your commitments clean.

Follow the above rules, and your users’ commitment issues will be gone forever – well, at least greatly reduced.

OBIEE 12c “uploadrpd” Lesson Learned from the School of Hard Knocks…

One of the more baffling (and initially troubling!) issues we encountered after our first OBIEE 12c upgrades to 12.2.1.1 and later was a mysterious issue of the new “uploadrpd” function. It was basically making scrambled eggs out of the RPD we intended to upload…

We were doing some tests by updating connection pool settings in offline mode of the RPD BI Admin Tool and then went to perform an uploadrpd command. After what appeared to be a successful RPD upload (no errors/warnings reported via uploadrpd) we went to open the newly uploaded metadata model in online mode to confirm our changes. Not only did we not find our connection pool settings in the RPD after it was uploaded, but we noticed something else even more sinister and less obvious. For reasons unexplained, now initialization blocks were all of a sudden duplicated with a “#1” suffix on the end of the new copies. And then, I guess just to add insult to injury, some targets variables had actually been RESHUFFLED within the init blocks so that variables were now getting incorrectly assigned values from the SQL initialization strings! Very, very frustrating and confusing, as you can well imagine if you ran into the same issue.

Well, at the time as luck would have it, the fix/workaround for the uploadrpd command was not even documented in the manuals. Fortunately, we were able to find Oracle Support Doc ID 2176245.1 that spelled out the (now finally documented!) fix. To resolve these kinds of issues, use the “-D” command line parameter with the uploadrpd command. Read more about this now documented “-D” parameter here in the Oracle Docs and check out the support doc mentioned above for more on the initial information we found from the Oracle Support KB.

If you’d like to find out more about the OBIEE 12c upgrade process and how we’ve helped many of our clients successfully upgrade, drop in for our upcoming April 12th webinar here. And if you’ll be in Vegas for Collaborate 2018, Jeff Brown and I will be co-presenting a more technically in-depth version of this talk during this session.

Or if you can’t make the webinar and won’t be at Collab, drop me a line and let’s setup a time together where we can give you a personal presentation, talk with you more about your OBIEE environment as it exists today, and see how we may be able to help assist you and your team on your upgrade journey to OBIEE 12c.

Cubeology Online Learning: Simplify Your JDE Experience

Cubeology email courses from EmeraldCube provide the JD Edwards technical and functional educational insight you need on your schedule. Created specifically for JD Edwards EnterpriseOne users, Cubeology email courses are free and delivered to your inbox, providing the latest tips and tricks for maximizing your user experience.

Our team of Oracle certified experts is dedicated to testing the latest releases of JDE E1 9.2, including UX One, feature packs, and tools releases, to bring you bi-weekly highlights and actionable tips. From blogs and pre-recorded mini webcasts, to simple how-to’s and downloadable content, we’ll bring you the highlights of announcements along with our expert insight and testing results.

Our first course on User Defined Objects and UX One will be launching on March 13, so sign up today: http://www.emerald-cube.com/cubeology/. Then sit back and relax, your first course will be delivered to your inbox soon!

Using Server Manager to Clear Web Server Caches

Introduction

Purpose of Web Server Cache

Web Server Cache is used to ensure data integrity and improve performance.  This cache holds a snapshot of data from a table in memory and the application processes faster as the necessary information is readily available in memory.

When a change has been made to the record / value in the actual table (IE:  removing role from user, changing open accounting periods, etc) the existing cache is not reflective of the change until that cache timeout is reached and the cache is reset automatically. Until this occurs, the applications keep picking up old values existing in memory. Therefore, it becomes necessary to clear the cache manually if the change needs to be seen right away. Once this is done, a new set of records from that table is put into cache (on the subsequent access to this table).

JDE does not cache records from all tables. Only those tables which are very frequently accessed and not changed on a regular basis (Usually company master information, user security) are cached.

Who Can Clear Cache?

As these steps are very easy and can be completed by anyone with appropriate access to Server Manager, Emerald Cube Solutions wanted to provide this easy-to-use guide for anyone who desires to complete this task.

Steps to Clear Web Server Cache

Log on to Server Manager

Click on Select Instance to see all available instances

Select the link for the appropriate instance

Under Runtime Metrics, select JDBj Database Caches

Literacy Kits and Snack Packs for Atlanta Youth

As part of our ongoing #EmeraldCubeCares initiative, we gathered today to give back to our local community in Atlanta, GA. During our fourth year of service with the United Way of Greater Atlanta, the EmeraldCube team donated materials and spent the morning building literacy kits and snack packs for Atlanta youth.

The 150 literacy kits were packed with composition books, folders, novels, pens, jump drives, and various other school related materials. In addition, handmade bookmarks were designed by the EmeraldCube team. The kits will be delivered to East Atlanta Kids Club, a nonprofit, out-of-school-time tutoring, mentoring and enrichment program for under-resourced girls and boys ages 7 to 17. http://www.eastatlantakids.org

In addition, the team built 500 snack packs filled with healthy non-perishable food items. The snack packs will be delivered today to Easter Seals of Warsaw and Mansell. Easter Seals North Georgia provides high-quality services to ensure that all children with disabilities or other special needs and their families have equal opportunities to live, learn, work and play in their communities. http://www.easterseals.com/northgeorgia/

It was a very fulfilling morning for the team, as we put our own personal touch on making a difference in the lives of Atlanta youth. A special thank you to United Way of Greater Atlanta for making the event possible.