Activity Processing Dates

Oracle Insurance Rules Palette

You are here: Configuration > Transactions > Activity Processing > Activity Processing Dates

 

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.  

 

Explanation of database date tables

Database Date and Time Tables

 

Explanation of timestamp information

Activity Database Information

 

Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices