Business Intelligence / EnterpriseOne

Oracle BI Publisher (OBIP)

Oracle BI Publisher is a template-based desktop publishing application. Oracle BI Publisher was created by Oracle and was first used in its E-Business Suite; it was then bundled with the PeopleSoft Suite a few years ago. BI Publisher improves reporting by defining a Roadmap which can be a as simple as a Word Doc or Adobe. The data to the template is passed using XML Source code files been loaded as the input BI allows users to have control over the existing reports without any major changes to associated JDE reports/UBE.

EnterpriseOne / Guide

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.

EnterpriseOne / Technical

Identify UBE Versions with Overrides

There is not a standard report or simple inquiry that can be performed to see all versions with overrides. The easiest way to determine this information would be to look at the F98761 table in the central objects data source and find all records with a specific version name that have record types other then just 1. This would indicate some type of override was performed on the object. Depending on the value in the record type field (RSRCRDTP) you can determine what type of override exists for the version.