AutoPatch error the worker should not have status Running or Restarted at this point

AutoPatch error the worker should not have status Running or Restarted | ADOP Patch Session got terminated abnormally due to network issue or patch hung or lost connectivity after that we are facing the error when restart adop patch. AutoPatch error the worker should not have status Running or Restarted at this point.   Error: … Read more

How to drop XLA_GLT temporary Tables in EBS

Drop XLA_GLT temporary Tables| As an Oracle DBA we need to reclaim space in database. For this we need to clear all temporary tables in our instance, which is no longer required. Temporary tables used in the GL Transfer process are no longer cleared down once the transfer is complete. using program ‘Purge Temporary Journal … Read more

adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150 or unable to start oacore oc4j in r12

adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150| Sometimes application services not brought down gracefully and don’t delete the .lock file. Later we bring up the application then these .lock file causing an issue for OC4J instance.   How to fix adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150? To fix this error adoacorectl.sh exiting with status … Read more

How to register custom top in oracle apps r12

Here we going to discuss ‘How to register custom top in oracle apps r12‘. Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will use “xxcustomzprod.txt”. How to register custom top in oracle apps r12. We will follow below steps to register/create custom top in r12.2. Step 1: – Creating Custom TOP/Application using AD Splice … Read more

Mount Windows share filesystem on linux using CISF

Mount Windows share filesystem on linux using CISF|Common Internet File System(CISF) is file sharing network protocol mainly used to provide shared access to files, printers, serial ports, and miscellaneous communications between nodes on a network. You can easily access CIFS share from Linux and mount them as a regular filesystem.       Examples:-      #mount … Read more

How to manually Compile pll fmb and rdf file in oracle ebs R12

Manually Compile pll fmb | Sometimes we need to Manually Compile .pll .fmb .rdf file, if we are facing issue with forms, reports and libraries etc. using frmcmp_batch module=XXXX.fmb userid=apps, we can compile fmb. Steps to Manually Compile pll fmb .In R12 Compiling .pll (library):- Manually Compile .pll .fmb   cd $AU_TOP/resourcefrmcmp_batch module=JAAUUCOM.pll userid=apps/***** output_file=JAAUUCOM.plx module_type=library batch=yes … Read more

Fixed REP-0756 Warning Unable to find PL SQL library ‘inv’ in oracle apps R12

Fixed REP-0756 Warning Unable to find PL SQL library ‘inv’ in oracle apps R12 | Discrete Job Shortage Report Completes with Error (REP-0252, REP-0756, REP-0736, REP-1247, REP-0069, REP-57054, REP-1247) in oracle apps R12. How to fix REP-0756 Warning Unable to find PL SQL library. ERROR———————–REP-0756: Warning: Unable to find PL/SQL library ‘inv’.REP-0736: There exist uncompiled program … Read more

ORA-00257 archiver error Connect internal only until freed fixed in best way.

ORA-00257 archiver error Connect internal only until freed | The archiver process received an error while trying to archive the redo logfile. Due to this issue oracle database will stop executing the transaction. So, we have to check the archive destination because most likely cause of this error is the destination device is out of … Read more