• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Launch batch application

flyingmg

Active Member
------=_NextPart_001_0000_01C095EF.2CFBDD80
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

List,

Is anyone know how to use "Launch Batch Application", a "General" system =
funtion in the interactive application design? What are the valid values =
to pass to those parameters? Thanks for your help.

G<br clear=3Dall><hr>Get your FREE download of MSN Explorer at <a href=3D=
"http://explorer.msn.com">http://explorer.msn.com</a>
</p>

------=_NextPart_001_0000_01C095EF.2CFBDD80
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML><BODY STYLE=3D"font:10pt verdana; border:none;"><DIV>List,</DIV> <D=
IV></DIV> <DIV>Is anyone know how to use "Launch Batch Application"=
,a "General" system funtion in the interactive application design? =
What are the valid values to pass to those parameters? Thanks for your he=
lp.</DIV> <DIV></DIV> <DIV>G</DIV></BODY></HTML><DIV>
<br clear=3D=
all><hr>Get your FREE download of MSN Explorer at <a href=3D"http://explo=
rer.msn.com">http://explorer.msn.com</a>
</p></DIV>

------=_NextPart_001_0000_01C095EF.2CFBDD80--
 

jastips

Active Member
Hi,

You have somany business functions to launch UBE's. Ex.B9800240.

Regards

Jastips
JDE CNC Consultant
DTI
USA
 

Zoltan_Gyimesi

Legendary Poster
Hi,

Your OneWorld release is very important in your issue and you have forgotten to share it with us.
I suppose that your system is XE because the mentioned system function still does not exist under B7331.

The documentation helps many times like now.
You can find these informations in the OneWorld help following the steps below:

1.) Sign-On OW as a User with blank language code (Domestic) in her/his user profile.
2.) Select Help/Content in the OW Explorer.
3.) Two overlapped help window will appear. Close the top one to gain access to the other.
4.) Select the "Tools, Technical and Foundation"
5.) Select the "OneWorld Tools API Reference" in the refreshed window
6.) Open the books in order:
* OneWorld Tools API Reference
* System Functions
* Interactive Applications
* Genaral System Functions
* LaunchBatchApplication
* ... and Voila

I have to mention that you can find lot of brief but useful information here in this help in a well orginized structure.

Finally I will copy the mentioned help topic for you on to the end of this post.

Hope, could help.

Good luck,
Zoltán
==================================================================
LaunchBatchApplication

Last Modified: OneWorld Xe | August 2, 2000

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
Report Name String I Y UBE Application ID
Version Name String I Y
Print Preview? Character I Y Y/N
Data Selection? Character I Y Y/N – Override the data selection
Data Sequencing? Character I Y Y/N – Override the data sequencing
Push Spec Only? Character I Y Y/N – submit version specification only
PO Template String I Y PO Data Structure
Prompt for values? Character I Y Y/N – Display the processing options dialog
Date Last Executed JDEDATE I Y Date
Data Source Override String I Y Server Name
JDE Log? Character I Y Y/N – Create JDE.log
JDEDebug Log? Character I Y Y/N – Create Jdedebug.log
UBE Logging Level Integer I Y Level of detail for Jdedebug.log
Jargon Code String I Y
Cover page? Character I Y Y/N – print cover page
Job Queue name String I Y
TC Prompting? Character I Y Y/N
Process Type Character I Y
Special Handling Instructions and Prerequisites

· Must be used in a WEB application only.

Available Events

Available on all events.

Related Topics

· Get WEB CDA, Launch Processing Options Dialog


==================================================================



B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Adrian_Chimirel

Legendary Poster
This particular BSFN is UNdocumented :(
Would you be so kind and specify what parameters are to be passed (for this one OR another one)?
Thaks,
Adrian
PS1 I tried to call it from a Row Exit button I added, and it gives me a "Invalid record".
PS2 The BSFN Zoltan speaks about is to be used for WEB applications ONLY :(

Xe U3 SP17, Oracle 806, Citrix, HTML, FormScape 2.1 Ent RS/6000, Dep NT4
 

franck_blettner

Active Member
This one can be used to launch a batch application :

Documentation

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.

If the data source override is left blank, then OCM will be used to
determine where the UBE will run.


Parameters :

szReport : Name of the report
szVerzsionJDE : Name of the version (if you execute the batch on the
enterprise server, the version must exists on it. You must launch the
version one time before use this bsfn on the server)
cSynch : 1 = Synchronous, 0 or anything else is Asynchronous.
cPrintPreview : I don't know exactly the funcionnality 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 return a job number and an error code.


If you don't want to use this function, you can simply create a BSFN to
launch an UBE.

Create a DSTR with these parameters :
OBNM : Batch to Execute
VERS : Version to Execute
USER : User that execute the batch
OWPWD : Password of the user
JOBQ : Batch Job Queue
PHYD : Printer Name
LL : Environment Name


Create a BSFN with this DSTR.
Create a variable with alias CMDS (Command String).
Initialize the variable with concat "<Path>RUNUBE " with all the parameters
to obtain something like this :
CMDS = "/u01/jde/b7332/system/bin32/runube <BATCH> <VERSION> <USER>
Then execute this command with the bsfn "execute external program"

Be careful this will work only on the server because the runube works only
on the enterprise server. You can map it with ocm on the server to prevent
error.
Advantage of this : You can specify the user that launch the batch, the
environment and the printer.
Disavantage : The batch can't be run in local mode and the bsfn work only on
the server.

Hope that will help you

Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 63
E-mail : franck.blettner@ravate.com

Current Version : OneWorld B7332 Oracle, RS600
Work on :
Oneworld B7321, B7331, B7332, XE
Platform, UNIX, AS400, NT
Database : Oracle, SQL, DB2



-----Message d'origine-----
De : owner-jdeowdev@jdelist.com [mailto:eek:wner-jdeowdev@jdelist.com]De la
part de Adrian_Chimirel
Envoyé : mardi 4 décembre 2001 19:30
À : franck.blettner@ravate.com
Objet : Re: Launch batch application


This particular BSFN is UNdocumented :(
Would you be so kind and specify what parameters are to be passed (for this
one OR another one)?
Thaks,
Adrian
PS1 I tried to call it from a Row Exit button I added, and it gives me a
"Invalid record".
PS2 The BSFN Zoltan speaks about is to be used for WEB applications ONLY :(

Xe U3 SP17, Oracle 806, Citrix, HTML, FormScape 2.1 Ent RS/6000, Dep NT4
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=24716
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE Developers mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+



Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 48
E-mail : franck.blettner@ravate.com
 

Adrian_Chimirel

Legendary Poster
Re: RE: Launch batch application

Salut Franck,

Thank you for your generous reply; one thing is missing ... the Business Function NAME! I failed to identify it. It is NOT:
- B9800240 Call UBE Application (remember I'm in Xe), nor
- X983052 Version List Launch UBE.
Both have different Data Structures, compared with the Document you posted.

I forgot to mention I need to launch this UBE locally (the DEFAULT-UBE-OCM Entry is set to LOCAL).
It can't run on the server because it is a copy of R40211Z, AND it creates Sales Orders based on the SO Z tables, and these tables, on their turn, are populated by other three T/C UBEs (and they HAVE to run locally).

I know it is not a big deal, the Report Interconnect prompts the user for the Print On Screen option, and they have to hit the Enter key, only; but why not doing it directly, in batch mode, without user intervention?

Thanks AGAIN,
Adrian

Xe U3 SP17, Oracle 806, Citrix, HTML, FormScape 2.1 Ent RS/6000, Dep NT4
 

franck_blettner

Active Member
RE: RE: Launch batch application

Excuse me for this mistake, the name of the bsfn is B91300C.

Could you explain me why your table conversion have to run locally ?

Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 63
E-mail : franck.blettner@ravate.com

Current Version : OneWorld B7332 Oracle, RS600
Work on :
Oneworld B7321, B7331, B7332, XE
Platform, UNIX, AS400, NT
Database : Oracle, SQL, DB2




-----Message d'origine-----
De : owner-jdeowdev@jdelist.com [mailto:eek:wner-jdeowdev@jdelist.com]De la
part de Adrian_Chimirel
Envoyé : mercredi 5 décembre 2001 16:57
À : franck.blettner@ravate.com
Objet : Re: RE: Launch batch application


Salut Franck,

Thank you for your generous reply; one thing is missing ... the Business
Function NAME! I failed to identify it. It is NOT:
- B9800240 Call UBE Application (remember I'm in Xe), nor
- X983052 Version List Launch UBE.
Both have different Data Structures, compared with the Document you posted.

I forgot to mention I need to launch this UBE locally (the DEFAULT-UBE-OCM
Entry is set to LOCAL).
It can't run on the server because it is a copy of R40211Z, AND it creates
Sales Orders based on the SO Z tables, and these tables, on their turn, are
populated by other three T/C UBEs (and they HAVE to run locally).

I know it is not a big deal, the Report Interconnect prompts the user for
the Print On Screen option, and they have to hit the Enter key, only; but
why not doing it directly, in batch mode, without user intervention?

Thanks AGAIN,
Adrian

Xe U3 SP17, Oracle 806, Citrix, HTML, FormScape 2.1 Ent RS/6000, Dep NT4
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=24759
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE Developers mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+



Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 48
E-mail : franck.blettner@ravate.com
 

Adrian_Chimirel

Legendary Poster
Re: RE: RE: Launch batch application

Franck, you made my day; it works like a breeze!

I didn't mention that Access is the database where the foreign tables (converted to Z files) reside.
Shortly, everything starts with an Excel file (the Property Tax Manager System outputs it).
Next, I created a linked (with the Excel output) table in Access; it is used to populate the foreign tables.
Finally, after the Sales Order Conversion & Generation is done, they can be printed as Sales Order (Invoice), and ... bill them.

Thanking you again,
Adrian

Xe U3 SP17, Oracle 806, Citrix, HTML, FormScape 2.1 Ent RS/6000, Dep NT4
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: RE: Launch batch application

Hi Adrian,

First I am glad to read that another issue resolved again with the help of the Forum. Thanks Franck.

Adrian, let me a maybe off-topic question: Why do you prefer Access database for foreign input instead of simple text files?
As far as I know Access requires a lot of memory mainly when you handle large number of records and it sometimes could cause problems.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Adrian_Chimirel

Legendary Poster
Re: RE: RE: Launch batch application

Servus Zoltán,

Now this is a VERY good question! Personally I am familiar with MS Access, but I'd be happy to use a text file.
BUT, some restrictions apply:
1 The ... hum ... legacy (Visual FoxPro) system (PTMS) used to provide billing info ability is limited to export in csv/xls format ONLY
2 The exported file (based on User Selection) randomly changes structure (read number of fields)
3 There is a business requirement to enable users to ... edit/update/insert/delete ... rows/records into the exported file
4 Another business requirement is to keep the number of records under (a tight) control; LESS than 1000 records are making it to the TConversion.
5 This time I was limited to developing precisely the same functionality/project structure with what we had in B7321.

Next year, maybe, I'll have the chance to change the process; from updating the local Access tables to updating an Oracle working table, that can be used as an input for the Table Conversions.

Should you have some ideas boiling there, please do not hesitate to brainstorm 'em with us!

Thanks for your (always) valuable inputs,
Adrian

Xe U3 SP17, Oracle 806, Citrix, HTML, FormScape 2.1 Ent RS/6000, AIX 4.2, Dep NT4
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: RE: Launch batch application

Servus Adrian,

Many thanks for your answer. I can totally accept why do you prefer and/or why do you have to use Access method.

Let's see the other side (ours):
(do you remember how many post had we produced as well privately as publicly on the Forum in the past about Table Conversion, Driver UBE and Foreign Tables? ;-)

1.) At our site there isn't any edit/update/delete requirement in the Exported/Imported intermediate files/tables but there is a requirement to make the interfaces as simple as possible. (On the other hand there are several Text Editors :) E.g.: I recently created two new and working on a third interface which have to communicate with an old VAX system traveling the data through a Linux system.
2.) The effected legacy systems on the other side of the interfaces (and its experts too) can much more easier receive and produce simple fixed field length text files.
3.) There isn't a requirement for the partners to have Access licences.

4.a.) We created our "flexible" type conversion BSFNs between strings and other OW data types (number, date) for both directions.
4.b.) Not too far in the past I copied the B34A1010 BSFN (Open, Close, Write String to Flat file operations) to a custom one and extended with "Read From" function and a bit corrected the error handling.

5.) After 3. and 4. I am able/can/spare/do not have to, etc.:
5.a.) Do not have to create ODBC Drivers, OW Data Sources, OW Environments, OCM mappings for the Foreign Tables which simplifies very much the implementation on the partner site.
5.b.) I do not have to retrofit the TC UBE when the input changes, moreover I do not have to use TC to receive/produce flat file at all.
5.c.) I can place all of my logic into a single UBE (not TC) which prints header, processing options, detailed info about records when required, error log, final status with statistical data (count of rows, different type of errors, etc.)
5.d.) No need to create Work Tables making possible to separate the Conversion Logic from the other Processing Logic and Report Reqirements into a simple TC and into a Drive UBE.
5.e.) I can simply get the folder and file name of the text file from Processing Options and/or UBE interconnect leaving a full flexibility for the users.
5.f.) The data of the different sessions could be stored under different file names (e.g. for archive purpose).
5.g.) If required, I can produce unique file names for outputs (e.g. based on a next number or time-stamp).

6.) This solution is a bit more system independent (see in 1. the OneWorld - Linux - VAX interfaces).
7.) There is much less problem with different character sets (e.g. ASCII, EBCDIC, etc.) and with special characters like our Hungarian letters with special accents.

I really hope that you can also accept my arguments and choice beside the text method.

Friendly regards,

Zoltán
P.S.1: What does it mean: 'em with us ?
P.S.2: My last argument is: I am much more experienced with text editors (like the complicated NotePad) than with Access :)))

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)<P ID="edit"><FONT SIZE=-1>Edited by Zoltan_Gyimesi on 12/7/01 11:43 AM.</FONT></P>
 

SMS1

Member
Mr Gyimesi,
Is there a way to launch batch applications from an interactive application AND pass variables (report interconnect values) to the UBE uniquely for each row in the grid without having the submit UBE screen pop up for each transaction?

Thank you,

SMS1
 
Top