WHO Columns in Oracle

WHO Columns in Oracle

--===================================================

Who columns are mainly 5 columns in any Oracle Table:

--===================================================

CREATION_DATE,

LAST_UPDATE_DATE,

CREATED_BY,

LAST_UPDATED_BY,

LAST_UPDATE_LOGIN

select CREATION_DATE,

LAST_UPDATE_DATE,

CREATED_BY,

LAST_UPDATED_BY,

LAST_UPDATE_LOGIN from fnd_user

CREATION_DATE	LAST_UPDATE_DATE	CREATED_BY	LAST_UPDATED_BY	LAST_UPDATE_LOGIN
11-03-1998 22:34	11-03-1998 22:34	1	1	0
06-11-1998 17:39	06-11-1998 17:39	1	1	0
11-03-1998 22:34	11-03-1998 22:34	1	1	0

--===================================================

--DROP TABLE XXSD_WHO_COLUMN_TL

CREATE TABLE XXSD_WHO_COLUMN_TL

(

EMP_NO  NUMBER,

EMP_NAME      VARCHAR2(240 BYTE),

GRADE             VARCHAR2(240 BYTE),

SAL         NUMBER,

CREATION_DATE                DATE             DEFAULT SYSDATE,

LAST_UPDATE_DATE          DATE             DEFAULT SYSDATE,

CREATED_BY                      NUMBER,

LAST_UPDATED_BY             NUMBER,

LAST_UPDATE_LOGIN          NUMBER

)

select * from XXSD_WHO_COLUMN_TL

--===================================================

How to Fill Values in WHO Columns

--===================================================

--1-- INSERT FROm BACK END

select * from XXSD_WHO_COLUMN_TL

insert into XXSD_WHO_COLUMN_TL (EMP_NO, EMP_NAME, GRADE, SAL,CREATION_DATE,LAST_UPDATE_DATE,CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN  )

values ( 1,'Sunil', 'L1', 20000, sysdate, sysdate, fnd_global.user_id,fnd_global.user_id,fnd_global.LOGIN_ID )

COMMIT;

EMP_NO	EMP_NAME	GRADE	SAL	CREATION_DATE	LAST_UPDATE_DATE	CREATED_BY	LAST_UPDATED_BY	LAST_UPDATE_LOGIN
1	Sunil	L1	20000	07-03-2020 17:17	07-03-2020 17:17	-1	-1	-1

--2-- FORM LOGIN --

PRE_INSERT triggers.

PRE_UPDATE triggers.

Alternatively the Standard Function  FND_STANDARD.SET_WHO :- can be used to automatically set all the columns in an Oracle Form.

--========  if any data come from Concurrent program ===============

REQUEST_ID,

PROGRAM_APPLICATION_ID,

PROGRAM_ID,

PROGRAM_UPDATE_DATE

select REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID, PROGRAM_UPDATE_DATE

from XLA_AE_HEADERS 

--===================================================

How to Fill Values in WHO Columns

--===================================================

FND_PROFILE.VALUE

For Manual setting :-

In an Oracle Form, the login to set values for these columns can be stored at

PRE_INSERT and PRE_UPDATE triggers.

The values can be set from Profile values by using the statement: FND_PROFILE.VALUE(‘<Id Type>’)

Alternatively the Standard Function  FND_STANDARD.SET_WHO :- can be used to automatically set all the columns in an Oracle Form.