Blog directory

Change FileNames in Table Conversion or Business View in UBE

JDE Object Save Restore

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 . . . → Read More: Change FileNames in Table Conversion or Business View in UBE

Using BSFN to Delete All Records from a Table

BSFN – B8000002 (Delete All Rows From Table) does a delete * from tablename. The B8000007 and the B8000002 business functions must be used together to delete all the rows in a table. They will not delete the table specifications or the physical table in the database. B8000007 must be called first to get the environment handle, with the handle only then B8000002 is able to delete all records from the specified table. B8000007 must be called again to free the handle. . . . → Read More: Using BSFN to Delete All Records from a Table