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 …
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 …
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 »
Here are some important questions and queries for oracle EBS password expiration, password complexity, profiles options How to Stop the Force Password Reset on Creation of User Account in Oracle EBS When a new EBS user is created, the User is supposed to change the password of the account upon the first login. There are …
Useful Queries on oracle EBS password expiration/Policy/Settings Read More »
