JDE Table Event Rules
I recently faced an issue with the Table Event Rules (TER’s) commonly called as Table Triggers(which is wrong. Actually Table Triggers occur outside JDE, like in a Database. Thus, JDE has no knowledge …
Change Database values using MS Access (JDE E1 Oracle)
For people who have problems with SQL, there’s an easier way of changing backend database values. How about using MS Access where you can directly type in the values, and it gets updated or you can Insert, Update Delete & you can export, import…. and all.
Following is the tutorial for setting up MS Access with Oracle Database Backend for JD Edwards EnterpriseOne.
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.