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

by

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

by

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.

by

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

GST Form JAINNSTL.fmb is having error during compilation

by

Facing error GST Form JAINNSTL.fmb is having error during applying GST July RUP 11 patches in R12.2.xx. Fixing GST Form JAINNSTL.fmb is having error.      Issue:-  ——————   Form JAINNSTL.fmb is having error during compilation.       As per Oracle support Development team form JAINNSTL.fmb is obsoleted and this error is due to … Read more

Oracle Home is not registered with the Central Inventory.

by

Oracle home is not registered with the central inventory. We are facing the error during the patch installation as below: Oracle home is not registered with the central inventory. Error:- The Oracle Home <your ORACLE_HOME> is not registered with the Central Inventory.  OPatch was not able to get details of the home from the inventory. … Read more

Adop phaseprepare failing with error UNEXPECTEDError 1 occurred while Executing txkADOPValidation script on ebs1

by

Adop phaseprepare failing with error UNEXPECTEDError 1 occurred while executing txkADOPValidation.pl script on ebs1| Adop phaseprepare failing with error UNEXPECTEDError fixing in best way. Below error adop phase=prepare failed at txkADOPValidation.pl occurring while preparing oracle apps for patching using adop.     Validating configuration on node: [xxxxx].     Log:   /data03/1225_data/1225apps/fs_ne/EBSapps/log/adop/11/20180907_171515/prepare/validate/test           … Read more

Best API to reset password in oracle EBS R12.

by

Introduction:- In this article, we will use best API to reset password from backend | Being Oracle Database administrator,we are using various API scripts to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution/script to production carefully. Here we are discussing ‘how to change user password … Read more

Best API to end date responsibility from fnd user

by

Introduction:- Being Oracle Database administrator, we are using various API to end date responsibility to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution/script to production carefully. Here we are discussing ‘how to end date responsibility in oracle apps from backend‘ using API to … Read more

API to add responsibility to user in oracle apps from backend

by

API to add responsibility to Assign responsibility to user in oracle apps from backend | Being Oracle Database administrator, we are using various API scripts to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution to production carefully. Here we are discussing ‘how to … Read more

rman catalog commands to register old backupset

by

Introduction: – RMAN catalog command tips | To restore the oracle database using rman , first of all we have to Cataloging RMAN backup in RMAN Catalog. There are many rman catalog commands to register old backupset to new location, so that rman read the backup piece and restore them. Below is some RMAN CATALOG command example. Catalog … Read more