How to Analyze Long running UBE’s
Source: Oracle UBE Performance Webcast Example Issue UBE runs for three days and never finishes. Need a valid profile to answer the question WHERE IS THE CODE/SYSTEM SPENDING ITS TIME? …
Change FileNames in Table Conversion or Business View in UBE
Many a times we need to change the Business view of a Report/UBE, which requires re-validating the event rules code. Worse, if you had to change the input file name in …
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.
Launch Batch Application/UBE Dynamically from Interactive Apps
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.
Send Email with PDF Output
E-Mail the output of your UBE using this simple functionality, by retrieving your JobNumber and simple JDE setups. Uses BSFN – B0500190 (SendEMailHRM) for Xe until 8.10, or B0500725 – Email Merge Letter for other versions.
Pop up Report/UBE after Processed
There are many instances where we do Report Interconnects from Interactive Applications, like print the Order from an order screen, or process something from an interactive application button. But, in all those cases, the report fires on the Server, and you need to go visit the Work Submitted Jobs to check the output. Every User asks for the same convenience, if they can get the output direct on the screen without going to the WSJ.
Here is a crude way of popping up a UBE output onto the screen, without going to the Work Submitted Jobs. This makes life easy for the users.
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.
Free tool for viewing / testing JDE Objects
JDE Objects Browse – Object Browser for XE through E90. Examine and test JDE objects from a simple, intuitive framework.