E1 Tips The Tips & Tricks of a CNC Administrator on Oracle JDEdwards EnterpriseOne

Archive for the ‘OCM’ Category

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 ...