Oracle Database Packages are widely used in EBS R12. We have thousands of Packages in the Apps schema. These packages are loaded and modified in the Oracle database using adpatch or adop using the files in the $PRODUCT_TOP/patch/115/sql/*pls. In this article, we will see How to check Package version in EBS R12 Sometimes, we have …
How to check Package version in EBS R12 Read More »
In this post, we will discuss, what is restore point in an oracle, how to check restore point in oracle What is a Restore Point in Oracle? Guaranteed restore points Normal Restore Points how to check the restore point in Oracle You can check the restore point in the Oracle database using the below query …
Patch Wizard is a tool provided by Oracle for finding the impact of application patches on the Environment. It is a handy tool and shows all the impacted files and appropriate action can be taken based on that information. It is an extremely important tool and here I will explain how to use Patch Wizard, …
How to use Patch wizard in Oracle EBS environment Read More »
APPLSYSPUB is the database schema. it is the first schema that is used in any connection in Oracle apps. APPLSYSPUB default password is PUB. It is not an application user and thus you cannot find that in the FND_USER table in the Oracle database of Oracle applications Oracle forms, and OACORE all connect to it …
Introduction We often want to run pre-defined jobs at different schedules. Oracle database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for scheduling pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs …
How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER Read More »
Here are a few troubleshooting tips for ADOP failures in R12.2 How to set service ebs_patch in R12.2 While running the adop phase=prepare, we receive the below error [ERROR] Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach) Need to check for service in the listener …
Troubleshooting ADOP failures in R12.2 Read More »
