Form 开发
表需要包含5个操作记录跟踪字段:
列名 foreign key value
created_by fnd_user to_number(fnd_profile.value('USER_ID'))
creation_date sysdate
last_updated_by fnd_user to_number(fnd_profile.value('USER_ID'))
last_update_date sysdate
last_update_login fnd_logins to_number(fnd_profile.value('login_id'))
FORM中调用 FND_STANDARD.SET_WHO in PRE-UPDATE and PRE-INSERT 赋值
并发请求
request_id fnd_concurrent_requests
program_application_id fnd_concurrent_programs
program_id fnd_concurrent_programs
program_update_date