To get more clarity , could you please provide error / log file message ?
After clone R12.1.3, none of the reports work, but all the concurrent reports finished fine, what issues could be
This is not enough for anybody to give you some guidance i think, please provide more details. Are you talking about xmlpublisher reports or even standard reports
What is happening when you click on output? Any error
NO error, they all just hung for ever, all the reports have the same problem, including active users reports, but all the concurrent requests finish fine. thanks
What OS are you using? It appears some OS requirements for Oracle Reports are not met:
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (Doc ID 761566.1)
Make sure this section was done:
Update AS 10g (10.1.2 and 10.1.3) Oracle Homes (Oracle Linux 6, RHEL 6, Oracle Linux 7 and RHEL 7 only)
Thanks, it is Red-hat6, the OS is fine.
Relink all 10.1.2 executables by running the $ORACLE_HOME/appsutil/clone/adlnktools.sh and report if it completes error free.
Thanks, we have done that, no error
Open a VNC, console or xming session and start reports builder and see if you can browse a report successfully.
rwbuilder.sh FAS400.rdf apps/apps_pw
Can you share concurrent request and manager log files please
What is set for your xml publisher tmp directory? Does it exist?
XML Publisher Adminstrator -> Home -> Admin -> General -> Temporary directory
What are the active users reports log details?
Do you have a preference file?
How to Update Preference File
file $AD_TOP/admin/template/iAS_1012_env.tmp and add the following:
Or you can add it to your $HOME directory.
R12: Executing A Report Fails With REP-0004: Warning: Unable to open user preference file. (Doc ID 1303903.1)