you have posted paramter file, go one level up and from sessions logs provide the session log, look for any ORA_ error and paste the SQL that is erroring out
C:\Informatica\PowerCenter8.6.0\server\infa_shared\SessLogs sample log folder
Try running this standalone on the DW to see if you get same Oracle error
SQL Stmt : SELECT 'CODE', 'DESCRIPTION', 'CODE_ID', 'CATEGORY' FROM DUAL UNION SELECT LOOKUP_CODE , '1008262', 'JOB_FAMILY' FROM FND_LOOKUP_VALUES lookup_type = 'ITC_HR_JOB_GROUP' AND enabled_flag = 'Y';
ubfortunately I have not run HR in 796 for R12....
let's see someone who has done it comments here
however general the Task generates the SQL unless there is overwrite SQL that has syntax error, trying looking in informatica