Trigger are important construct in oracle . These are the codes which are fired when a row is updated ,inserted or deleted in the oracle table. Lets find how to check trigger status in oracle, how to check trigger definition in oracle, How to find all Trigger in the table and many more How to […]
Initialization SQL Statement – Custom” (FND_INIT_SQL) profile option
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 […]
How to generate FRD trace in Oracle Apps 11i/R12
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 enable trace in oracle apps r12
Some time user get performance issue during various pages in Oracle Apps application.We need to take the trace of the problem in order to identify the bottleneck We can execute below steps to generate the database level trace for the issue and find out the culprit sql or statement.Here is how to enable trace in […]
Supplemental Logging in Oracle
What is Supplemental Logging in Oracle Oracle Redo log file has the record of all the operation performed in the database by default or automatically.So Redo log files are generally used for instance recovery and media recovery. They are also used for Physical standby or physical replication. But by default Oracle redo logs files does […]
Useful Queries on oracle EBS password expiration/Policy/Settings
Here are some important question 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, User is supposed to change the password of the account upon first login. There are cases […]
