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, [...] . . . → Read More: Automated emailing of completed UBE PDF/CSV files
Simplifying the debuglog The jdedebuglog can look a mess to start with but can be broken down. SQL statements etc are shown but one handy trait is the fact the BSFNS calls have levels. Much like nested Ifs. This helps us see what BSFNs were called in our code. Every BSFN is listed but [...] . . . → Read More: Simplifying the JDE debuglog
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 [...] . . . → Read More: How to Upload XML info into BLOB field in table?
Information is one of the most important assets of any organization. Hence it should be appropriately protected. Information needs to be available and accessible uninterruptedly for the smooth functioning of any organization. Information security describes activities that relate to the protection of information and information infrastructure assets against the risks of loss, misuse, disclosure or [...] . . . → Read More: Information Security and Governance in ERP Implementation [Whitepaper]
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. . . . → Read More: Email UBE’s output from within itself [How-To]