Blog directory

Writing a P80010 Table Definition Browser App.

Table Browser Application

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. . . . → Read More: Writing a P80010 Table Definition Browser App.

Launch Batch Jobs/UBE from Interactive Apps

UBEInterconnect

The Article describes the use of BSFN & System Functions to dynamically call a UBE/Report/Batch Application from an Interactive Application/form. The BSFN’s use the same JDE API – jdeLaunchUBEEx(); to launch the UBE. The Launch Batch Application System function and Business functions – B9800240, B91300C are documented here. . . . → Read More: Launch Batch Application/UBE Dynamically from Interactive Apps

Funny JDE Standard BSFN Comments ;-)

jde-bsfn-comments

A funny code comment in a E8.11 Standard JDE Business function (BSFN) – B9600430 line 406. We need to empathize with the developers. . . . → Read More: Funny JDE Standard BSFN Comments ;-)

Calculate Begin and End Dates for Month/Year

EventsCalendar

Calculate the Begin and End dates from a given Period/Year combination or to calculate the month’s begin and end dates from a given date. Like if you are given Period=3, Year=9, the Begin and End dates will be 03/01/2009 and 03/30/2009 respectively. Similarly if you were given a date say – 2/17/2009, the return Begin & End dates will be 02/01/2009 and 02/28/2009. . . . → Read More: Calculate Begin and End Dates for Month/Year

BSFN to Get Install Path (for Import/Export)

Most File based transactions or JDE Applications, need to have access to the Import and Export directory of the Install Path. For most Live installations, the workstations will be on Windows OS, and the servers may be either AS/400 or Linux/UNIX environments. The path’s to the environment install directory will be entirely different in each case.

Typically for an JDE EnterpriseOne Windows based Local installation will have path – “C:\Exxx\DVxxx\” or “C:\Bxxxx\PDxxxx\”,
For UNIX/Linux it may be – “/usg/filespace/exxx/dvxxx/” etc.

If you notice the above, not only the file path is different, but also the directory separator. The following C BSFN helps get the Install Path, the Separator, if its Client/Server.

I’m not sure if a similar BSFN exists in the latest versions of JDE, one thing I’m sure Oneworld XE does not have it, and that’s why the Business Function was created.

The “BuildPathFromEnvDataX” API is used to retrieve the complete install path. You can get the Continue reading BSFN to Get Install Path (for Import/Export)