Activity Processing Dates
The OIPA system controls activity processing through a timestamp in the table AsPolicy. This column always records time as Greenwich Mean Time (GMT).
When an activity is first processed the timestamp is compared against the current time. If the timestamp is less than the current time, then the timestamp will be updated and the activity will process. If the timestamp is greater than the current time, then the asp page will refresh and display a dialog box stating, "Policy being modified by another user." Because the page is refreshed the current data will be displayed.
The look-up and update of the timestamp are performed within a transaction. This transaction will prevent another process from accessing the record until the transaction is complete. This prevents the same activity from being processed by two users.
Database Date and Time Tables
Activity Database Information
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices