The OCM QBE Ambush
Share
Ok, I’ve been working as a CNC Admin for the past 14 years or so. I’ve come across many odd and unexplainable things. My first exposure was to JDE OneWorld Xe. One of the most difficult issues during that time was the “fat” client hosted on Citrix and trying to control where things ran using OCMs. So, I’ve had quite a bit of experience with the Object Configuration Manager (OCM) and how and why to set things up.
What I learned today is that I don’t know all there is to know about this seemingly simple function and the table behind it (F986101).
There is a setting on each OCM record that I have ignored in the past. It is the “Allowed QBE” field:
DO NOT IGNORE IT! It will bite you when you least expect it.
There are 3 options to this setting:
Unless there is a security requirement or performance issue, I would suggest changing all values to a 1.
You can do that with the SQL below:
UPDATE SY910.F986101 SET OMOCM2='1'
That right there my friends is why I have a love/hate relationship with my job as a JDE CNC Admin. The simplest little things from the least obvious place can either ruin or make your day.
Author
Stewart Schatz
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
Average Rating