Gang:
We were having similar problems with table conversions and we found this document at Oracle/PSFT
Title: Unicode Flat File
Abstract: In PeopleSoft EnterpriseOne 8.9 the conversion to Unicode uses flat text files to communicate between PeopleSoft EnterpriseOne and other Systems. This document discusses this new functionality.
A conversion may be necessary when reading and writing flat files. This is due to the fact that while PeopleSoft EnterpriseOne 8.9 is capable of handling Unicode file the correct character set must still be defined. This enhancement to add application P93081 that provides a mechanism to control this conversion to allow the reading and writing of flat files in a given character set as defined in P93081. Due to the fact that PeopleSoft EnterpriseOne uses Unicode and not all third-party software does, there is a process handled though an API that will determine if an inbound or outbound flat will need to have the character set changed. During this process the software converts the flat file into the Unicode character set or back into the original character set. In the jdeCallObject API there is a parameter called LpBhvrCom that contains information to query the Unicode Flat File Encoding Configuration table (F93081) for the flat file encoding. This table is populated and configured by the Unicode Flat File Encoding Configuration program (P93081).You can assign the conversion character set applied to a flat file based on the user or role, the program ID, program version and the environment. This can be done by activating a flat file encoding record.
By doing this step, it allowed us to process the table conversions.