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 …
We will be discussing Oracle create tablespace statement/oracle create tablespace 11g/12c/19c in detail in this post. I will through light on all the option on create tablespace statement.I would also be discussing ,how to alter the tablespace to read-only, offline the tablespace,how to move tablespace to another location,drop the tablespace. Apart from that, how you …
What is FNDFS Explaining how FNDFS working (1) The user selects ‘Request Output’, ‘Request Log’, or ‘Manager Log’ (2) The file name and node name are selected from the database.Reports: SELECT outfile_name, outfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Logfiles: SELECT logfile_name, logfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Manager logs: SELECT logfile_name, node_name FROM fnd_concurrent_processes …
How FNDFS (Oracle Report Review agent) works in EBS environment Read More »
