The Record History (WHO) feature reports information about
who created or updated rows in Oracle Applications tables. Oracle Applications
upgrade technology relies on Record History (WHO) information to detect and
preserve customizations.
If you add special WHO columns to your tables and WHO
logic to your forms and stored procedures, your users can track changes made to
their data. By looking at WHO columns, users can differentiate between changes
made by forms and changes made by concurrent programs.
You represent each of the WHO columns as hidden fields in
each block of your form
(Corresponding to the WHO columns in each underlying
table). Call
FND_STANDARD.SET_WHO in PRE-UPDATE and PRE-INSERT to
populate these fields.
Adding Record History
Columns
The following table lists the standard columns used for
Record History (WHO), the
Column attributes and descriptions, and the sources for
the values of those columns. Set the CREATED_BY and CREATION_DATE columns only
when you insert a row (using FND_STANDARD.SET_WHO for a form).
|
Column Name
|
Type
|
Null?
|
Foreign Key?
|
Description
|
Value
|
|
CREATED_B
Y
|
NUMBER(15)
|
NOT NULL
|
FND_ USER
|
Keeps track of which
user
created each row
|
TO_NUMBE
R
(FND_ PROFILE.
VALUE
('USER_ID'))
|
|
CREATION_
DATE
|
DATE
|
NOT NULL
|
|
Stores
the date on which each row was created
|
SYSDATE
|
|
LAST_
UPDATED_B
Y
|
NUMBER(15)
|
NOT NULL
|
FND_ USER
|
Keeps track
of who last
updated each row
|
TO_NUMBE
R
(FND_ PROFILE.
VALUE
('USER_ID'))
|
|
LAST_UPDA
TE_
DATE
|
DATE
|
NOT NULL
|
|
Stores the date on
which each
row was last updated
|
SYSDATE
|
|
LAST_UPDA
TE_
LOGIN
|
NUMBER(15)
|
|
FND_
LOGINS
|
Provides
access to information about the operating system login of the user who last
updated each row
|
TO_NUMBE
R
(FND_ PROFILE.
VALUE
('LOGIN_
ID'))
|
Any
table that may be updated by a concurrent program also needs additional
columns.
The
following table lists the concurrent processing columns used for Record
History,
the
column attributes and descriptions, and the sources for the values of those
columns.
|
Column Name
|
Type
|
Null?
|
Foreign Key to
Table?
|
Description
|
|
REQUEST_ID
|
NUMBER(15)
|
|
FND_
CONCURRENT
_ REQUESTS
|
Keeps
track of the concurrent request during which this row
was created or updated
|
|
PROGRAM_
APPLICATION_
ID
|
NUMBER(15)
|
|
FND_
CONCURRENT
_ PROGRAMS
|
With
PROGRAM_ID,
keeps
track of which concurrent program created
or updated each row
|
|
PROGRAM_ID
|
NUMBER(15)
|
|
FND_
CONCURRENT
_ PROGRAMS
|
With
PROGRAM_
APPLICATION_
ID,
keeps track of which concurrent program created
or updated each row
|
|
PROGRAM_
UPDATE_DATE
|
DATE
|
|
PROGRAM_
UPDATE_
DATE
|
Stores
the date on which the concurrent program created
or updated the row
|
