Pop up Report/UBE after Processed

Posted on by

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.

*Note: I’ve tested this only on OneWorld XE. This is the only Live system I’ve access to as of now.

The basic logic for this is based on getting the Job number for the UBE from the Server.

To get that, we need to get hold of the logged in Environment, Server on which the UBE runs from the OCM mappings, and its corresponding Job Queue Database Path. In most cases the Database Path and the Server are same.

Following is a sample code of how it is accomplished. The Detailed ER is available for download at the end of the Article.

CONTROL: BUTTON &Print Report
EVENT: Button Clicked
-----------------------------------------------------------------------
//
Get Audit Information
//
CALL( UBE:R5542406 , Ver: TEST0001 )
//
// Retrieve the Logged in Envt
Get Current Environment
//
// Get the OCM Mapping Server for the UBE
Fetch UBE Mapping from OCM
//
// Get the Mapping Server on which the Job Queue fires.
F9650.Fetch Single
//
// Change the DatabasePath to the above.
F986110 DS OVERRIDE
//
VA evt_LowerCaseDBServer_SRVR = ltrim(rtrim(lower([VA evt_DatabaseServerName_SRVR]),' '),' ')
//
// Get the Job Queue of the Fired UBE
Get Default Job Queue
//
VA frm_ReportName_FNDFUF2 = "R5542406_TEST0001_"
//
//Wait for some specified secs until the UBE is done.
F986110.Select
F986110.Fetch Next
While VA evt_JobstatusOW_JOBSTS is not equal to "D,E"

    Wait x seconds
    F986110.Select
    F986110.Fetch Next

End While
//
// Reset the DatabasePath Override.
F986110 DS OVERRIDE
//
// ————————-
// Retrieve and Show the PDF
//
If SV Engine_Type is equal to CO WINDOWS_ENGINE

    //This is for FAT clients
    Print F986110
    //

Else

    //This is for HTML Engine or Thin clients.
    //Build the URL to pick up the UBE output from
    VA frm_URL = “/servlet/com.jdedwards.jas.ube?”
    …..
    Run Executable(, VA frm_URL, “UBE”, , , )
    //

End If

Download the Detailed Event Rules of the same here
Please do write comments/vote if this helps.

8 thoughts on “Pop up Report/UBE after Processed”

  1. Pingback: Send Email with PDF Output | Deepesh M Divakaran

  2. justice Reply

    JDE version is 9.0 and TOOL version is 8.98.1.2.
    Here is the scenario,
    // Change the DatabasePath to the above.
    F986110 DS OVERRIDE
    VA evt_DatabasePath_DATP -> szDatabasepath
    The value of VA evt_DatabasePath_DATP is “JDEDB-900 Server Map”. The db owner of JDEDB-900 Server Map is SVM900.
    There are records in SVM900.F986110. But Why no records returned from the statement as below:
    F986110.Select
    VA evt_JobQueue_JOBQUE = TK Job Queue
    VA evt_CodePath_Server_PATHCD = TK Environment Name
    VA evt_UserId_USER = TK User ID
    SL DateToday = TK Date – Job Submitted
    VA evt_TimeLastUpdated_UPMT <= TK Time Job Submitted
    VA evt_LowerCaseDBServer_SRVR = TK Execution Host Name
    VA evt_WorkStationId_JOBN = TK Origination Host Name
    SL DateToday = TK Date – Last Activity
    VA frm_ReportName_FNDFUF2 <= TK Foundation – Future Use 2

  3. Pingback: Send Email with PDF Output | JDE Source

  4. alim Reply

    hi Deepesh M Divakaran,
    how to effect for all report ? because we need effect for all report. example in menu we only have REPORT (R55xxx) not have application (P55xxx).
    thank you for your advice.
    best regards,
    alim

  5. Subodh Reply

    Hi,
    It is of great help.It is succesfully running in my FAT client but I get an error that it is client only.Please elaborate on how to solve this error.
    Thanks in advance.

    • Deepesh Reply

      Hi Subodh,
      The BSFN – Print F986110 is client only. If the Engine Type is HTML or so, you will have to build the path to the PDF residing in the printqueue.

  6. Jérome Reply

    Hi Deepesh,
    I hope you are well.
    I created a BSFN with the event rules.
    The BSFN is OK on my local computer (Webclient and Fat Client)
    The compilation passes without problem on my computeur
    On the enterprise server, building the package is OK for the customer, but unfortunately, it’s KO on web server.
    Do you have an idea about the error?
    Thank you in advance.
    Jérôme

  7. chetan namdeo Reply

    hi Deepesh,
    I am unable to send the email over public network using tata photon data card even I am given
    right mail server IP in jde.ini file in JD Edwards Standalone Demo version 9.10.
    please help me.
    Regards,
    chetan Namdeo

Leave a Reply