We get the following error when attempting to fetch AOL Responsibilities from production and dev environment. Other object types are working fine from these environments.
ERROR: SQLException: Invalid character encountered in: failAL32UTF8Conv
Run the following query against the environment that cannot be fetch. Make sure to export the data into some type of format such as excel sheet that does not strip out special character. Now take a look at the data to see if you see any special character such as question mark inside of a black diamond. You will need to remove this special character for that aol responsibility.
SELECT DISTINCT ADG.APPLICATION_SHORT_NAME||'::'||RV.RESPONSIBILITY_KEY||'::'||DG.DATA_GROUP_NAME||'::'||RV.RESPONSIBILITY_NAME AOL_VALUE FROM FND_RESPONSIBILITY_VL RV,
FND_APPLICATION A,
FND_MENUS M,
FND_APPLICATION ADG,
FND_DATA_GROUPS DG,
FND_APPLICATION ARG,
FND_REQUEST_GROUPS RG,
FND_PRODUCT_INSTALLATIONS P
where A.APPLICATION_ID = RV.APPLICATION_ID
and ADG.APPLICATION_ID = RV.DATA_GROUP_APPLICATION_ID
and DG.DATA_GROUP_ID = RV.DATA_GROUP_ID
and ARG.APPLICATION_ID (+) = RV.GROUP_APPLICATION_ID
and RG.REQUEST_GROUP_ID (+) = RV.REQUEST_GROUP_ID
and RG.APPLICATION_ID (+) = RV.GROUP_APPLICATION_ID
and M.MENU_ID = RV.MENU_ID
and RV.VERSION IS NOT NULL
and P.STATUS in ('I','L','S')
