manifest

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.