Problem:
After applying patch 9239090 (ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK), DataInstall must be run. However, after sourcing the environment and running the DataInstall command, the following error appears:
java.lang.ClassNotFoundException: oracle.apps.per.DataInstall
Solution:
Source the application tier environment (not the database tier environment) and then run DataInstall.
Problem:
While running patch 9239090, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file OKLTXRBKUG.sql on worker 1. FAILED: file OKLTXRBKUG.sql on worker 2. FAILED: file OKLTXRBKUG.sql on worker 3. FAILED: file OKLTXRBKUG.sql on worker 4. FAILED: file OKLTXRBKUG.sql on worker 5. FAILED: file OKLTXRBKUG.sql on worker 6. FAILED: file OKLTXRBKUG.sql on worker 7. FAILED: file OKLTXRBKUG.sql on worker 8. FAILED: file OKLTXRBKUG.sql on worker 9. FAILED: file OKLTXRBKUG.sql on worker 10. FAILED: file OKLTXRBKUG.sql on worker 11. FAILED: file OKLTXRBKUG.sql on worker 12. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Solution:
The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus and ran the following commands:
alter package APPS.OKL_TXL_ASSETS_PVT compile;
alter package APPS.OKL_TXL_ASSETS_PVT compile body;
alter package APPS.OKL_TXL_ASSETS_PUB compile;
alter package APPS.OKL_TXL_ASSETS_PUB compile body;
alter package APPS.OKL_SPLIT_ASSET_PVT compile;
alter package APPS.OKL_SPLIT_ASSET_PVT compile body;
alter package APPS.OKL_SECURITIZATION_PVT compile;
alter package APPS.OKL_SECURITIZATION_PVT compile body;
alter package APPS.OKL_TRANSACTION_PVT compile;
alter package APPS.OKL_TRANSACTION_PVT compile body;
OKL_TRANSACTION_PVT now compiles without issue.
To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:
select count(*) from dba_objects where status = ‘INVALID’;
Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.
Problem:
When rerunning patch 9239090, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file mth_pre_upgrade.sql on worker 1. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked worker log file:
C:oracleTEST1appsapps_stappladminTEST1logadwork001.log
The following errors appeared:
Time when worker started job: Mon Jan 30 2012 09:42:06 Start time for file is: Mon Jan 30 2012 09:42:06 sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql Error: Program exited with status 1 Cause: The program terminated, returning status code 1. Action: Check your installation manual for the meaning of this code on this operating system.DECLARE * ERROR at line 1: ORA-00955: name is already used by an existing object ORA-06512: at line 59 Time when worker failed: Mon Jan 30 2012 09:42:06 Time when worker started job: Mon Jan 30 2012 09:42:06 Start time for file is: Mon Jan 30 2012 09:42:06 sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql Error: Program exited with status 1 Cause: The program terminated, returning status code 1. Action: Check your installation manual for the meaning of this code on this operating system.DECLARE * ERROR at line 1: ORA-00955: name is already used by an existing object ORA-06512: at line 59 Time when worker failed: Mon Jan 30 2012 09:42:06
Solution:
1. Edit C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql and uncomment SQL code for Exception. Then restart worker (did not try this solution).
2. Use adctrl (option 8) to skip and restart this step (tried this solution).
Reference:
https://forums.oracle.com/forums/thread.jspa?messageID=9224027
[amazon asin=0070077290&template=iframe image&chan=default] [amazon asin=1453742735&template=iframe image&chan=default] [amazon asin=0615238440&template=iframe image&chan=default]
Problem:
When running Rapid Install, the following error appears:
RW-50004: Error code received when running external process. Check log file for details. Running Database Install Driver for TEST1 instance
In the ‘Rapid Install base window – do not close’ window, the following appears:
Configuration file written to: C:oracleTEST1instappsTEST1_ittl-hrmstestconf_TEST1.txt Configuration file written to: C:oracleTEST1dbtech_st11.1.0appsutilconf_TEST1.txt Database logfile - C:oracleTEST1dbtech_st11.1.0appsutillogTEST1_ittl-hrmstest1260950.log uploadConfig() : Exception : TDU
Rapid Wizard completes with the following error:
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.
The log file C:oracleTEST1dbtech_st11.1.0appsutillogTEST1_ittl-hrmstest1260950.log showed the following:
RW-50010: Error: - script has returned an error: 1 RW-50004: Error code received when running external process
Solution:
Change the NUMBER_OF_PROCESSORS environment variable from 16 to 12 and restart installation.
How To Check MD5Sums for R12 Staging CDs on Windows
Problem:
How do I check the MD5 checksums for R12 Staging CDs?
Solution:
In MOS document “MD5 Checksums for R12.1.1 Rapid Install Media” [ID 802195.1], download the checksum file for your platform (e.g. Windows). Then execute the following command:
md5sum --check md5sum_Windows.txt > md5sum_result.txt
Note that the md5sum command comes bundled with Cygwin. If the output from the above command shows that all lines contain the word ‘FAIL’, try converting the text file to UNIX format:
dos2unix md5sum_Windows.txt
The above command removes trailing carriage return characters from the end of the lines.
After this, retry the md5sum command.
How to Remove an Oracle E-Business Suite Release 12.x Windows Environment
The procedure described in this document (Note 567507.1 on Oracle Metalink) lists the steps you must take to remove an E-Business Suite R12 environment or environments from a Windows system.
Step 1. Back up the System and Windows Registry
Refer to Microsoft Article ID 326216: How to use the backup feature to back up and restore data in Windows Server 2003
Step 2. Alter the Windows Registry
Delete the relevant Oracle components from the Windows registry, as follows.
To delete all Oracle environments on the system:
* Launch the Registry Editor.
* Navigate to the HKEY_LOCAL_MACHINESoftware key.
* Select the Apache Group subkey and delete it.
* Select the Oracle subkey and delete it.
* Navigate to the HKEY_LOCAL_MACHINESystemCurrent Control SetServices.
* Carefully select and delete each service beginning with Oracle. For example, delete “OraclePROD_<nodename>_ToolsASControl”.
* When you are finished, exit the Registry Editor.
Step 3. Alter Environment Settings
Complete these steps to delete Oracle parameters from the environment.
Navigate to the Environment Variables editing screen according to your system setup. For example, right-click My Computer and select Properties. From the Advanced tab, click the Environment Variables button.
To remove all Oracle environments from the system:
Select the following system variable if created during the failed installation, and delete it: PERL5LIB.
Select the Path variable, but do not delete it. Carefully edit it and remove any component with “Oracle” in the name, or that otherwise references the failed install. For example, delete “e:oraclePRODdbtech_st10.2.0bin;”.
Save and exit System Properties.
Step 4. Clean up the Program Menu
Launch the Program menu (Start -> Programs). Delete all Oracle programs groups.
Step 5. Restart your Machine
Step 6. Delete the Oracle Filesystem
Step 7. Delete Programs and Oracle Inventory Entries
To delete the inventory associated with a specific instance:
* Start the Oracle Universal Installer using: Start >> All Programs >> Oracle-<SID>_db102_RDBMS>>Oracle Installation Products>>Universal Installer
* Select Installed Products
* Enable “Show empty homes”
Deinstall the entries in the global inventory associated with the Oracle Applications R12 instance which you removed earlier. For example, for the PROD instance, you would delete:
* * RDBMS ORACLE HOME (e.g. “PROD_DB__oracle_PROD_db_tech_st_10_2_0″)
* * 10gAS ORACLE HOME (e.g.”PROD_WEBOH__oracle_PROD_apps_tech_st_10_1_3”)
* * Developer 10g ORACLE HOME (for example, “PROD_TOOLS__oracle_PROD_apps_tech_st_10_1_2”)
* Exit the Universal Installer
To delete the files associated with all Oracle environments on the system:
* Open a command window and navigate to the C:Program Files directory.
* Delete the Oracle subdirectory.
* If your Oracle Inventory directory was not C:Program FilesOracleInventory and was therefore not deleted in the previous step, locate it and delete it.
Reference:
How to Remove an Oracle E-Business Suite Release 12.x Windows Environment [ID 567507.1]
OKSAUCVT.pll, OKSAUDET.pll, CSCUTILS.pll, OKCEXPOR.pll Not Generated Successfully
Problem:
Applying the R12.1.3 RUP patch to a R12.1.1 Vision instance on Windows Server 2003 Standard Edition Service Pack 2. After setting the _disable_fast_validate to TRUE in the initVIS12.ora file, and then bounced the 11g database. Restarted the R12.1.3 RUP patch (patch 9239090) from the beginning. The following error occurred while patching:
The following Oracle Forms objects did not generate successfully: 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 recompile the invalid libraries and then continue patch.
frmcmp module=%AU_TOP%/resource/OKSAUCVT.pll userid=APPS/APPS output_file=%AU_TOP%/resource/OKSAUCVT.plx module_type=library batch=no compile_all=special frmcmp module=%AU_TOP%/resource/OKSAUDET.pll userid=APPS/APPS output_file=%AU_TOP%/resource/OKSAUDET.plx module_type=library batch=no compile_all=special frmcmp module=%AU_TOP%/resource/CSCUTILS.pll userid=APPS/APPS output_file=%AU_TOP%/resource/CSCUTILS.plx module_type=library batch=no compile_all=special frmcmp module=%AU_TOP%/resource/OKCEXPOR.pll userid=APPS/APPS output_file=%AU_TOP%/resource/OKCEXPOR.plx module_type=library batch=no compile_all=special
Compilation errors on CSC_PLAN_OUTCOMES: PL/SQL ERROR 0 at line 18, column 17 Item ignored PL/SQL ERROR 320 at line 73, column 41 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 67, column 3 Statement ignored PL/SQL ERROR 320 at line 79, column 9 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 79, column 4 Statement ignored Failed to generate library. FRM-30312: Failed to compile the library. FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/CSCUTILS.err Compilation errors on LAUNCH: PL/SQL ERROR 905 at line 2194, column 3 object APPS.OKS_COPY_CONTRACT_PVT is invalid PL/SQL ERROR 0 at line 2194, column 3 Statement ignored Failed to generate library. FRM-30312: Failed to compile the library. FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/OKCEXPOR.err Compilation errors on OKSAUDET_ACTIONS: PL/SQL ERROR 905 at line 287, column 4 object APPS.OKS_COPY_CONTRACT_PVT is invalid PL/SQL ERROR 0 at line 287, column 4 Statement ignored Compilation errors on OKS$CONTRACT_LINE: PL/SQL ERROR 0 at line 402, column 30 Item ignored PL/SQL ERROR 0 at line 426, column 8 Statement ignored Failed to generate library. FRM-30312: Failed to compile the library. FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/OKSAUDET.err Compilation errors on OKSAUCVT_MAIN: PL/SQL ERROR 0 at line 1029, column 10 Statement ignored PL/SQL ERROR 0 at line 1034, column 11 Statement ignored PL/SQL ERROR 0 at line 1901, column 33 Item ignored PL/SQL ERROR 320 at line 1907, column 12 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 1907, column 12 Statement ignored PL/SQL ERROR 320 at line 1908, column 12 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 1908, column 12 Statement ignored PL/SQL ERROR 320 at line 1909, column 12 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 1909, column 12 Statement ignored PL/SQL ERROR 320 at line 1910, column 12 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 1910, column 12 Statement ignored PL/SQL ERROR 320 at line 1911, column 12 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 1911, column 12 Statement ignored PL/SQL ERROR 320 at line 1919, column 49 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 1913, column 6 Statement ignored Compilation errors on OKSAUCVT_COV_TIMES: PL/SQL ERROR 0 at line 337, column 26 Item ignored PL/SQL ERROR 320 at line 377, column 56 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 376, column 1 Statement ignored PL/SQL ERROR 320 at line 381, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 381, column 1 Statement ignored PL/SQL ERROR 320 at line 385, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 385, column 1 Statement ignored PL/SQL ERROR 320 at line 389, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 389, column 1 Statement ignored PL/SQL ERROR 320 at line 393, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 393, column 1 Statement ignored PL/SQL ERROR 320 at line 397, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 397, column 1 Statement ignored PL/SQL ERROR 320 at line 400, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 400, column 1 Statement ignored PL/SQL ERROR 320 at line 403, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 403, column 1 Statement ignored Compilation errors on OKSAUCVT_COPY_COVERAGE: PL/SQL ERROR 0 at line 37, column 4 Statement ignored Compilation errors on OKSAUCVT_BILLING_RATES_REG: PL/SQL ERROR 0 at line 651, column 26 Item ignored PL/SQL ERROR 320 at line 695, column 69 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 693, column 1 Statement ignored PL/SQL ERROR 320 at line 703, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 703, column 1 Statement ignored PL/SQL ERROR 320 at line 706, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 706, column 1 Statement ignored PL/SQL ERROR 320 at line 709, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 709, column 1 Statement ignored PL/SQL ERROR 320 at line 712, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 712, column 1 Statement ignored PL/SQL ERROR 320 at line 715, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 715, column 1 Statement ignored PL/SQL ERROR 320 at line 718, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 718, column 1 Statement ignored PL/SQL ERROR 320 at line 721, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 721, column 1 Statement ignored PL/SQL ERROR 0 at line 910, column 26 Item ignored PL/SQL ERROR 320 at line 940, column 69 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 938, column 1 Statement ignored PL/SQL ERROR 320 at line 945, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 945, column 1 Statement ignored PL/SQL ERROR 320 at line 948, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 948, column 1 Statement ignored PL/SQL ERROR 320 at line 951, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 951, column 1 Statement ignored PL/SQL ERROR 320 at line 954, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 954, column 1 Statement ignored PL/SQL ERROR 320 at line 957, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 957, column 1 Statement ignored PL/SQL ERROR 320 at line 960, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 960, column 1 Statement ignored PL/SQL ERROR 320 at line 963, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 963, column 1 Statement ignored Compilation errors on OKSAUCVT_BILLING_RATES_H: PL/SQL ERROR 0 at line 646, column 26 Item ignored PL/SQL ERROR 320 at line 686, column 69 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 684, column 1 Statement ignored PL/SQL ERROR 320 at line 690, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 690, column 1 Statement ignored PL/SQL ERROR 320 at line 693, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 693, column 1 Statement ignored PL/SQL ERROR 320 at line 696, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 696, column 1 Statement ignored PL/SQL ERROR 320 at line 699, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 699, column 1 Statement ignored PL/SQL ERROR 320 at line 702, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 702, column 1 Statement ignored PL/SQL ERROR 320 at line 705, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 705, column 1 Statement ignored PL/SQL ERROR 320 at line 708, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 708, column 1 Statement ignored PL/SQL ERROR 0 at line 885, column 26 Item ignored PL/SQL ERROR 320 at line 915, column 69 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 913, column 1 Statement ignored PL/SQL ERROR 320 at line 920, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 920, column 1 Statement ignored PL/SQL ERROR 320 at line 923, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 923, column 1 Statement ignored PL/SQL ERROR 320 at line 926, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 926, column 1 Statement ignored PL/SQL ERROR 320 at line 929, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 929, column 1 Statement ignored PL/SQL ERROR 320 at line 932, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 932, column 1 Statement ignored PL/SQL ERROR 320 at line 935, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 935, column 1 Statement ignored PL/SQL ERROR 320 at line 938, column 4 the declaration of the type of this expression is incomplete or malformed PL/SQL ERROR 0 at line 938, column 1 Statement ignored Failed to generate library. FRM-30312: Failed to compile the library. FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/OKSAUCVT.err
Note that when these four libraries were manually compiled, they still returned errors. Nevertheless, the patch was continued by entering Yes at the prompt.
Unable to compile WSH_FTE_TP_INTEGRATION, WSH_TRIP_STOPS_GRP Package Bodies
Problem:
While running patch 9239090 (R12.1.3 RUP) on Windows, the following Oracle Forms objects did not generate successfully:
wsh forms/US WSHQSSUI.fmx wsh forms/US WSHSTREF.fmx wsh forms/US WSHFSTRX.fmx
To resolve this, the invalid WSH packages were identified and compiled. However, while compiling the invalid WSH package bodies, compilation errors resulted.
Solution: Flush the shared pool before compiling the package bodies.
Problem:
What Microsoft Visual Studio 2005 products were installed to be used with E-Business Suite R12.1 on Windows?
Solution:
The following products were installed from Microsoft Visual Studio 2005:
1. Under Language Tools:
Visual C++:
Smart Device Programmability [probably not needed]
Visual C++ Tools
Visual C++ Run-Time Libraries
Visual C++ Class & Template Libraries
2. Under .NET Framework SDK:
Tools
Microsoft Visual Studio 2005 was installed to D:MSVS.
D:MSVSVC was the path used while installing E-Business Suite R12.1
D:MSVSVCbin was added to the PATH environment variable after D:cygwinbin (although the R12 installation guide did not state that it should be added).
Problem:
After installing E-Business Suite R12.1.3 on Windows Server 2003 Standard Edition, logged into R12 on the server and launched forms.
The following error appeared:
FRM-92050: Failed to connect to the Server: /forms/lservlet: -1
Solution:
The security settings on the Internet Explorer browser on Windows Server 2003 is set higher by default.
Added the name of the server to the Local Intranet group in IE’s security settings.
Reset Local Intranet security level to Medium-Low.
Reference:
Error – FRM-92050 java.io.IOException: Negative content-length Unable to Launch Forms Successfully [ID 1248215.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]
Recent Comments