My Oracle Support Banner

'Discrepancy has been updated since it was queried' appears in the Discrepancy Database screen. (Doc ID 949557.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.

Symptoms

After having applied iPatch 4.5.1.67 and when trying to update a discrepancy, an error message is thrown.

ERROR MESSAGE: Discrepancy has been updated since it was queried. Data has been refreshed on the screen.

This is misleading, however, since no data has been refreshed by the user at this point.


OCCURRENCE PATTERNS: always since applying 4.5.1.67 and whenever a trailing blank has been stored in one of the discrepancy's fields, particularly the Page Number field.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
 MAIN SCENARIO : CRF_PAGE_NUMBER has Leading And / Or Trailing Spaces :
 SCENARIO 2 : CRF_PAGE_NUMBER has *NO* Leading And / Or Trailing Spaces :
 SCENARIO 3 : CRF_PAGE_NUMBER has *NO* Leading And / Or Trailing Spaces' *AND* the Output from check_disc_fields.sql' seems fine :
 SCENARIO 4 : Error Occurs for TMS Discrepancies which should no longer be CURRENT :
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.