Oracle Ebuisness Suite

Oracle E-business Suite also called as Oracle application is a suite of business applications made up of a large number of distinct software modules.Examples are  Oracle Supply chain, Oracle financials etc

This page contain all the administration related post for all the Oracle apps version  11i/R12/R12.1/R12.2

 

You can also view the Oracle application post in more ordered manner at below link

E-Business Suite 11i/R12/R12.1/R12.2

How to rebuild WF_DEFERRED_TABLE_M Queue

Oracle, Oracle Ebuisness Suite

Sometimes we need to rebuild the WF_DEFERRED_TABLE_M queue due to corruption. Here are the steps to perform it. (1) First, take a pre snapshot of all the objects related to that queue Login to server and source the EBS environment spool WF_DEFERRED_TABLE_M_objects_pre.lstselect object_name, object_type, status, ownerfrom dba_objectswhere object_name like ‘%WF_DEFERRED_TABLE_M%’;spool off (2) Now we will proceed …

How to rebuild WF_DEFERRED_TABLE_M Queue Read More »

How Edition-Based Redefinition in Oracle Database 11gR2/12c/18c/19c works

Oracle, Oracle Database, Oracle Ebuisness Suite

Edition-based redefinition in Oracle Database 11gR2//12c/18c/19c allows multiple versions of PL/SQL objects, views, and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero downtime. It also means we can  maintain multiple copies of the same object What is Edition in Oracle? An edition is effectively a version …

How Edition-Based Redefinition in Oracle Database 11gR2/12c/18c/19c works Read More »

How To Determine Which File System is the Run or Patch File System in R12.2

Oracle, Oracle Ebuisness Suite

Oracle Apps R12.2 has two filesytem to enable online patching. We can determine Which File System is the Run or Patch File System by either looking at the file_edition_type in the Context file or by doing the backend query using sql Using context file on the filesystem or Sourcing the env if you know the …

How To Determine Which File System is the Run or Patch File System in R12.2 Read More »

Scroll to Top