Tag Archives: PDF Setup

System failed to generate the PDF document

Problem:

After installing the R12.1 Vision instance on Windows Server 2003 and patching to R12.1.3, navigated to Purchasing, Vision Operations (USA) > Buyer Work Center > Orders. Selected an order’s radio button, selected View PDF from the drop-down list and clicked Go.

The following error was displayed:

System failed to generate the PDF document. Please contact your system administrator.

Solution:

Navigate to the XML Publisher Administrator responsibility > Home > Administration. Under Properties > General, change Temporary directory from /tmp to C:TEMP and save.

Sample 11.5.9 to 12.1.1 Upgrade Steps

1. Preparing for the Upgrade

Apply 11i.AD.I
Back up database, Applications, and customizations
Prepare an upgrade plan for customizations
Convert to Multiple Organizations architecture
Review sizes of old and new tablespaces
Review Upgrade Tasks and Apply 11i.AD.I

Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer
Financials and Procurement Tasks
Gather schema statistics for CBO
Back up the database
Run Rapid Install
Migrate or upgrade your database to Oracle 10g Release 2
Port application to Linux servers

2. Upgrading to Release 12

Disable AOL Audit Trail
Migrate database to Oracle10g Release 2
Back up the database
Apply Release 12 AD minipack
Run the American English upgrade patch driver
Run the NLS upgrade patch driver
Apply latest product patches
Synchronize NLS and American English product patches
Back up Oracle Applications

Finish the Upgrade
Configure Applications client software for forms applet (required)
Reapply customizations (conditional)
Integrate custom objects and schemas (conditional)

Finish System Administration Tasks
Complete Workflow Notification Mailer configuration (required)
Complete setup for Oracle XML Gateway (required)
Enable PDF printing (required)

3. Post-upgrade Tasks
Install online help
Update/verify custom responsibilities
Migrate custom development to new technologies
Migrate the CUSTOM library
Copy and re-customize modified scripts or reports
Review user responsibility assignments
Associate organization names with custom Alert definitions
Set operating unit mode for customizations
Assign the Report Manager Data Migration Program to a request group
Run the Data Migration Program

Update Status Monitor URLs
Synchronize Product License and Workflow BES license status
Financials and Procurement Tasks
Additional Tasks

Resolving REP-3000 Error

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

Registering New Active Users Report

This documentation illustrates how to copy an existing report to a new report and register it in Oracle Applications. The Active Users report shall be used as an example.

Step 1:        Log on to Oracle Applications and choose the System Administrator responsibility. Navigate to Concurrent > Program > Define.

Step 2:        The Concurrent Programs form appears. Press F11 and type ‘Active%’ in the Program field. Then press Ctrl+F11.

Step 3:        The Active Users program appears in the form. Click the Copy To button.

Step 4:        The Copy To form appears. Enter ‘Active Users (PDF)’ in the Program field, and ‘FNDSCURSPDF’ in the Short Name field. Then click OK.

Step 5:        The Active Users (PDF) program appears in the form. Change the Output Format field to ‘PDF’. Then click Save.

Step 6:        Navigate to Security > Responsibility > Define. The Responsibilities form appears. Press F11. Type ‘System Administrator’ in the Responsibility Name field and ‘System Administration’ in the Application field, and press Ctrl+F11.

Note the Request Group Name and Application.

Step 7:        Navigate to Security > Responsibility > Request. The Request Group form appears. Press F11 and type ‘System Administrator Reports’ in the Group field and ‘Application Object Library’ in the Application field. Then press Ctrl+F11.

Step 8:        Select the record to insert the new record under, then click New. In the Name field, select ‘Active Users (PDF)’ from the list. Then click Save.

Step 9:        The report now appears in the Concurrent Requests list under System Administrator.

Step 10:   If there are any issues viewing the PDF reports, it may be necessary to change the PDF profile options. Search for ‘PDF’ or ‘Viewer’.