Does that title sound funny? Can you update your Primary Keys of a record in a table too? Ofcourse you can, SQL does allow it. But does that work in an ERP? Yes ERP’s are supposed to keep their data integrity well, and secure it too. But in JD Edwards …
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.