This is a fairly handy post, if I do say so myself.
This firstly shows you how to convert a BLOB to readable text in oracle SQLPLUS and also shows you how to display manifest information for E1 8.12 and above using SQL
select
utl_raw.cast_to_varchar2(DBMS_LOB.SUBSTR(wbjpo, 2000, 1)) from dv812.f989999 where WBoID = 'MANIFEST-MANIFEST';
This will reveal something like:
¿¿ sr 9com.jdedwards.base.spec.manifest.SerializedObjectManifest 1¿? xpw
¿ Dcom.jdedwards.base.spec.manifest.SerializedObjectManifest/2005-10-07 DV812
DV812IF ¿F¿ ¿F¿ 0¿¿ 0¿¿
nsgshsjdnwb01 ~ MOIRS 0¿¿
n
sgshsjdnwb01 ~ MOIRSx
If you search through it, you'll find the important bits:
Note that if you've taken the planner ESU, you can just run the following application (P98770) which will tell you the same information. But if you can't bring the web up - then you might need to run my SQL above.
-
I’ve enabled auditing many times before. Everytime has been a nightmare. You need lots of space for big tables, this could be done MUCH bet...
-
Why am I still doing this. Fixing fat clients is not a lot of fun. Here is a couple of tips for connecting to the database using NTS and... -
This is a really handy tool for working out what DD items and tables are in use in JDE. This is a complete cross reference of JDE DD items,...
No comments:
Post a Comment