Monthly Archives: September 2006

Custom Report Completes With Error After Applying HRMS Family Pack K

Problem: After applying HRMS Family Pack K, custom report “Invoice Print Selected Invoices” completes with error.

Solution: Apply patch 4233321 and regenerate XML templates

Refer to Metalink Doc ID:  Note:368592.1 (Subject:  Extension Function Error: Method not found ‘ms_format_string’ Running XML Report Publisher)

Step 1: Download and apply patch 4233321 (all prerequisite patches were checked and were met).

Step 2: Add XML Publisher Administrator responsibility to Sysadmin.

Step 3: Applying this patch will add the XML Publisher Template Re-Generator concurrent program to the XML Publisher Administrator responsibility. Use Standard Request Submission to submit this request. This program prompts for the following parameter:

Re-Generation Criteria:

Select “Outdated” to regenerate only outdated templates or

“All” to regenerate all templates.

Remote Diagnostic Agent Usage Instructions

To execute the test, do the following:

  1. Start Oracle eBusiness Suite
  2. Connect to a responsibility that has Support Diagnostics enabled (see Note 358831.1 for details)
  3. Select the Diagnostic Tools menu option
  4. Select Application “Applications DBA” from the list of values displayed
  5. Click the “Advanced” tab
  6. Scroll down to group “Data Collection”
  7. Select test name “RDA”


Subject:  Remote Diagnostic Agent (RDA) Data Collection Test

Doc ID:  Note:183274.1

Subject:  Remote Diagnostic Agent (RDA) 4 – FAQ

Doc ID:  Note:330363.1

Subject:  Remote Diagnostic Agent (RDA) 4 – Core Engine Man Pages

Doc ID:  Note:330777.1

Subject:  Remote Diagnostic Agent (RDA) 4 – Download

Doc ID:  Note:330472.1

Subject:  Remote Diagnostic Agent (RDA) 4 – Overview and User Guide

Doc ID:  Note:314422.1

Configurating Oracle Diagnostics Tool Responsibility

This documentation shows how to set up the Oracle Diagnostics Tool responsibility after installing it.

The following tasks should be completed using a responsibility that can assign responsibilities (e.g. “System Administrator”).

Step 1:        To assign the “Oracle Diagnostics Tool” responsibility to eBusiness Suite users.

If “User Management” responsibility is available:

  1. Select the “User Management” responsibility
  2. Click on “Users”
  3. Query the user to which the “Oracle Diagnostics Tool” responsibility should be assigned
  4. Select the “Update” icon
  5. Click the “Assign Roles” button
  6. Search for “Oracle Diagnostics Tool”
  7. Tick the “Select” check box and then click the “Select” button
  8. Fill in the “Justification” text field and then click the “Apply” button
  9. Click the “Home” hyperlink to return to the eBusiness Suite home page

If “User Management” responsibility is not available:

  1. Open the “Users” form (Security > User > Define)
  2. Query an existing user
  3. Add a row in the Responsibilities sub-tab region
  4. Select “Oracle Diagnostics Tool” responsibility (Application: “CRM Foundation”) from the responsibility LoV
  5. Click “OK” and save the record

See Metalink Document Subject:  Diagnostics Responsibility Configuration

Doc ID:  Note:358831.1

Restoring Missing “Show Desktop” Icon

To locate the file needed for the command, use the Find or Search function from the Start button and search for files and folders on the primary drive (usually C:) with the search phrase of “Show Desktop.scf” (including the quotation marks).

If you don’t find the file, you can recreate it by opening Notepad (in the Accessories section of the Programs menu) and typing the following lines:






Save the file with the name “Show Desktop.scf” to your Desktop (this time without the quotation marks). Close Notepad and locate the newly created Show Desktop icon, then left-click and drag it to the Quick Launch toolbar.

Firewall Error Service Unavailable

Problem: When access the production instance, a web page appears stating ‘Service Unavailable’.

Solution: In Internet Explorer, enter the instance’s host name in the list of hosts for the proxy server to bypass.

Changing Title Bar and Background Colour

Step 1: Log on as user SYSADMIN and choose the System Administrator responsibility.

Step 2: Navigate to Profile > System to load System Profile Values.

Step 3: Search for “Java Color Scheme” profile to update the background colour scheme.

Step 4: Search for “Site Name” profile to change the text that appears in the title bar.

Enabling Maintenance Mode in SQL

Problem: Show how to enable or disable maintenance mode from SQL.

Solution: Run adsetmmd.sql

Step 1: Set up the environment by running APPSORA.env:


Step 2: Change directory to $AD_TOP/patch/115/sql/:

cd $AD_TOP/patch/115/sql/

Step 3: Run the SQL script:

sqlplus apps/apps @adsetmmd.sql ENABLE | DISABLE

Step 4: Bounce the Apache Web listener. (

See Metalink Note: 291901.1 (Subject:  Maintenance Mode – A New Feature in 11.5.10)

Oracle Applications Not Printing

Problem: Printer prints a test page correct, but OA does not print.

Solution: Set up the Linux printer driver to an earlier version.

Printer Model Linux Printer Driver
LQ-870 LQ-510
LQ-670 LQ-550

Printer Not Appearing In Submit Requests

Problem: Printer not appearing in Submit Requests.

Solution: The printer does not have the style associated with the report. Set up the Style associated with the printer from System Administrator > Install > Printer > Types.

Deleting Oracle Services

Problem: How can Oracle services from a partial install be deleted?

Solution: Delete the key for the service from the registry.

Regedit > HKEY_LOCAL_MACHINE > System > Current Control Set > Services

Delete the key.


See also:

tasklist /svc

Note: to temporarily disable a Service while troubleshooting:

Start | Run (type) “msconfig” (no quotes)

Click on the Services tab, uncheck desired service. (for testing only!)

Start > Run > services.msc