Many a times we need to change the Business view of a Report/UBE, which requires re-validating the event rules code. Worse, if you had to change the input file name in a Table Conversion? You will have to actually re-write the whole code.
Usually, for such table conversions, what we do is write wrapper UBE’s which would rename the input file to the path/file name of the table conversion, and then trigger the TC to run. All these options take huge amount of efforts.
But now on, take out 5 mins off, and you can change the File name in a TC via the following method. You can also change the Business View or Processing Options without having to re-validate the complete event rules using this same method.
- Do a Save Location
on the object for which you need to change and save it as ZIP file (note the location where its saved)
- Its usually saved in “E1pathcode\spec” folder
- Now, rename the UBE_R55xxxx…..PAR file to a .ZIP extension
- Open the .Zip file using Winzip, or using the Windows Compression utility
- Within it open the SPEC.Zip file.
- Open the RDASPEC folder within the Spec.Zip file
- Find the .xml File with highest size, and Edit it.
- After making the required changes, save the file and close.
- Winzip will ask if to update the file with the changed one.
- Say YES.
- Now rename the .ZIP file back to .PAR
- Restore your object
using this .PAR file. Viola the file name/BSVW/PO has changed.
- You may get a AS/400 error, which can be ignored.
- REVALIDATE your event rules after restoring, and of course feel free to test it.
Thanks to Imran Ahmed Siddiqui at a discussion on LinkedIn, where I got the idea off.
NB: JDE Tools – 8.95 onwards, you have the option to rename the input file in table conversions.
Do let know your experience and your comments of course.
This is awesome!!!
I want to change the BSVW name and followed all the steps given untill 6th one.
I am unable to edit the XML file, can you pls throw some light how can I edit it..
E812, Tools Release 8.98.21
Hi Lak,
It would be easier to search for the BSVW in the folder extracted, and then edit all those files. Actually, separate XML files are generated for each section of the report. So while editing, make sure that you are editing the one you need.
Hey Deepesh, Hope you are doing great… and kudos on being one of the most referred websites in the JDE world now 🙂
Had a question on the above method. Do you know if this shortcut works to change the view on a form in an interactive application? I tried to do this in the spec.zip file for one of the applications, but it gave me an error on doing a restore. The error was specifically on the manifest.xml file in the .par file. I ensured that I checked all the .xml files in the spec and changed the business view name to the new business view in every file where it existed.
I noticed that you have specified TC’s and UBE’s only in the above post, any reason it will not work for an interactive app?
Appreciate your inputs..
Regards,
Pooja
Hi Pooja,
Thanks 🙂
The view change works only if there’s a single form in an application, not the way it would work in a UBE, where there could be many sections.
Thanks Deepesh.. I am trying to change the view on a custom copy of P09210A (Trial Balance).. it has just one form, and I went in and changed the view in all the xml files where I found the old view.. didnt work.. also tried changing it only in the largest xml file, that threw an error as well. I also tried it on a small and simple application with just one find browse form with a business view on F0101. The restore gave an error even in this case. Not sure if there is anything else that I need to do. Will look into it further… thanks for your inputs.. 🙂
Regards,
Pooja
Try using the XML Notepad (from Microsoft) for editing the files, you might be having issues with Notepad / editor.