# JD Edwards EnterpriseOne System Tables: F0092, F9860, F9861, F983051 and More

> Source: https://netray.co/tools/jde-enterpriseone-system-tables-f0092-f9860-f983051-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

The system, Object Librarian, Central Objects and Versions tables a CNC admin or developer queries most on 9.2, with key columns and the question each one answers.

## Category

oracle

## Erp

JD Edwards EnterpriseOne

## Audience

- CNC administrator
- JDE developer
- JDE security administrator

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### Table

**Key:** table

**Type:** text

#### Name

**Key:** name

**Type:** text

#### Table class / data source

**Key:** dataclass

**Type:** text

#### Key columns

**Key:** keys

**Type:** text

#### Use it to find

**Key:** use

**Type:** text

**Rows:**

#### Library Lists - User (user profile)

**Table:** F0092

**Dataclass:** System

**Keys:** ULUSER

**Use:** A user's role/group (ULUGRP), address number (ULAN8), user type and fast path flag. Maintained in User Profiles (P0092).

#### User Display Preferences

**Table:** F00921

**Dataclass:** System

**Keys:** ULUSER

**Use:** Language (ULLNGP), date format, decimal and date separators, country and time zone preferences.

#### Library List Control

**Table:** F0093

**Dataclass:** System

**Keys:** LLUSER, LLLL

**Use:** Which environments (library lists) a user or role can sign on to, and their sequence (LLSEQ).

#### Library List Master File

**Table:** F0094

**Dataclass:** System

**Keys:** LMLL

**Use:** Environment list with descriptions (LMDL01).

#### Environment Detail - One World

**Table:** F00941

**Dataclass:** System

**Keys:** LMLL

**Use:** Path code (LMPATHCD) behind each environment, e.g. which path code PY920 uses.

#### Object Path Master File

**Table:** F00942

**Dataclass:** System

**Keys:** EMPATHCD

**Use:** Path codes with release (EMRLS), deployment server share path and the central objects data source (EMDATS).

#### Data Source Master

**Table:** F98611

**Dataclass:** System (servers read their copy in Server Map)

**Keys:** OMDATP

**Use:** Database server, database name, owner and platform of each data source.

#### Object Configuration Master (OCM)

**Table:** F986101

**Dataclass:** System (servers read their copy in Server Map)

**Keys:** OMENHV, OMOBNM, OMUGRP, OMSTSO

**Use:** Which data source an object (table or UBE) maps to for an environment and user or *PUBLIC; active mappings have OMSTSO = AV.

#### Object Librarian Master Table

**Table:** F9860

**Dataclass:** Object Librarian

**Keys:** SIOBNM

**Use:** Object name, description (SIMD), system code (SISY) and object type SIFUNO (APPL application, UBE batch, BSFN business function, TBLE table). The quickest way to get an application's name.

#### Object Librarian - Status Detail

**Table:** F9861

**Dataclass:** Object Librarian

**Keys:** SIOBNM, SIMKEY, SIPATHCD

**Use:** Where an object is checked out or installed: machine (SIMKEY), path code, user, status (SISTCE) and SAR/project.

#### Object Librarian - Function Detail

**Table:** F9862

**Dataclass:** Object Librarian

**Keys:** SIOBNM, SIFCTNM

**Use:** Business function names inside a BSFN source member, with descriptions and data structure template.

#### Form Information File

**Table:** F9865

**Dataclass:** Object Librarian

**Keys:** SWFMNM

**Use:** Form name (e.g. W4210A) to application (SWOBNM) and form description (SWMD). Answers 'which app is this form?'

#### Versions List

**Table:** F983051

**Dataclass:** Versions

**Keys:** VRPID, VRVERS

**Use:** Every interactive and batch version: title (VRJD), last changed and last executed dates, check-out status, processing option data (VRPODATA).

#### Processing Option Text

**Table:** F98306

**Dataclass:** Central Objects

**Keys:** Template name, item and language (see your table definition)

**Use:** Text of processing option tabs and prompts for a template object. The values chosen per version are in F983051.VRPODATA, not here.

#### User Overrides Table

**Table:** F98950

**Dataclass:** Central Objects class (check OCM for your mapping)

**Keys:** UOUSER, UOOBNM, UOFMNM, UOIDLST, UOUOTY, UOVERS, UOLNGP, UOSEQ

**Use:** Saved user overrides such as grid formats and query settings per user, object and form.

#### Job Control Status Master

**Table:** F986110

**Dataclass:** System class, mapped to the Server Map data source on enterprise servers

**Keys:** JCEXEHOST, JCJOBNBR

**Use:** Submitted UBE jobs: user, environment, queue, status (JCJOBSTS), submit date and time, process ID. JCFNDFUF2 usually holds report and version, e.g. R42800_XJDE0001. Status D is done and E is error.

#### Security Workbench Table

**Table:** F00950

**Dataclass:** System

**Keys:** FSSETY, FSUSER, FSOBNM, FSDTAI, FSFRDV, FSSY

**Use:** Every application, action, row, column and processing option security record by user, role or *PUBLIC. Maintained in P00950.

#### Role Relationships Table

**Table:** F95921

**Dataclass:** System

**Keys:** RLFRROLE, RLTOROLE, RLEFFDATE

**Use:** Which roles a user belongs to, with effective (RLEFFDATE) and expiration (RLEXPIRDATE) dates and the default role flag. Maintained in P95921.

#### One World Security

**Table:** F98OWSEC

**Dataclass:** System

**Keys:** SCUSER

**Use:** System user mapping (SCSECUSR), password change frequency (SCSECFRQ), last change date, allowed attempts and whether the user is enabled (SCEUSER). Maintained in P98OWSEC.

#### Security History

**Table:** F9312

**Dataclass:** System

**Keys:** SHUSER, SHMKEY, SHUPMJ, SHUPMT

**Use:** Sign-on and security events by user, machine and date/time (event type SHEVTYP, status SHEVSTAT).

**Notes:** Table class is the object class from the 9.2 table definitions. The actual data source each table reads from is decided by OCM (F986101) for your environment, so always confirm with a query against F986101 before pointing a report at a database. Example: to find which version of R42800 a user ran yesterday, select from F986110 where JCUSER = the user and JCSBMDATE = yesterday's Julian date and read JCFNDFUF2.

## Content

**Intro:** This is the list of JD Edwards EnterpriseOne 9.2 system tables that CNC administrators and developers query most: user and environment tables, OCM and data sources, Object Librarian, versions, job control and security. Each row gives the key columns and the practical question the table answers.

**Sections:**

#### How to use it

**Body:** Start from the question. Need an application's name from a form ID in a log? Use F9865 then F9860. Need to know who has an object checked out? F9861. Need the data source a UBE writes to in PY? F986101 for that environment, object and *PUBLIC, then F98611 for the server and database. Need which version a user ran? F986110. Filter on the key columns shown, and remember that most of these tables sit in the System data source shared by all environments, while F983051 is per path code and F98306 sits with central objects.

#### Data classes and OCM

**Body:** Each table belongs to a class: System, Object Librarian, Central Objects or Versions. OCM decides where it physically lives. The System data source holds user, security, environment and OCM tables for the whole installation. Object Librarian tables (F9860 to F9865) are shared by all path codes, which is why F9861 carries the path code. Versions (F983051) and central objects tables live per path code, so DV920 and PD920 each have their own copy. Enterprise and HTML servers read F986101 and F98611 from the Server Map, and the job master F986110 is kept there so all servers see the same job list.

#### Worked example

**Body:** A user reports that a nightly R42800 job failed. Query F986110 in the Server Map: WHERE JCUSER = 'JSMITH' AND JCSBMDATE = 126294, ordered by JCSBMTIME. The row with JCJOBSTS = E and JCFNDFUF2 = 'R42800_ZJDE0001' is the failed run; JCEXEHOST and JCJOBNBR identify the log on the enterprise server. Then read F983051 for VRPID = 'R42800' and VRVERS = 'ZJDE0001' to see when the version was last changed and by whom, which is often the real cause.

#### Gotchas

**Body:** Do not update these tables with SQL: OCM changes go through the OCM application, security through P00950 and object changes through OMW (P98220), so caches and package builds stay consistent. Julian dates and HHMMSS times apply here too. Column lists change slightly by tools release, so confirm against your own OMW table definition. F98306 contains prompt text only; the values of processing options are stored in a blob in F983051 and are best read through the version itself.

**Cta:** If your CNC team wants to ask questions like 'which jobs failed last night and which versions changed' in plain English on your own servers, we can wire that up over these system tables, read only.

**Faq:**

#### What is table F0092 in JD Edwards?

**Answer:** F0092 is Library Lists - User, the user profile table. Keyed by ULUSER, it holds the user's role or group (ULUGRP), address number, user type, menu and fast path settings. Display preferences such as language and date format are in F00921. Both live in the System data source and are maintained in User Profiles (P0092).

#### What is the F9861 table in JDE?

**Answer:** F9861 is Object Librarian - Status Detail. It has one row per object per machine key and path code, showing who changed it, when, the status code and the SAR or project. CNC admins use it to find where an object is checked out and on which path codes it exists.

#### Which JDE table has the processing options?

**Answer:** F98306 Processing Option Text stores the prompt text of a processing option template. The values chosen for each version are stored in the processing option data blob (VRPODATA) in the Versions List F983051, keyed by program ID and version. Read values through the version in the application rather than decoding the blob.

#### Which JDE table has the application name?

**Answer:** F9860 Object Librarian Master holds every object name with its description (SIMD), system code and object type (SIFUNO = APPL for applications). To go from a form name such as W4210A to its application, use F9865 Form Information, where SWFMNM is the form and SWOBNM the application.

## Search terms

jd edwards table f0092, f9861 table in jde, jde processing option table, jde table with application name, jde e1 object browser, jde tables list and fields, jde f986110 job control, jde f983051 versions list

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json