Add Record To OCM – F986101

Read Time:25 Sec

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.

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Access To Environments
Next post EnterpriseOne & Sharepoint