What is Audit Trail? Audit Trail (Oracle EBS Auditing) is a way of keeping track of changes made to important data in Oracle Application tables. Audit Trail keeps a history of the following three questions:1. What changed2. Who changed it3. When did the change take placeThis can be done on a row by row basis …
How to Setup Oracle EBS Auditing Read More »
Oracle allows you to rename existing columns in a table. Use the RENAME COLUMN clause of the ALTER TABLE statement to rename column i,e alter table rename column in oracle Syntax ALTER TABLE table_name RENAME COLUMN old_name to new_name; Let’s see this example SQL> CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL, …
We often need to check the status of Workflow Agent listener , WF Java Deferred Agent Listeners in Oracle EBS environment. Sometime a transaction might be struck somewhere and we need to trouble shoot. The queries given in the below post will help in checking about workflow related settings SQL to check the AQ setup …
SQL to check Workflow Agent Listeners are running Read More »
Sometimes we want to change passwords through the backend in EBS. Here is how to change user password in oracle apps from backend. Login to the apps Schema and then execute this PLSQL block. set serveroutput on DECLARE change_pass BOOLEAN; user varchar2(40); pass varchar2(40); BEGIN user := ‘<user name>’; pass := ‘<password>’; change_pass := fnd_user_pkg.changepassword(user,pass); …
how to change user password in oracle apps from backend Read More »
This post I will discuss about various to troubleshoot the problem where we cannot move the file in window or permission denied as some of the process has that file open . There are two cases in this scenerio File is opened by the Process on the Same system In this particular case, you can …
Oracle Database 19c, is the long term support release of the Oracle Database 12c. It belongs to the family Oracle Database 12.2.0.x and 19c is basically Oracle Database 12.2.0.3.Premier and Extended Support for the Oracle 19c is through to March 2023 and March 2026 respectively. You can download Oracle database 19c from the below linkDownload …
Oracle Database 19c new features Read More »
