Category Archives: TCL

ORA-01403 Error on FF_DATABASE_ITEMS When Running Quickpay

Posted by on October 25, 2007 No comments

Ran QuickPay for user Joe; failed with error ORA-01403
Error was encountered when processing assignment USER-416
Error ORA-01403: no data found
has occurred in table ff_database_items at location 552
Cause:        an oracle error has occurred.  The failure was reported on table ff_database_items at location 552 with the error text ORA-01403: no dat

Checked Metalink, got article:

Subject:  ORA-01403 Error on FF_DATABASE_ITEMS When Running Quickpay
Doc ID:  Note:330791.1

Chose responsibility UK USD – HRMS Manager
Ran Bulk Compile Formula

Completed in error

See Metalink document:

Subject:  Payroll Failing with Ora-20001 Ora-06512: At “Apps.Pay_balance_pkg ORA-01006
Doc ID:  Note:428219.1

$FF_TOP/bin/FFXBCP apps/<apps password> 0 Y -U %% %%

APP-FF-34004: Oracle Payroll:HOUSE_RENT:1950/01/01 FAILED
APP-FF-33005: The local variable NET_PAY_ASG_RUN was used before being initialized

Cause:        The variable named in the error message is being used before any value has been assigned to it, so it has no meaningful value.

Action:        Please ensure variables have been assigned to before using them.

Subject:  PTO Formula Fails to Compile with Error APP-FF-33005
Doc ID:  Note:336157.1

Rerun HRGLOBAL with the global option (run DataInstall, choose 1I)

Bulk Compile Formula Command Line:

$FF_TOP/bin/FFXBCP apps/<apps password> 0 Y -U %% %%

Reduced number of formula instances to process from 159 to 47.

Ran QuickPay, completed successfully!!!

Ran Element Creation, completed successfully!!!

Ran Active Users report (Concurrent Manager), completed successfully!!!

ETA:

DataInstall set to Global

HRGLOBAL run, error with hrrbdeib.sql

DataInstall set to Global, UK HRMS, UK Payroll

HRGLOBAL run, error with hrrbdeib.sql

$FF_TOP/bin/FFXBCP apps/<apps password> 0 Y -U %% %%

HRGLOBAL run, error with hrrbdeib.sql

UTL_FILE Sample Code

Posted by on July 9, 2007 No comments

Here is some sample code using the UTL_FILE package:

DECLARE
  string1 VARCHAR2(32767);
  file1 UTL_FILE.FILE_TYPE;
BEGIN
--  file1 := UTL_FILE.FOPEN('TEMP_DIR','log_file_test','A'); -- open in append mode
  file1 := UTL_FILE.FOPEN('/usr/tmp','log_file_test','A'); -- open in append mode
  string1 := TO_CHAR(SYSDATE) || ' UTL_FILE test';
  UTL_FILE.PUT_LINE(file1, string1); -- write a string to the file
  UTL_FILE.FFLUSH(file1);
  UTL_FILE.FCLOSE_ALL; -- close all open files
END;
/

[amazon asin=0596514468&template=iframe image&chan=default]    [amazon asin=0137142838&template=iframe image&chan=default]    [amazon asin=0071614214&template=iframe image&chan=default]

Resolving Yellow Bar Issue

Posted by on July 4, 2007 No comments

Problem: When the Oracle Application BRAVO instance is loaded, the ‘yellow bar’ appears when the forms are loaded.

Solutions:

1. Refer to Metalink Doc ID: 162488.1, “Section 6: Troubleshooting and those Yellow Warning Bars”

Navigate to Start > All Programs > JInitiator Control Panel 1.1.8.16

Check “Show Java Console”

Exit and reload BRAVO instance.

Java Console shows no errors.

Try:

(a) Uninstall Jinitiator and clear browser cache

(b) Log back into Applications to get the new plugin, (oajinit.exe) including the new identitydb.obj

(c) Install the Jinitiator on the Client PC and then Log into the Oracle Applications to download the new signed JAR files

IE Tools > Internet Options > Security

Trusted > Custom Level

Download unsigned ActiveX controls: Prompt

Automatic Prompting for File Downloads: Enable

Had to copy jinit11816.exe manually off the server and install on client

Try:

1. Source the environment and recreate certificate:

adjkey -initialize

2. Repackage JInitiator:

adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe

3. Run adadmin and generate product jars (FORCE REGENERATION)

4. Then:

(a) Uninstall JInitiator, clear browser cache, and jcache

(b) Log back into Applications to get the new plugin, (oajinit.exe) including the new identitydb.obj

(c) Install the Jinitiator on the Client PC and then Log into the Oracle Applications to download the new signed JAR files

Rename C:Program FilesOracleidentitydb.obj

Then retry from step 4 above

Try:

1. Removed identitydb.obj from /home/applmgr

2.Source the environment and recreate certificate:

adjkey -initialize

3. Repackage JInitiator:

adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe

4. Run adadmin and generate product jars (FORCE REGENERATION)

5. Then:

(a) Cleared browser cache

(b) Removed files from C:Documents and SettingsjeffersonbOracle Jar Cache

Try:

1. Copied identitydb.obj.20070703 to identitydb.obj in /home/applmgr

2. Repackage JInitiator:

adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe

3. Run adadmin and generate product jars (FORCE REGENERATION)

4. Then:

(a) Cleared browser cache

(b) Removed files from C:Documents and SettingsjeffersonbOracle Jar Cache

(c) Launched Oracle Applications and loaded form

Solution 1:

Copied $OA_HTML/oajinit.exe off the server and onto the client machine.

Unzip oajinit.exe in a directory and run adjbuild/jinit11816.exe.

The following solution worked:

Refer to:

Subject:  How to use,create and /or update Digital Certificates for 11i Applications

Doc ID:   Note:365735.1

How to share Digital Certificate across multiple instances

———————————————————-

1. Copy Associated Files

+ Copy from alpha to bravo the following files respectively:

a. ADCERT.txt (certificate directive file)

$APPL_TOP/admin/out/adcert.txt

b. ADSIGN.txt (used to pass arguments to JRI for signing JAR files.)

$APPL_TOP/admin/adsign.txt

c. APPLTOP.cer (Certificate file that gets imported into the identitydb.obj)

$APPL_TOP/admin/appltop.cer

d. OAJINIT.exe (Repackaged Jinitiator executable that includes identitydb.obj)

$OA_HTML/oajinit.exe

Note: It will not be necessary to repackage your JInitiator file oajinit.exe if you copy it over.

e. IDENTITYDB.obj (Identity Database File used to sign JAR files on the server)

$HOME/identitydb.obj

DO NOT repackage Jinitiator.

2. Regenerate JAR files on bravo

+ Run ADADMIN to Regenerate (sign) the JAR files on each middle tier

a. Launch ADADMIN (Ensure you are APPLMGR with permissions to write to adadmin.log)

b. Choose option number 1 to Generate Files, then 5 to regenerate JAR Files making sure to enter ‘yes for force regeneration, which will resign every JAR file using the new digital certificate that you just copied over from the alpha instance.

In Summary:

Started to get yellow bar:
1. Deleted C:Program FilesOracleidentitydb.obj
2. Deleted Profile Oracle Cache
3. Uninstalled all JInitiators, verified by checking C:Program FilesOracle
4. Manually reinstalled JInitiator (oajinit.exe) from november instance – yellow bar still appearing on logon
5. Tried regenerating JAR files using adadmin – completed with error
6. Regenerated certificate using adjkey -initialize, then reran adadmin to regenerate JAR files – yellow bar still appearing on logon
7. Cleared browser cache and jcache – C:Program FilesOracleJInitiator 1.1.8.16jcache – yellow bar still appearing on logon
8. Manually copied identitydb.obj from /home/applmgr to  C:Program FilesOracle – WORKING

Failed to generate product JAR files in JAVA_TOP

Posted by on June 28, 2007 No comments

Problem: While applying patch 3218526, the following error occurs:

Failed to generate product JAR files in JAVA_TOP -
   /u02/bravo/bravocomn/java.

adogjf() Unable to generate jar files under JAVA_TOP

AutoPatch error:
Failed to generate the product JAR files

You should check the file
/u02/bravo/bravoappl/admin/bravo/log/adpatch_3218526_20070628a.log

for errors.

Solution:

Issue encountered while running this patch on BRAVO.

To resolve this issue, on the AP node (web tier):

1. Source the environment
2. Run:
adjkey -initialize
3. Run:
adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe
4. Run adadmin on both nodes and generate product jars

EBS Cloning Environment Variables

Posted by on June 7, 2007 No comments

Problem: What environment variables must be set before cloning, assuming no prior EBS environment file is present?

Solution:

Here is a sample script to source before running post-clone steps. It sets up the location to the PERL and Java executables. Note the directories must be changed to reflect your environment.

export PERL5LIB=/u01/deltaora/iAS/Apache/perl/lib/5.00503:
/u01/deltaora/iAS/Apache/perl/lib/site_perl/5.005:/u01/deltaappl/au/11.5.0/perl
export PATH=.:/u01/deltaora/iAS/Apache/perl/bin:/u01/deltacomn/util/jre/1.1.8/bin:$PATH
export LD_ASSUME_KERNEL=2.4.19

Running Oracle Report From Command Line

Posted by on June 5, 2007 No comments

Problem: How is an Oracle Report running from the command line?

Solution:

1. Source the appl_top environment file

2. ar60run report=/u0/thetaappl/fnd/11.5.0/reports/US/FNDSCARU.rdf batch=yes
destype=file desname=/u0/thetacomn/admin/out/theta_zetadb/otest_tcl_20070605a.out
desformat=/u0/thetaappl/fnd/11.5.0/reports/HPL printer=noprint pagesize=132x45

Oracle Applications Not Printing

Posted by on September 8, 2006 No comments

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

Posted by on September 8, 2006 No comments

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.