OATM stands for Oracle Applications tablespace model. As per this new model, All the tables ,view etc are categorized in followings types Tables and Indexes: Tables are allocated to a tablespace based on their classification. Each table is classified as one of the following TRANSACTION: Tables that are populated by data entry screens or batch […]
Oracle Applications tablespace model (OATM) Read More »
What is Oracle Logon Triggers A trigger is called Oracle logon trigger if it is associated with logon action on triggering event. This is system triggers how to check logon triggers in oracle select * from dba_triggers where triggering_event like ‘%LOGON%’; Example SQL> Set lines 200 SQL> column owner format a10 SQL> column TRIGGER_NAME format
How to use Oracle logon trigger to stop login from Particular program Read More »
Introduction In this section, we are trying to explain the Handling of table data in R12.2 online patching using oracle edition based redefinition(forward cross edition triggers) Suppose the patch has to modify the column Description from Mixed Case to Upper case Table A has the Existing Description column has values of (red, ORANGE…)The requirement from the patch
forward cross edition triggers in R12.2 Read More »
This Oracle SQL tutorial focuses on self join in oracle, and provides syntax, explanations, examples A self join in Oracle is a join of oracle table to itself. We can use the table multiple times .Each occurrence should have an alias name.Oracle database while executing the query join the table with itself and produce the
Self join in oracle with examples Read More »
Profile Option: ‘Initialization SQL Statement – Custom’ provides a profile option that allows to execute ‘custom’ code at the beginning of every database session. These sessions can be linked to an Oracle application Form, a Concurrent Program, Self Service Page or any other piece of code that requires accessing the database. The most common use
Initialization SQL Statement – Custom” (FND_INIT_SQL) profile option Read More »
We must have got many problems in forms in R12/11i and we are required to generate FRD(Forms runtime diagonsitics) trace for the forms session. Here in this posts,i will tell what all i have learned about it and how to generate FRD Trace How to generate FRD trace There are two ways you can generate
How to generate FRD trace in Oracle Apps 11i/R12 Read More »
