Writing a P80010 Table Definition Browser App.

In OneWorld XE/8.0 days, we used to have an application – P80010 – Table Definition Browser Application. This application was of great help, as it showed the database fields in the Table, its indexes, the DD item name, description, the Data type of the field etc.
You can do the same in the Newer versions of EnterpriseOne too, with a very simple app as shown in the article.

Change Database values using MS Access (JDE E1 Oracle)

For people who have problems with SQL, there’s an easier way of changing backend database values. How about using MS Access where you can directly type in the values, and it gets updated or you can Insert, Update Delete & you can export, import…. and all.
Following is the tutorial for setting up MS Access with Oracle Database Backend for JD Edwards EnterpriseOne.