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. . . . → Read More: Change Database values using MS Access (JDE E1 Oracle)
|
|||||
|
 2 comments  EnterpriseOne, Guide  backend, Change, class, Database, default, delete, download, E 9, E9, Edwards, EnterpriseOne, Export, import, Insert, install, JD Edwards, jd edwards enterpriseone, JDE, JDEDATA, LOCAL, MACHINE, MS Access, Oracle, oracle database, SOFTWARE, sql, Standalone, Start, Table, technology, Update, value, Windows, XP The Century for Calendar or Defaults for Effective dates comes in as 2010, and any year more than that is automatically defaulted to 19XX, to fix it change the value of couple of Data dictionary items – CENTCHG & DCYR . . . → Read More: Changing the Century for Calendar or Defaults for Effective dates |
||||
|
Copyright © 2010 Deepesh M Divakaran - All Rights Reserved |
|||||
Recent Comments