close
1.Table中建立5個Who Columns
CREATED_BY | NUMBER |
CREATION_DATE | DATE |
LAST_UPDATED_BY | NUMBER |
LAST_UPDATE_DATE | DATE |
LAST_UPDATE_LOGIN | NUMBER |
2.在BLOCK層級觸發器pre-insert及pre-update trigger中加入
fnd_standard.set_who;
全站熱搜