Set a Field for Auditing
Audit your business object's history using fields based on existing columns in your DB table or view. For example, let's say your table has the DATETIME_CREATED, DATETIME_MODIFIED, USER_CREATED_BY, USER_MODIFIED_BY, and VERSION_NUM columns; you can add these columns as fields to your business object and use them to track history.
Audit fields maintain a history of changes made to your business object by tracking who created and updated an object when. They also include a version number used in the generation of an entity tag (ETag) which protects against users overwriting changes. Because audits can help you verify changes, you might want to set audit fields for each of these history types: Created By, Updated By, Time Created, Time Updated, and Version Number. A warning will be logged in your app's Audits pane for each history type that isn't assigned to a field. You'll also see an error if the same history type is assigned to more than one field.
Purpose | Column Data Type |
---|---|
Created By | VARCHAR2(200)Foot 1 |
Creation Date | TIMESTAMP(6) |
Updated By | VARCHAR2(200)Foot 1 |
Updated Date | TIMESTAMP(6) |
ETag | NUMBER |
Footnote 1 200 is an example.
To set a field added to a business object based on an existing table or view as an audit field: