Category Archive: Technical

Technical, Development, FDA, TDA, RDA, DD, forms, reports, ube, interactive versions, batch programs

Oct 22 2014

Form Control UI Actions [BSFN API]

Ever wondered, if we can enable/disable controls, change the font, hide/show grid columns, do subform actions from a BSFN? Well, all those FDA system functions have an equivalent JDE API and can be used in a wide array of scenarios, like creating a pivot table from data. The list of API’s are asĀ as follows. (You …

Continue reading »

Sep 26 2014

Automated emailing of completed UBE PDF/CSV files

This entry deals with the issue of enabling E1 to email out completed jobs PDF or CSV files. This is currently capable via OSA or BI but requires a developers busy little fingers to get each object UBE to email the completed file out of E1. All UBEs in E1 write a record to F9861110, …

Continue reading »

Sep 22 2014

How to Upload XML info into BLOB field in table?

  Some time we need to upload XML info into table by using BLOB field. How can we achieve that, here are the steps Create or search for table that has BLOB field (example standard table : F70XMLZ1) Create BSFN or modify standard BSFN (depending on your requirement ) Add following code to update or …

Continue reading »

Aug 27 2014

Email UBE’s output from within itself [How-To]

Did you know that you can send or email off a report’s output from within itself? Its easy, just a one time BSFN build, and then use it wherever you want.
The key to sending output as attachment is to retrieve the JOB Number (JOBN) of the batch job. Earlier days, we used to have a job being fired off from a Driver UBE (that way we get the job#), which would then pick up the report output and then email it as attachment. But then we had issues with passing in Interconnect values, or override Data selections etc. The latest addition is the BI Publisher, where you can have beautiful reports generated, and then emailed off.

Jul 12 2014

Record Reservation [Basic Code Tips]

Just posting basic code tips – vis a vis Standard Record Reservation (P00095) The Record reservation is used to lock records within an application so that none else would be able to modify it over at the same time, basically to retain data integrity. One can then release locked records using the standard application – …

Continue reading »

Page 3 of 1212345...10...Last »