OAF Things to Remeber in Mind....

1)The Path to take DBC File from middle tier..
the DBC file is present at the application folder in the fnd TOP
/u03/FAUAT/fauatappl/fnd/11.5.0/secure/FAUAT_msftora2

2)query to find the responsibility key for creating OAF application

SELECT FAV.APPLICATION_SHORT_NAME, FAV.APPLICATION_NAME,FRV.RESPONSIBILITY_KEY, FRV.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL FAV, FND_RESPONSIBILITY_VL FRV
WHERE FRV.APPLICATION_ID=FAV.APPLICATION_ID and responsibility_name like '%Functional Administrator%'
ORDER BY FRV.RESPONSIBILITY_NAME ;

3)give the proper username and password  and give the responsibility short name and the responsibility key

4)give  proper database connection details
as
   1)  hostname
   2)  port
   3) SID or SERVICE NAME