Monday 9 May 2016

APPS : XML reports completing with warning

In cloned instance, all the reports are completeing with Warning state

Alert Log Error:
Errors in file /data/UAT/db/tech_st/11.2.0.3/admin/UAT_bctuat/diag/rdbms/uat/UAT/trace/UAT_ora_17385.trc  (incident=9206):
ORA-00600: internal error code, arguments: [kqludp2], [0x096D99A48], [0], [], [], [], [], [], [], [], [], []

Solution:
1. Shut everything down (Concurrent Manager ).
IMPORTANT: Verify NO Concurrent Manager processes are running on OS. This includes FNDLIBR, FNDSM, etc.

2. Run $FND_TOP/patch/115/sql/afopp001.sql as SYSTEM.
- Provide system username and password

3. Run $FND_TOP/patch/115/sql/afopp002.sql as APPLSYS.
- Provide apps username and password

4. Restart managers

5. Test the Reports.


Reference : (Document-id 1394729.1)

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...