Category Archives: R12 - Page 9

Oracle Forms objects not generating in Patch 9239090 (R12.1.3 RUP)

Problem: While running R12.1.3 patch (9239090), the following error appears:

The following Oracle Forms objects did not generate successfully:

au      resource        OKEKAULN.pll
au      resource        OKLCSASD.pll
au      resource        OKSAUCVT.pll
au      resource        OKSAUDET.pll
au      resource        CSCUTILS.pll
au      resource        OKCEXPOR.pll

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No] :

Solution:

Manually regenerate the forms, and then continue patch 9239090.

Read more »

admsi.pl Not Running on Windows

Problem:

After sourcing the apps environment and running admsi.pl from Command Prompt, admsi.pl opens in Notepad instead of launching the Java forms patch wizard.

Solution:

Set the DISPLAY parameter and run the script from Perl.

D:patches9239089>which admsi.pl
/cygdrive/g/oracle/VIS12/apps/apps_st/appl/ad/12.0.0/bin/admsi.pl

D:patches9239089>%AD_TOP%binadmsi.pl

D:patches9239089>perl %AD_TOP%binadmsi.pl
Invoking Oracle Patch Application Assistant....
Please set the DISPLAY variable and re-run this script

D:patches9239089>echo $DISPLAY
$DISPLAY

D:patches9239089>echo %DISPLAY%
%DISPLAY%

D:patches9239089>set DISPLAY=.0:0

D:patches9239089>perl %AD_TOP%binadmsi.pl
Invoking Oracle Patch Application Assistant....

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

Problem:

While installing R12.1 Vision instance, the following error occurs:

RW-50004: Error code received when running external process. Check log file for details.
Running Database Install Driver for VIS12 instance

The errors occurs when Oracle Universal Installer runs. OUI displays a brief message, then the error appears.

Solution:

Did not clean up the Oracle Inventory directory correctly before reinstallation. Clean up Windows installation, then restart installation.
Read more »

cl.exe – Unable To Locate Component

Problem:

After installing Microsoft Visual Studio 2005, placed the bin directory (D:MSVSVCbin) in the PATH environment variable. Then ran cl.exe. The following message appeared:

cl.exe - Unable To Locate Component
This application has failed to start because mspdb80.dll was not found. 
Re-installing the application may fix this problem.

Solution:

Search for the following files:

msobj80.dll
mspdb80.dll
mspdbcore.dll
mspdbsrv.exe

They are under D:MSVSCommon7IDE.

Copy and paste them to the folder containing “cl.exe” (D:MSVSVCbin).

Reference:

http://connect.microsoft.com/VisualStudio/feedback/details/553848/mspdb80-dll-was-not-found

RW-50004: Error code received when running external process

Problem:

When installing an E-Business Suite R12 Vision instance, the following error appears:

RW-50004: Error code received when running external process. Check log file for details.
Running APPL_TOP Install Driver for VIS12 instance

Step 3 of 5
Command: G:oracleVIS12instappsVIS12_appswindows2tempadrunias.cmd
53%
Registering Applications Technology Stack
92%

Solution:

2. In $INST_TOP/temp/restart.xml, change line:

FROM:

<installprocess oa_var="s_rerunprocess">"runProcess_1"</installprocess>

TO:

<installprocess oa_var="s_rerunprocess">runProcess_1</installprocess>

Use restart option to retry the installation.

Read more »

RW-50004: Error code received when running external process

RW-50004: Error code received when running external process

Problem:

When installing R12 (Vision instance) on Windows Server 2003 Standard Edition, the following error occurs:

RW-50004: Error code received when running external process. Check log file for details.
Running APPL_TOP Install Driver for VIS12 instance

Solution:

Edit $INST_TOP/temp/restart.xml and change “runProcess_2” to runProcess_2.
Read more »

Installation Checklist for R12 on Windows 2003

Installation Checklist for R12 on Windows Server 2003 Standard Edition

Here are the steps I took while installing R12.1 Vision instance on Windows:

1. Install Windows Server 2003 Standard Edition on 30GB C: partition
2. Allocate static IP address for network connection and put entry into hosts file
3. Install Windows Server 2003 Service Pack 2
4. Apply additional downloaded Windows updates from Microsoft
5. Create D: drive for downloads and additional applications
6. Create F: drive for database (146GB)
7. Create G: drive for EBS applications (146GB)
8. Ran ScanDisk on D: and F: (taking very long)
9. Installed Microsoft Visual Studio 2005 to D:MSVS (installed XML and Visual C, disabled all other applications).
10. Install Visual Studio 2005 Service Pack 1 ATL Security Update [ID 761567.1]
11. Add D:MSVSVCbin to PATH environment variable (in My Computer > Properties)
12. Downloaded gnumake fro MOS (patch 5897842) and unzipped [ID 761567.1]
13. Installed Cygwin to D:cygwin (downloaded all packages to local disk D:cygwin-install, then installed all packages to D:cygwin). [ID 414992.1]
14. Copied make-3.81WinRelgnumake.exe to D:cygwinbin [ID 414992.1]
15. Add D:cygwinbin to PATH environment variable (in My Computer > Properties) [ID 414992.1]
16. In D:cygwinbin, renamed make.exe to _make.exe and copied gnumake.exe to make.exe
17. Rename Cygwin’s rmdir executable (rmdir.exe) to _rmdir.exe [ID 414992.1]
18. In D:cygwinbin, renamed link.exe to _link.exe [ID 761567.1]
19. Staged R12.1 CDs to D:StageR12
20. Downloaded latest StartCD R12.1.1 startCD – RAPID INSTALL STARTCD 12.1.1.13 (patch 11072566) [ID 798258.1]
21. In D:StageR12, renamed startCD to _startCD and unzipped patch 11072566 into this D:StageR12 to create new startCD
22. Opened Command Prompt and ran D:StageR12startCDDisk1rapidwizrapidwiz.cmd

Parameters

New Configuration: Create a new configuration
Port Pool Number: 12
Database Type: Vision Demo Database
Database SID: VIS12
Host Name: appswindows2
Domain Name: domainname.com
Operating System: Windows (32-bit)
Database OS User: Administrator
(Database Node) Base directory: F:oracleVIS12
Data Top (ARCHIVE): G:oracleVIS12dbapps_stdata
UNIX Toolkit directory: D:cygwinbin
Visual Studio directory: D:MSVSVC
(Applications Node) Base Directory: G:oracleVIS12
(Applications Node) Instance Directory: G:oracleVIS12inst

Errors

1. If you encounter the following error:

RW-50004: Error code received when running external process. Check log file for details.
 Running APPL_TOP Install Driver for VIS12 instance

Edit $INST_TOP/temp/restart.xml and change “runProcess_2” to runProcess_2. Remember to kill the running Oracle Universal Installer before clicking Retry.

2. FRM-92050: Failed to connect to the Server: /forms/lservlet:-1

3. In Step 1 of 5

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

 

Log Files

Configuration file written to: G:oracleVIS12instappsVIS12_appswindows2conf_VIS12.txt
Configuration file written to: F:oracleVIS12dbtech_st11.1.0appsutilconf_VIS12.txt

Configuration file written to: G:oracleVIS12instappsVIS12_appswindows2conf_VIS12.txt
Configuration file written to: F:oracleVIS12dbtech_st11.1.0appsutilconf_VIS12.txt
Database logfile – F:oracleVIS12dbtech_st11.1.0appsutillogVIS12_appswindows29121000.log
Appltop logfile – G:oracleVIS12instappsVIS12_appswindows2logs9121000.log
Appltop logfile – G:oracleVIS12instappsVIS12_appswindows2logs9121000.log

Reference

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Microsoft Windows Server (32-bit) [ID 761567.1]

Using Cygwin to Maintain Oracle E-Business Suite Release 12 on Windows [ID 414992.1]

Oracle Applications Documentation Resources, Release 12.1 [ID 790942.1]

How to Remove an Oracle E-Business Suite Release 12.x Windows Environment [ID 567507.1]

Function Not Available To This Responsibility

Problem: When examining an EBS form using Help > Diagnostics > Examine, the following error occurs:

Function Not Available To This Responsibility.
Change responsibilities or contact your System Administrator.

Solution: This is standard functionality. The EBS instance was upgraded to R12.1.3.

To allow access to the submenu items under the Help menu > Diagnostics, please perform the following steps:

Choose System Administrator, navigate to System > Profiles, and query the profile “Utilities : Diagnostics”. At the appropriate level (user/responsibility), change the value to Yes.

Logout and then login (you may need to bounce iAS (Apache) to clear cache).

Retest the issue.

Reference:

“Function Not Available To This Responsibility” After Upgrading To Release 12.1.3 [ID 1200743.1]

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

ORA-01400: cannot insert NULL into (“HR”.”PAY_ELE_TMPLT_CLASS_USAGES”.”CLASSIFICATION_ID”)

Problem: When running International HRMS Setup from the UK HRMS Super User responsibility, the following error occurs:

Inserting Balance Attribute Definition : ONLINE_SOE_BALANCE_ATTRIBUTE
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORA-01400: cannot insert NULL into ("HR"."PAY_ELE_TMPLT_CLASS_USAGES"."CLASSIFICATION_ID")

Solution: Ensure that the Human Resources product (PER) is licensed.

Read more »

R12 Diagnostics Notes

My Oracle Support Community is located at:

https://communities.oracle.com/portal/server.pt/community/support/219

My Oracle Support Community – Diagnostic Tools is located at:

https://communities.oracle.com/portal/server.pt/community/Diagnosibility/242

Overview of EBS Diagnostics Video:

https://support.oracle.com/CSP/main/article?cmd=show&type=ATT&id=232116.1:OVERVIEW&inline=1

How to run Oracle DBS Diagnostics:

Log on as a user with access to the Application Diagnostics responsibility. Then click:

Application Diagnostics > Diagnose > Select Application

Check checkbox to left of the test you wish to run.

Scroll to bottom of page and click Execute button.

Enter parameters, then click Submit.

Diagnostic Tests Catalog:

Release 12: MOS Doc ID: 421245.1

Other Diagnostics documents:
* Overview
* Installation Guide
* Frequently Asked Questions (FAQ)
* Training

Also My Oracle Support (MOS) Community