Graphs are not appearing in XML/BI Publisher reports - How to debug it?

1. Make sure that graphs are appearing in XML Publisher Desktop
2. Deploy the report in Oracle Apps
3. Run the report. Graphs are not appearing.
4. Use http://oraclesanpra.blogspot.ae/2013/06/how-to-find-opp-log-file.html to generate OPP log and provide that to DBA. Check if OPP log has below error message

“Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Error invoking 'chart_svg':'java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment'”

How to find OPP log File?

To investigate on XML issues or other publishing problems, often the OPP logfile is needed.
OPP stands for Output Post Processor. Below are the steps to find log file

1. Login to the application as SYSADMIN

2. Responsibility: System Administrator

3. Function: Concurrent --> Manager --> Administration

4. Select the Output Post Processor

5. Click on the Processes button

6. Select the Concurrent Process which was active during the time that the request ran

7. Click on the Manager Log button to open the Output Post Processor log file


Cheersss...

How to Identify Layout ldt file name in Oracle Time and Labor(OTL)

Check Page 13 of hxcconfiguiwp.pdf document

Clear Cache Shortcut in Functional Administrator

Function Name - Cache Component Global Configuration Page

Updating Layout in Oracle Time and Labor (OTL)

Steps:
1. Download the correct ldt file from $HXC_TOP/patch/115/import/US
2. Update the LDT file to removed the unnecessary part. Remove the whole "Begin End" part.
3. Go to dir: $HXC_TOP/patch/115/import/US and Upload the updated file to the directory
4. Issue the following Cmd:
FNDLOAD username/password@dbname 0 Y UPLOAD $HXC_ TOP/patch/115/import/hxclaytlayoutsld.lct hxczzhxclayt0030.ldt
5. Check the log file
6. Bounce apache
7. Login and check.


Done!!!