TriniDBA

Problem: When the Active Users (PDF) report is run, it completes in error with the following log file:

+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDSCURSPDF module: Active Users (PDF)
+---------------------------------------------------------------------------+
Current system time is 17-JUL-2007 11:37:42
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
APPLLCSP Environment Variable set to :
XML_REPORTS_XENVIRONMENT is :
/u2/oracle/vis2ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to:  /u2/oracle/vis2ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
'.,'
Spawned Process 27647
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
Report Builder: Release 6.0.8.24.0 - Production on Tue Jul 17 11:37:53 2007
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
Enter Username:
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 3019814.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 17-JUL-2007 11:38:06
+---------------------------------------------------------------------------+

Solution: Change the DISPLAY environment variable in Oracle Applications.

Log on to Oracle Applications Manager, and navigate to Site Map > AutoConfig.

There are two context files: one for the Database tier and the other for the Applications Tier. In the Applications tier row, click Edit Parameters. Click the Environments tab. Expand oa_environment:generic_service. Under X11 Display (s_display), change ‘hostname:0.0’ to ‘:0.0’. Save the changes. Then log out of Oracle Applications Manager.

The context file for the application tier must be regenerated. On the server, source the environment, stop the application tier services (adstpall.sh), run AutoConfig on the application tier (adconfig.sh), then restart the application tier services (adstrtal.sh).

Refer to:

Metalink Doc ID: Note: 181244.1

Subject:  Configuring VNC Or XVFB As The X Server For Applications 11i

Metalink Doc ID: Note: 200474.1

Subject:  Comprehensive REP-3000 Troubleshooting and Overview Guide