Using Complex Database Views on EnterpriseOne
A Database View is a subset of the database sorted and displayed in a particular way. For example, in an Invoice database, perhaps you only wish to display the Vendors …
A Database View is a subset of the database sorted and displayed in a particular way. For example, in an Invoice database, perhaps you only wish to display the Vendors …
Create a RTF template with OBIP for JD Edwards. We will do a tutorial with the AP Ledger file, and try to create a report with Amounts for an address number
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.
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.