Announcements
No record found.
What could cause DEX_ROW_TS to be updated for many records at once in IV00101 table? for example 3000 records have exactly same value in DEX_ROW_TS. The MODIFDT field has not changed. It does not seem to be due to manual editing. and it is strange they all have exactly same value in DEX_ROW_TS
Did you run some sort of update statement. .... even if it updated to the same value, it would cause the trigger that updates the timestamp to run.
If performed at the SQL level it would have all been one transaction which would give everything the same datetime value.
If the update had a where clause so it only updated records that needed changing, it would not have been so heavy handed.
That's my thoughts.
David
Din,
Agree with David, any integration that would have updated the IV00101 table in SQL would have caused to trigger the DEX_ROW_TS timestamp field, as long as the row as affected by it.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 429 Most Valuable Professional
CU10121822-0 366
André Arnaud de Cal... 360 Super User 2026 Season 2
