JANSE Member since 2011 5 posts
Posted: August 19, 2015
Last activity: August 21, 2015

BIX updatedatetime

We have the BIX framework installed on top of our application.

As per the BIX documentation it is not possible to only extract delta's from the classes like Assign- and History-. This is because the pxUpdateDate column does not exist for these tables and BIX uses this to identify the delta records.

However we have made this working by manually adding a column to the history table called pxUpdateDateTime. The value inserted here is autogenerated by the Oracle DB (Default value) and inserts the current system time whenever a new record is added.

The question actually is....while this seems as an easy enough solution should we actually be doing this and are we not affecting the BIX functionality in some kind of negative way?

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn