Project Rollup Patches Not Completing On DB Tier

Posted by on April 20, 2007 No comments

Problem: When applying Project Costing rollup patches to DB tier, the following errors are returned:

adlibout: error: cannot get table of contents in library file for product pa

File name is f:/oracle/prodappl/pa/11.5.0/lib/past.lib

Solution: mspdb60.dll not in the path.

Another issue was encountered on the system, which the application modules were relinked. While relinking, the message ‘gnumake: Error 128’ appeared. Metalink Doc ID 123595.1 and 142390.1 indicated that the mspdb60.dll file was not in the path (on the DB tier). After modifying the path, the relink completed successfully.

The Project Costing rollup patches were then reapplied, on both tiers, and all patches went through successfully. Relinking appears to be part of the patching process for the Project Costing rollup patches.

Configuring Expediting Report To Copy To Network Share

Posted by on February 12, 2007 No comments

This documentation shows how to configure Oracle Applications to automatically copy the expediting report to a remote network share for use by SharePoint.

To copy the expediting report, a virtual printer was set up. When the expediting report was sent to this virtual printer, the output file (in HTML format) was copied to a remote network share. A link was set up in SharePoint to point to this file.

Setting up virtual printer

Step 1:        To set up a new printer in Oracle Applications, select the System Administrator responsibility. The custom Printer Style and Printer Driver must be set up first. Navigate to Install > Printer > Style.

Step 2:        Click the New button to enter a new style.

Step 3:        Enter the following information in the Print Styles form:

Style Name: copy_expediting_report

Seq: 87

User Style:   copy_expediting_report

SRW Driver: L

Columns: 132

Rows: 66

Step 4:        After entering the information, click the Save button.

Step 5:        Next, navigate to Install > Printer > Driver . Set up the printer driver as shown below:

Driver Name: copy_expediting_report

User Driver:   copy_expediting_report

SRW Driver: L

In the Arguments field, enter the following command (one line):

cmd /c “copy /Y $PROFILES$.FILENAME \ppnets01Expediting_ReportPPGPL_EXPEDITE.html”

Save the changes.

Step 6:        Navigate to Install > Printer > Types to enter a new printer type. Type Ctrl+F11, then use the Up and Down arrow keys to locate the HPLJ4SI printer type.

Under Printer Drivers, click any row under Style, and then click New. A new row appears. Enter the names of the custom style and driver created in the previous steps. Then click Save.

Step 7:        Finally, navigate to Install > Printer > Register to register the new printer.

Type Ctrl+F11 to list the printers currently registered. Click New to enter a new printer. Type the name of the printer, the printer type (HPLJ4SI) and a description. Click Save to save the changes.

Updating Concurrent Program to Use Virtual Printer

Step 1:        Modify the concurrent program setup for the expediting report to point to the new printer. Navigate to Concurrent > Program > Define.

Type F11, enter USER_EXPEDITE in the Program field, and then type Ctrl+F11. Under Output, change the values for Style and Printer to those specified in the previous section. Ensure that Format is set to HTML.

Setting Up New Responsibility

In order for the report to be copied, it must be printed to the virtual printer with one copy, and not the default of zero copies. In order to automatically copy the file, the report must be set to print one copy by default.

The default number of report copies is set as a system profile value, and can be set at the application, responsibility or user levels. Once set, all reports under that level will print the specified number of copies by default.

Because all reports under the specified application, responsibility or user will be affected by changing the number of default report copies, a new responsibility was created and the report registered under this responsibility, so that the number of copies could be specified for the responsibility.

Step 1:        Navigate to Security > Responsibility > Request. Click New and enter the following information. Click in the Name field to enter the report and application name. Then click Save.

Step 2:        Navigate to Security > Responsibility > Define. Enter the following information. This will attach a basic menu to the responsibility created above. Under Effective Dates, change the From field to 01-JAN-1951.

Step 3:        Next, add the responsibility to a user. Navigate to Security > User > Define.

Type F11, enter the username that you wish to add the responsibility to, then type Ctrl+F11. Click under Direct Responsibilities, then click the New button. Select the name of the responsibility entered in the above step. Then click Save.

Setting Profile Option

Step 1:        The profile value must be set for the new responsibility so that the default number of copies for the report is one. Navigate to Profile > System.

In the Responsibility field, enter the responsibility set up in the previous section. In the Profile field, enter “Concurrent%” and then click Find.

Step 2:        Locate the Profile “Concurrent:Report Copies”. Under Responsibility, set the value of the field to 1. Save the change.

Scheduling Concurrent Program

Step 1:        To set up the schedule for the report, click the Switch Responsibility button.

Step 2:        Select the custom responsibility for the expediting report.

Step 3:        Navigate to Requests. The Submit Request form automatically appears since there is only one report registered in this responsibility.

Step 4:        Click in the Parameters field and enter the following parameters. Then click OK.

Start Date 01-Jan-2001
End Date 01-Jan-2010

Step 5:        Click the Schedule button.

To schedule the report to run every 30 minutes, select Periodically, then enter 30 in the field. Click the down arrow head and choose Minute(s). Then click OK.

Finally, click Submit. The report begins running immediately and will execute every 30 minutes thereafter.

Creating Database Link To Transfer FSG Reports

Posted by on January 29, 2007 No comments

Problem: A database link must be created in the Target instance to pull (transfer) FSG information to the production instance from the test instance.

Solution: Use Define Database Links in Oracle Applications.

To define a database link in General Ledger perform the following steps

on the Target instance (the one you are copying to):

Step 1:        Log on as sysadmin user and select a GL responsibility.

Step 2:        Navigate to Setup > System > Database Links.

There are six fields that have to be entered:

  1. Database Name
  2. Description
  3. Connect String
  4. Domain Name
  5. APPS Username
  6. APPS Password

Step 3:        In the source database, enter the following SQL query:

SELECT value FROM v$parameter
WHERE UPPER(name) = 'DB_NAME';
VALUE
--------------
PROD

This value is to be entered in the ‘Database Name’ field in Oracle Applications.

Step 4:        In the source database, enter the following SQL query:

SELECT value FROM v$parameter
WHERE UPPER(name) = 'DB_DOMAIN';
VALUE
---------------------

This value must be entered into the ‘Domain Name’ field in the form. If it is null, any value can be entered into this field (e.g. WORLD).

Step 5:        On the target database, grant privilege to apps user (log on as system user):

grant create database link to apps;

Step 6:        Ensure the two hosts are in the hosts file on each host.

127.0.0.1     localhost
128.x.x.x   oracleserver.domainname  oracleserver
128.x.x.x   oraclesrv.domainname     oraclesrv

Step 7:        Update the TNSNAMES.ORA file on each server with the entry for both instances:

PROD=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.domainname)
(PORT=1525))
(CONNECT_DATA=
(SID=PROD)
)
)
MFGP=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESRV.domainname)
(PORT=1527))
(CONNECT_DATA=
(SID=MFGP)
)
)

Step 8:        Ensure that the TNSNAMES.ORA was set up correctly using tnsping to ping the remote instance.

Step 9:        Ensure that SQL Restriction is turned off

Step 10:   Bounce the 920 TNS listener on each node.

Step 11:    Ensure that you can log on the other instance using SQL*Plus.

Step 12:   Enter the following values into the form:

Field Value
Database Name PROD
Description Test Database
Connect String PROD
Domain Name WORLD (since it is null, any value can be entered)
APPS Username apps
APPS Password apps

In the SQLNET.ORA file, I had to comment out the line: sqlnet.authentication_services= (NTS)

# sqlnet.authentication_services= (NTS)

Refer to Metalink Documents:

Doc ID 161635.1: (FSG Transfer Troubleshooting Guide)

Doc ID:  Note:1057188.6 (WHERE DO YOU DEFINE DATABASE LINKS FOR FSG’S?)

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]

REP-3002 Cannot Print to Printer After Installing

Posted by on December 12, 2006 No comments

Problem: After installing a fresh instance, when Active Users report is run, it exits with error.

Solution: Run ccmsetup. Delete the concurrent manager service, then add back service. Remember to set apps password, database sid and Automatic  checkbox. Reboot the computer.

Personal Home Page not appearing

Posted by on December 10, 2006 No comments

Problem: After installing Oracle Applications, the personal home page does not appear in the browser.

Solution: The machine name does not appear in the Bypass Proxy Server setting.

Step 1:        In Internet Explorer, navigate to Tools > Internet Options > Connections > LAN Settings > Advanced. In the Exceptions box, enter the name of the server.

Basic Linux Commands

Posted by on December 5, 2006 No comments

This documentation covers some basic Linux commands used with Oracle.

In these examples, the example file name is filename.ext. Substitute the correct filename as necessary.

1. To list files in a directory:

ls

2. To list files in a directory in list format:

ls –l

3. To change directory to the oracle directory under /u0:

cd /u0/oracle

4. To change to the parent directory:

cd ..

5. To rename file1 to file2:

mv file1 file2

6. To remove a file:

rm filename.ext

7. To remove a directory, together with subdirectories:

rm –r directory

8. To get disk space free for all mounted file systems:

df -h

9. To change permissions on a file:

chmod 777 filename.ext

10. To change ownership of a file to applmgr and group dba (you may need to do this as root user):

chown applmgr:dba filename.ext

11. To create a symbolic link name /usr/bin/java to file /usr/local/jdk1.3.1_19 /bin/java

ln –s /usr/local/jdk1.3.1_19/bin/java /usr/bin/java

12. To tar all files in directory (to create one file contains all files in the directory):

tar cvf * filename.tar

13. To untar all files in directory:

tar xvf * filename.tar

Excel Not Launching Properly from Web ADI

Posted by on December 1, 2006 No comments

Problem: When Web ADI launches Microsoft Excel, the output Excel spreadsheet does not run.

Solution: This problem seems to be occurring only in Microsoft Excel 2003. In Excel 2003, Enable Trust VB Projects.

Step 1:        After launching Excel 2003, navigate to Tools > Options.

Step 2:        Click the Security tab.

Step 3:        Click the Macro Security button.

Step 4:        Click the Trusted Publishers tab.

Step 5:        Ensure that Trust access to Visual Basic project is checked.

Step 6:        Click OK to exit the option. Click OK again.

Refer to Metalink Doc ID:  Note: 106528.1 (Subject:  Application Desktop Integrator – Product Documentation)

Refer to Metalink Doc ID:  Note: 376976.1 (Subject:  WEB ADI “Run-Time Error ‘50290’ Method ‘Run’ Of Object ‘_application Failed”)

Refer to Metalink Doc ID:  Note: 295901.1 (Subject:  No Excel File Created When Using Excel 2002; Excel 2002 Does Not Appear In Viewers LOV)

See also http://support.microsoft.com/default.aspx?scid=kb;en-us;282033

Recreating DBC file

Posted by on November 22, 2006 No comments

Problem: While installing vision instance, the post-install check “JSP Check” fails with the message “DBC file may be invalid”.

Solution: Recreate DBC file.

Note: Run these commands from $FND_TOP/secure. Also, source environment file first.

To create a DBC file and server ID:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=vis SECURE_PATH=%FND_TOP%secure GUEST_USER_PWD=guest/guest APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=eam.clientnetwork.com DB_PORT=1522

To check status:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis STATUS DB_HOST=eam.clientnetwork.com DB_PORT=1522

To delete DBC file:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis DELETE DB_HOST=eam.clientnetwork.com DB_PORT=1522

Also, you can run adgendbc.sh, located in $COMMON_TOP/admin/install/

For Database Connectivity problems, ensure that the hosts file is set up properly:

127.0.0.1 localhost.localdomain localhost
hostname.domainname hostname

On Windows, use java. On Linux/Unix, use JRE.

Reference:
Metalink Doc ID: 108865.1 (How To Create a Database Connection(DBC) File and Troubleshooting Common Problems)

Configuring Sign-On Audit Level

Posted by on November 22, 2006 No comments

Problem: Signon Audit Users report does not show any data.

Solution: Change System Profile “Sign-On: Audit Level” value User or Responsi­bility.

Step 1:        Log on as user Sysadmin and navigate to Profile > System.

Step 2:        Query “Sign%”.

Step 3:        Change value of “Sign-On: Audit Level” to “FORM” at the Site level.

Step 4:        Change value of “Sign-On: Notification” to blank at the Site level.

There Are No Applications Available For This Responsibility Message While Selecting Any Responsibility.

Posted by on November 15, 2006 No comments

Problem: After logging on to Oracle Applications, the message appears, “There are no applications available for this responsibility. Please click on a different responsibility link to display the list of available applications.”

Solution: Disable maintenance mode and bounce the Apache server.

Step 1:        Disable the Maintenance mode by setting the site-level value of APPS_MAINTENANCE_MODE profile option NORMAL. Or Use the AD Administration Utility to set Maintenance Mode in 11.5.10.

Step 2:        Bounce the Apache Web server. Adapcctl.sh

Refer to Metalink Note:287116.1 (Subject:  There Are No Applications Available For This Responsibility Message While Selecting Any Responsibility)