The issue reproduced when AutoInvoice is run in parallel by 2 different users and from 2 different machines in apps R12.1.3. IMPACT: Due to this issue, users cannot run autoinvoice…
Read MoreThe Below script useful to compile multiple .fmb files from single script. SCRIPT: vi fmcmp.sh #!/bin/bash . APPS_XXXX.env LOGFILE=/d01/backup/fmcmp_`date +%d%b%Y`.log function FCMD { j=”${i//.fmb}” cd $AU_TOP/forms/US frmcmp_batch userid=apps/XXXX module=$i output_file=$AR_TOP/forms/US/$j.fmx…
Read MoreProblem Description: In Apps R12.1.3 cloning perl adcfgclone.pl appsTier configuration successfully completed and all the services started except listener service. when starting listener service listener process exists with status 1.…
Read MoreApps listener fails to start on cloned R12.1.3 instance with the following error. Cause: This error occurs when a host names in the tcp.invited_nodes list is invalid Solution: Remove invalid…
Read MoreBelow message keeps repeating in Alert-log. Warning: VKTM detected a time drift. Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.…
Read Moreadbldxml.pl perl command used to re-create database tier context file. To re-create database tier context file follow the below steps. STEPS : 1. Run adbldxml.pl on <RDBMS ORACLE_HOME> perl <RDBMS…
Read MoreORA-01012: not logged on error while trying to start the oracle database. Solution: To resolve this error remove the orphaned shared memory segment using sysresv utility. sysresv command will list…
Read MoreThis script is used to take backup of oracle application home in specific mount point. First it will check the size of apps home and calculate the mount point future…
Read MoreThis query is used to check the ORA error in past one hour. query: COLUMN ORIGINATING_TIMESTAMP FORMAT A40 COLUMN message_text FORMAT A100 set linesize 300 SELECT ORIGINATING_TIMESTAMP , message_text FROM…
Read MoreThis script is useful to import monthly backup of specific schema from prod to uat after taking necessary schema backup in uat. In prod every month the schema is exported…
Read More