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

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 SVM811 F986101 files.

pf button Add Record To OCM – F986101
evernote Add Record To OCM – F986101digg Add Record To OCM – F986101share save 171 16 Add Record To OCM – F986101
Tags: ,

Leave a Reply