EnterpriseOne / Technical

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.

EnterpriseOne / Technical

Identify UBE Versions with Overrides

There is not a standard report or simple inquiry that can be performed to see all versions with overrides. The easiest way to determine this information would be to look at the F98761 table in the central objects data source and find all records with a specific version name that have record types other then just 1. This would indicate some type of override was performed on the object. Depending on the value in the record type field (RSRCRDTP) you can determine what type of override exists for the version.

EnterpriseOne / Technical

Value of SV File_IO_Status in Table IO

On an Update or Delete, SV File_IO_Status will always return “CO SUCCESS” even if the update or delete is not successful because the record does not exist.The workaround is to issue a FetchSingle on the record to be updated/deleted and use the result of the SV File_IO_Status of the FetchSingle to issue the update or delete.

EnterpriseOne / Guide

EnterpriseOne 9.0 Learning Resources/Tutorials

The JD Edwards EnterpriseOne Tutorials are created with User Productivity Kit or called as UPK. Oracle UPK provides a collaborative development environment to create system related assets – the “People to System” documentation – which are used throughout the rest of the project lifecycle