«

»

Apr 08 2010

Launch Batch Application/UBE Dynamically from Interactive Apps

VN:F [1.9.22_1171]
Rating: 5.0/5 (2 votes cast)

There have been many instances where you need to call different Version of an UBE/ Batch application based on the parameters of the application. Doing that is very easy, where in you just need to pass the Version name dynamically and the Report Name is hard coded into the ER.

But, if there arises a situation to call the Report/UBE Dynamically, you flinch a little. No worries, its as easy to do.

Following are two methods of calling ANY UBE from an Interactive Application.

*Note: You can not do Report Interconnects, or set PO Values/Data Selection dynamically

Launch Batch Application system function

Launch Batch Application system function is used only for WEB application that will launch the UBE. The system function will act like the Report Interconnect. It will launch the UBE.

Parameters:

Parameter Description I/O Required Notes Example (for typical
LaunchUBE)
Report Name String I Y UBE Application ID R550101
Version Name String I Y Y/N VERS01
Print Preview? Character I Y Y/N N
Data Selection? Character I Y Y/N – Override the data selection N
Data Sequencing? Character I Y Y/N – Override the data sequencing N
Push Spec Only? Character I Y Y/N – submit version specification only N
PO Template String I Y PO Data Structure T550101
Prompt for values? Character I Y Display the processing options dialog
(0/1/2 based on version detail)
1
Date Last Executed JDEDATE I Y Date SL DateToday
Data Source Override String I Y Server Name = takes ocm
mapped server name
JDE Log? Character I Y Y/N – Create JDE.log N
JDEDebug Log? Character I Y Y/N – Create Jdedebug.log N
UBE Logging Level Integer I Y Level of detail for Jdedebug.log 0
Jargon Code String I Y 00
Cover page? Character I Y Y/N – print cover page N
Job Queue name String I Y  Job Queue to run the UBE in <Blanks> = takes version
Job queue
TC Prompting? Character I Y Y/N N
Process Type Character I Y Default it to ‘Y’ Y

Find more info in the Oracle Documentation

Special Handling Instructions and Prerequisites
·    Must be used in a WEB application only.  Available on all events of Interactive applications


Business Functions to Launch a UBE

The Business Functions use the same JDE API – jdeLaunchUBEEx(); to launch the UBE.

B9800240 – Call UBE Application

Usage

Call UBE Application
  "R55xxxxxx" -> szProgramId
  "VER00001" ->  szVersion
  UNDEFINED X  cSuppressErrorMessages
  UNDEFINED X  szErrorMessageID
  1 ->  cPrintFlag

The PrintFlag can be passed any value 1/0 depending on your choice of print immediate or not.


B91300C – Launch Batch Application

Functional Description
This function launches a UBE from ER. Unlike Report Interconnect, this launches UBEs with out Report Interconnect and returns an error status. However, Report Interconnect cannot be used.
Purpose
To be able to launch UBEs without Report Interconnect from Event Rules and be able to check the return status of that UBE.
Setup Notes and Prerequisites
If called in synchronous mode, the BSFN will return error if the UBE failed along the way (blow-ups, spec not found, etc.). In asynchronous mode, the BSFN will return error only if it failed to launch (better always to use Asynch)
If the data source override is left blank, then OCM will be used to determine where the UBE will run.

Parameters :
szReport : Report Name
szVerzsionJDE : Version Name (if you execute the batch on the enterprise server, the version must exist there. You must launch the version at least once before use this BSFN on the server)
cSynch : 1 = Synchronous, 0 or anything else is Asynchronous.
cPrintPreview : I don’t know exactly the functionality of this parameter. (1 or blank works)
szDataSourceOverride : Not required. Only if you want launch the batch on a specific server or in local mode
cJDELogging : 1 log into jde.log, 0 nothing
cTracing : 1 log into jdedebug.log, 0 nothing
cUBEloggingLevel : 1..6 Debug Level
szJobQUEUE : Name of the Queue Batch where the batch is executed. it could be blank.

The BSFN returns a Job Number and an error code.

 


Give a thumbs up/share the site, if this helped you.

Published under the license.

VN:F [1.9.22_1171]
Rating: 5.0/5 (2 votes cast)
Launch Batch Application/UBE Dynamically from Interactive Apps, 5.0 out of 5 based on 2 ratings
(Visited 2,052 times, 1 visits today)

About the author

Deepesh M Divakaran

Deepesh MD is more of a Gizmo Geek, and a techie.
A very experienced Technical Consultant on Oracle JD Edwards EnterpriseOne, and OneWorld. As a consultant he has worked for wide range of industries, from Manufacturing, Media, Oil & gas etc. and has worked on re-engineering modules, and areas of customization.
With a touch of class and understanding towards what ever he does, he is often regarded by his colleagues as the one stop answer for all Technical/Software related queries.

3 comments

  1. ansen

    learn the Jde

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  2. Brandon

    Thanks for the quick reference on B91300C – Launch Batch Application – useful stuff!

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  3. SMS

    Is there a way to do the same thing as B91300C, but with the added functionality of passing parameters to the UBE? We filter results in a grid, then based on user selections, call the ube to run for each selected row in the grid. However the parameters are unique for each row and must be passed to the UBE as each row is processed. Thank you.

    SMS

    VA:F [1.9.22_1171]
    Rating: +1 (from 1 vote)

Leave a Reply