Category Archives: Windows - Page 20

Importing Supplier Data

Posted by on October 3, 2006 No comments

We had some problems with loading the data because one of the fields, address_line3 was omitted from the data file. Verify the data file against the control file.

You must log on to the correct responsibility in order to import the data.

Company Org_id
Company A 123
Company B 141
Company C 142

After the data is loaded, two concurrent programs must be run to import the data:

  1. Supplier Open Interface Import
  2. Supplier Sites Open Interface Import

Data is loaded into:

  1. AP_SUPPLIERS_INT
  2. AP_SUPPLIER_SITES_INT

Data is imported into:

  1. PO.PO_VENDORS
  2. PO.PO_VENDOR_SITES_ALL

Change VENDOR_SITE_CODE to ‘PRIMARY’.

For manual entry of vendor numbers, change the settings in the application and populate the SEGMENT1 field.

Valid TERMS_DATE: ‘Net 30 Days’

VENDOR_INTERFACE_ID must be in both tables. Insert it into the data file if necessary.

Restoring Missing “Show Desktop” Icon

Posted by on September 18, 2006 No comments

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:

[Shell]

Command=2

IconFile=explorer.exe,3

[Taskbar]

Command=ToggleDesktop

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

Posted by on September 15, 2006 No comments

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.

Deleting Oracle Services

Posted by on September 5, 2006 No comments

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.

Reboot.

See also: http://www.mvps.org/winhelp2002/services.htm

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

Installing Web ADI

Posted by on August 30, 2006 No comments

This documentation covers how to install Web ADI. To download Web ADI, refer to Metalink Doc ID: 230801.1.

Step 1:        Log on to Metalink and click on the Patches & Updates.

Step 2:        Click on Advanced Search.

Step 3:        Search by Product of Product Family for ‘Web’. ‘Web Applications Desktop Integrator (bne)’ appears.

Step 4:        View readme of the latest BNE patchset (11i.BNE.D). See also Note ID 287080.1.

Step 5:        The latest patchset is 3218526, about 8.4MB. Download it.

Backup Strategy Notes

Posted by on August 14, 2006 No comments

This documentation covers a general backup strategy for the client.

Since a lot of work is being done on the Test instance, it is important that the server housing this instance be backed up on a regular basis.

Backup Media

There are several types of backup media available. For example, CD-ROMs, DVD-ROMs, secondary hard drives etc. CD-ROMs and DVD-ROMs do not possess the required capacity. Secondary hard drives are likely to fail. For example, if a power spike caused the server hard drives to fail, it may also cause the secondary hard drives to fail.

The best medium for backing up servers is tape media. The tape must be capable of backing up the database and related Oracle Application files, as well as the public folder. Storage requirements for these will grow as the project progresses, and this must be taken into consideration. A rough estimate of the tape capacity is about 200GB. This will easily back up the entire server.

Dell sells LTO tape drives (PowerVault 110T LTO Tape Drive) with some of their servers; perhaps this can be used as a starting point for research on tape drives.

Backup Software

There are several commercial backup and recovery solutions available, such as BrightStor ARCserve. ARCserve handles all aspects of job creation, scheduling and recovery from an intuitive GUI. In addition, ARCserve is certified by Microsoft on all of its server platforms.

Windows also comes with it’s own backup software, NT Backup. NT Backup provides much of the basic functionality as ARCserve. However, NT Backup is designed to be a more interactive solution, that is, an operator has to manually choose the files and directories to back up, and then start the backup.

Ideally, the backup should be automated so that an operator does not have to manually start the backup, and the backup can be scheduled in the middle of the night (say 10 o’clock).

NT Backup can be called from the command line with parameters, so the NT Backup command can be placed into a Windows Command Script (with a .cmd extension), which can then be scheduled. However, this method must be diligently tested to ensure that the scheduled backups are going through.

To view the syntax for NTBackup command line parameters, type ‘ntbackup /?’ at the command prompt:

C:> ntbackup /?

NT Backup loads, then the help file appears with the command-line reference.

To use NT Backup, a ‘selection’ of directories to back up has to be created and saved so that it can be referenced on the command line.

Directories to Backup

At the very least, the directories that should be backed up on oracleserver are

  • D:PROD
  • D:PROJECT FOLDER

However, if all directories on all of the drives can be backed up, it would be even better.

Regardless of the backup software used, the backup made should be tested on a regular basis. There should be a separate machine, which can be used to test different disaster recovery scenarios.

Adding New User

Posted by on August 14, 2006 No comments

Go to Control Panel > Administrative Tools > Computer Management.

Click Action, and then click New User.

Enter the new user and password.

Navigate to Control Panel > User Accounts to change the group membership.

Removing Banner Page from Reports

Posted by on August 10, 2006 No comments

Problem: The Customer Statements report prints a banner page.

Solution: On Vision, log on as user operations and access the Receivables, Vision responsibility. From the menu, access Print Documents > Statements.

Refer to Doc ID:  Note:99687.1 (Subject:  Printing Character Reports with Oracle Applications Release 11)

For the Printer Style MFGL_LANDSCAPE, enable the Suppress Header checkbox for the \oracleserverHPLaser printer.

From Concurrent Programs from the System Administrator responsibility, change the Print Statement program. Change Style to Landscape_mfgl and Printer to \oracleserverHPLaser.

Subject:  FAQ (Application Reports)

Doc ID:  Note:105105.1

Subject:  Printing Character Reports with Oracle Applications Release 11

Doc ID:  Note:99687.1

Subject:  How to Remove The Banner Page From Printing On Reports

Doc ID:  Note:163973.1

Subject:  How to Suppress Banner Page when Printing Reports

Doc ID:  Note:1038798.6 (No help)

Subject:  How to Suppress the Header/Banner Page When Printing Report on AIX?

Doc ID:  Note:302847.1 (No help)

Loading Data Into GL Interface

Posted by on August 10, 2006 No comments

This documentation shows the user how to load data for GL Interface.

Step 1:        The data file provided by the analyst can either be a .CSV file or a .DAT file.

Step 2:        Rename the data file to a name without spaces e.g. datafilename.dat.

Step 3:        Copy the data file to the project folder, into folder GLDataLoadElvis.

Step 4:        Load on to oracleserver (128.1.2.213) via VNC.

Step 5:        Load Command Prompt.

Step 6:        Change to D:PRODprodappl. Run APPSORA.cmd.

Step 7:        Change to folder D:PROJECT FOLDERGLDataLoadElvis

Step 8:        At the Command Prompt, run SQL Loader:

sqlldr80 apps/apps control=elvis.ctl data=datafilename.dat

Step 9:        If only about 50-60 lines load, the data was incorrect (the load process fails after 50 lines have failed). Check the log file elvis.log for more information.

Troubleshooting Launching Oracle Applications

Posted by on August 10, 2006 No comments

Problem: Unable to get application to launch.

Solution: Try the following:

Step 1:        Check the hosts file (either /etc/hosts or C:WINDOWSSYSTEM32 DRIVERSETCHOSTS) and ensure that the IP address and host is in the file.

Step 2:        Ensure that the local addresses are bypassed in the browser.

Step 3:        Ensure that the instance is started on the server.