1)For workflow is there a way to search for items not yet released, if not could someone maybe point me to a way customize the "Active Workflows" page to change the column.You can search all items in the Release Manager applet. Could you specify what items you would like to search for? (use-case?) Note that OOTB only reviewers and/or admins should see the item in a certain workflow step.
2)While migrating some tables for drop down selection I noticed the table transfered but not the data in the table. I was using the Confid Migration Admin tool to do this and I was wondering if I'm missing something.Could you specifically describe what was your config in CMA and what table you intended to migrate? In general, I'd believe you need to use the Archiver, not CMA - see http://docs.oracle.com/cd/E23943_01/doc.1111/e10792/c08_migration.htm#CHDJAABJ (read the whole chapter for further details)