Report Error to Excel/PDF

Today I get one case from my team who implement EBS in PGN (Perusahaan Gas Negara).

Issue :

When create report and try to open in excel, he got error message : "REP-3000: Internal error starting Oracle Toolkit"

These how step by step I solved the issue :

1. Log in to apps server as root.


2. Check inittab file : more /etc/inittab, see the id mode, if mode 5 by looking this line "id:5:initdefault".


3. I found inittab mode was 5, so :


4. 
   

   #export DISPLAY=:0.0



5. 
   

   #xhost +



6. Modify the context file.


7. 
   

   #vi /oracle/DEV/devappl/admin/PROD_devmrcap.xml (*vary depend your installation)



8. Find DISPLAY and change to : "<DISPLAY >:0.0</DISPLAY>" *something like that.


9. Log in with application user.


10. Run environment.


11. Shutdown application by :

#cd $COMMON_TOP/admin/scripts/

#sh adstpall.sh apps/apps

10. Make sure all process were stop by : #ps -ef | grep FNDLIBR ,they should be one process.

11. Run autoconfig : #sh adautocfg.sh apps/apps.

12. Startup application by : #sh adstral.sh apps/apps.