We have been trying to setup multi-foundation on Oracle JDEdwards EnterpriseOne 9.0 and have run into some issues with package manifests and such. So, once in a 2 full packages for the same pathcode show up as “deployed” in the package assembly screen. So, since the package is “deployed”, you can not delete it. Below ...
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, ...
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 ...
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 ...
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>' ...