Loading...

Follow Oracle Solutions on Feedspot


Valid
or
Continue with Google
Continue with Facebook

ERROR

ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called:
“APPS.AP_ACCTG_DATA_FIX_PKG”
ORA-06512: at line 38

When trying to compile “APPS.AP_ACCTG_DATA_FIX_PKG”, following errors are shown:

AP_ACCTG_DATA_FIX_PKG PLS-00394: wrong number of values in the INTO list of a FETCH statement

SOLUTION

STEP 1.

Download and review the readme and pre-requisites for Patch 11772495:R12.AP.B (to fix the package apacpayb.pls) and Patch.12582979:R12.AP.B (to upgrade the version of apgdfalb.pls).

STEP 2.  Ensure that you have taken a backup of your system before applying  the recommended patch. 

STEP 3.  Apply the patch in a test environment. 

STEP 4.  Confirm the following file versions:

ap patch/115/sql apacpayb.pls 120.12.12010000.28
ap patch/115/sql apacpays.pls 120.6.12010000.10 
ap patch/115/sql apgdfalb.pls 120.1.12010000.39 
ap patch/115/sql apgdfals.pls 120.1.12010000.13

Use the Below command like the following: 

strings -a $XX_TOP/filename |grep ‘$Header’ 

STEP 5. Check if the AP_ACCTG_DATA_FIX_PKG is now valid and retest running the script.

STEP 6.  Migrate the solution as appropriate to other environments.

The post ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

How to clean FND_NODES table in Oracle Applications
Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity.
Step 1: Login to Database with Apps User

$ sqlplus apps/apps

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

SQL>COMMIT;

SQL>EXIT;

It will delete all old data from the table.

Step 2: Run AutoConfig on all tiers, first on the DataBase Tier and then on APPS Tier to repopulate the required system tables.

The post How to clean FND_NODES table in Oracle Applications appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

How to Get Apps Password From Backend STEP 1.  First login to Database through Command Prompt

sqlplus / as sysdba

STEP 2 : Create Function From Below Script to decrypt the encrypted password

create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,
in_chr_encrypted_pin IN VARCHAR2)  
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;

STEP 3 : Run the Below Query for Retrieving AppsPassword

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873
AB2FFFA3B302AEE6EBD1

STEP 4:  Run the Below Query to get the Password

SELECT apps.decrypt_pin_func(‘GUEST/ORACLE123′,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1’) from dual;

APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1′)
——————————————————————————–
APPS

STEP 5:  Now Login With the Password Retrieved.

SQL> conn apps/APPS;
Connected.

The post How to Get Apps Password From Backend appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

ERROR

The Concurrent Manager fails to start with the Error:

The ICM is already running. Contact you system administrator for further assistance.

A fpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock.

Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.

Possible DBMS_LOCK.Request resultCall to establish_icm failed.

The Internal Concurrent Manager has encountered an error.

SOLUTION

This Error Normally occurs due to database Lock.

Step 1. Stop all services and concurrent managers

Step 2. Stop and restart the database

Step 3. Restart the services and concurrent managers

Step 4. Verify if the issue remains

Reference: Oracle Note (Doc ID 245563.1)

The post Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

ERROR

<Error> <Store> <BEA-280061><The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException:
[Store:280105]The persistent file store “_WLS_AdminServer” cannot open file _WLS_ADMINSERVER000000.DAT.

SOLUTION

These  files has to be cleared from $DOMIAN_HOME/servers/(server_name)

find . -name ‘*.DAT’ -print -exec rm {} \;

find . -name ‘*.lok’ -print -exec rm {} \;

For Admin server

$DOMAIN_HOME/servers/<server name>/tmp/Adminserver.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/store/default/_WLS_ADMINSERVER000000.DAT
$DOMAIN_HOME/servers/<server name>/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT

For Managed servers

$DOMAIN_HOME/servers/<server name>/tmp/<servername>.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/store/default/_WLS_<servername>000000.DAT
$DOMAIN_HOME/servers/<server name>/data/ldap/store/diagnostics/WLS_DIAGNOSTICS000000.DAT

The post The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Enabling About This Page Link in Oracle Apps R12

If You need to Enable About This Page Link in Oracle Apps, you need to set the following Profile Options from System Administrator Responsibility

  • Personalize Self-Service Defn = YES
  • FND: Personalization Region Link Enabled = YES
  • Disable Self-Service Personal = NO (Only at Site)
  • FND: Diagnostics = Yes
Note: These Profile Options can be set on Site Level or User Level.

The post Enabling About This Page Link in Oracle Apps R12 appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
How to View Concurrent Request Output on Browser Step 1. Go To System Administrator Responsibility select Profile>System

Step 2. Search the Profile option ‘Viewer:%’ 

Step 3. Set the profile Viewer: Application for Text to Browser at Site Level.

The post How to View Concurrent Request Output on Browser appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

SOLUTION Step 1. Connect To SYS user from SqlPlus Step 2. Take Backup of FND_STATTAB  Table. Step 3. Run EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(‘APPLSYS’,’FND_STATTAB’);

The post ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

ERROR

ORA-12899: value too large for column “APPLSYS”.”FND_PROFILE_OPTION_VALUES”.”PROFILE_OPTION_VALUE”

SOLUTION

 Please execute the following steps:

Step 1 – Change the value dbutilfiledir in the database context file

($ORACLE_HOME/appsutil/$CONTEXT_NAME.xml) 

Step 2Run autoconfig again.

The post ORA-12899: value too large for column “APPLSYS”.”FND_PROFILE_OPTION_VALUES”.”PROFILE_OPTION_VALUE” appeared first on .

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Useful Commands For Unix Operating System 1.Deleting files older than N number of days ?

find . -name ‘*.trc’ -mtime +[N in days]  -exec rm {} \;  
Command will delete files older then N days in that directory

2.Copying file keeping timestamp preserve

cp -ip file.txt file_txt_bkp

3.Listing files modified in last N days

find . -mtime -<ndays> -exec ls -lt {} \;

4.Sorting files based on Size of file ? 

ls -l | sort -nrk 5  | more
du -sm *|sort -nr|head -10 

5.Finding CPU & Memory detail 

->cat /proc/cpuinfo  (CPU)
->cat /proc/meminfo (Memory)
->topas

6.Finding if any service is listening on particular port or not ?

netstat -an | grep {port no}  

7.Finding Process ID (PID) associated with any port ?

lsof | grep {port no.}  
lsof should be installed and in path.Many times it will be installed eith root user.Make sure you have that permission

9.Finding a pattern in some file in a directory ?

grep pattern  file_name  ( find pattern in particular file )
grep -i pattern  file_name (find pattern ignoring the case)

10.Create symbolic link to a file ?

ln -s  pointing_to_original_file  symbolic_link_name

example
 ln -s /home/text.txt test.txt

11.History of command executed in UNIX 

fc -l 
fc -e – ls ( Would execute the last ls command.) 
History command will also do the same
history

12. Compressing a big file

zip -r new.zip new
or
compress file_name

13.Creating a tar file

tar -cvwf file.tar file.txt

14.Extracting the files from a tar file

tar -xvwf myfile.tar(System would unarchive (untar) the myfile.tar file into the current directory.)
tar -xvwzf myfile.tar.gz(System would unarchive (untar) the myfile.tar.gz file in the current directory.)

14.Extracting a gz file?

Use guzip command as follows:
gunzip file.gz
OR
gzip -d file.gz

15.Extract a tar.gz or .tgz file?

Files with extension tar.gz or .tgz are tar files compressed with gzip. On Unix system extract them with following command:
gunzip < file.tar.gz | tar xvf –
gunzip < file.tgz | tar xvf –

If you have GNU tar (Linux system) you can use the z option directly:
tar xvzf file.tar.gz
tar xvzf file.tgz

16.Using mailx command

echo “This is going to be body of the mail” |mailx -s “Subject:Testing” “false@gmail.com”

17.Checking the file system free and used space

df -gt 

The post Useful Commands For Unix Operating System appeared first on .

Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview