Logical view of the data model in R12.2 1) All the code should access the tables through APPS synonym 2) Editioning view are created over physical tables and APPS synonym are created to editioning view as shown in below figure WF_ITEMS: Physical table WF_ITEMS#: Editioning view APPS.WF_ITEMS : APPS synonym to Editioning views 3) All […]
Logical view of the data model in R12.2 Read More »
What is Unix Users? A UNIX system serves many users. Users are an abstraction that denotes a logical entity for assignment of ownership and operation privileges over the system. UNIX identifies each user by a User ID (UID) and the username (or login) such as ‘oracle’ and ‘applmgr’ is just an alias to the UID
file permissions in Unix Read More »
Oracle EBS is the Oracle Corporation product that comprises of Customer relationship Management(CRM ), Enterprise Resource Planning(ERP), Supply chain Management(SCM), and Human Resource Management system (HRMS). Organizations can use Oracle EBS as per their need. If they are interested in Oracle Financials products only, they can license those modules only. Oracle EBS is also known
what is oracle EBS R12 Read More »
The Unix command has the following common pattern command_name options argument(s) Here we are trying to give some of the basic unix command in Unix Information Related man It is used to see the manual of the various command.It helps in selecting the correct options to get the desirable output. Just need to give man command
Unix Script Tutorial : basic unix command Read More »
What is Shell Whenever you login to a Unix system you are placed in a program called the shell. The shell acts as a command interpreter; it takes each command and passes it to the operating system kernel to be acted upon. It then displays the results of this operation on completion on your screen.
What is shell and Shell Scripts Read More »
To find sessions generating lots of redo in Oracle database , you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. How to find session generating lots of redo in Oracle database 1) Query V$SESS_IO. This view
how to find session generating lots of redo in Oracle database Read More »
