Find All Checked Out Objects Using SQL
Use the SQL statement below to find all the objects that are checked out: select * from ol900/f9861 where sistce=3 ...
Archive for the ‘EnterpriseOne – SQLs’ Category
How To Copy OCM Records From One Environment To Another Using SQL
This method can be used to copy any records in a database but the issue that I was trying to resolve was to copy 8 records in the Object Configuration Management (OCM) file, F986101, of one object to another object. INSERT INTO SY900/F986101( OMENHV, OMOBNM, OMDATP, OMUGRP,OMOAPP, OMDATM, OMSY, OMSTSO, OMPID, OMFUNO, OMUSER, OMJOBN, OMOCM2, ...
Moving ODBC Connections From Windows Server 2003 32bit to Windows Server 2008 64bit
While trying to upgrade from EnterpriseOne 8.11 SP1 to EnterpriseOne 9.0, we also wanted to upgrade our Deployment server to Windows Sever 2008 64bit. So, that means that in order to runt he upgrade UBEs we needed to get the ODBC Connections onto the new server. So, I exported the desired ODBC connections from the ...
Web Only Version Pain
We seem to be having an issue with old “web only” versions. There are times when the “web only” version causes the other version to not egen correctly. So, below is the SQL that can be used to select the “web only” versions. SELECT count(*) FROM COPD811/F983051 WHERE VRVCC2='1' If you want to be more ...
Add Record To OCM – F986101
The other day, I had a need to insert many records into the OCM (F986101). So I set out to create a quick SQL statement that would serve that purpose. Below is what I came up with: INSERT INTO SY811/F986101 VALUES('DV811',0,'OBJECTNAME','LOCAL','','*PUBLIC', '*ALL','P','','H95','AV','SQL','BSFN', 'USERNAME','','','',0,'',0,'','','','') Remember: you may have to make entries in both the SY811 and ...
Access To Environments
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>' ...
Clean Up Your Web-Only Versions
We have been having some issues lately where users create web-only versions and expect to use them after a full package has been built and deployed. We have processes in place for them to submit new versions to our development teams, but sometimes things dont happen the way they are designed. Anyway, I was doing ...
Quick EnterpriseOne Version Security Solution
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 ...
Time To Change Your Password
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>' ...
Cleaning Up The Effects Of Deleting User Overrides In EnterpriseOne
Over a year ago, I wrote about how to delete User Overrides in EnterpriseOne. Well, I had to use that process the other day and felt I should probably publish a fix to an unfortunate effects of using the User Overrides application. What are these effects? Well, when you delete a User Override, it is ...