Effective Start Date Changes To A Future Date When Any Field Is Modified In The CRF

(Doc ID 1313606.1)

Last updated on APRIL 20, 2011

Applies to:

Oracle Clinical - Version: 4.6.0 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.

Symptoms

The 'Effective Start Date' and 'Effective End Date' for Lab Range are updated to a future date if any field in the screen (RXARAMLA) , (except Effective Start Date and Effective End Date), are updated.

Steps to Reproduce:

  •  Glib
  • Questions
  • Questions
  • Create a LAB TEST number question.
  • Labs
  • Lab Units
  • Lab Units
  • Create a Lab Unit Code e.g. ppm
  • Labs
  • Lab Units
  • LTQ Units : Query back the LAB TEST question created in earlier step
  • Associate the ppm lab unit with this question
  • Save.
  • Labs
  • Labs
  • Labs : Create a new lab.
  • Click on [Ranges].
  • Specify the LAB TEST Question and enter following details :
    • min/Max Age
    • Low/High Values
    • Enter 01-JAN-2010 for the Effective Start Date.
    • Enter 15-JAN-2010 for the Effective End Date
  • Save
  • Now check the Effective Start / End Date fields > no data is displayed.
  • Check the underlying RANGES data:

select to_char(EFFECTIVE_START_DATE,'dd-mon-yyyy'),to_char(EFFECTIVE_END_DATE,'dd-mon-yyyy') from ranges$jn where lab_id=<lab_id>


Before update:
TO_CHAR(EFFECTIVE_START_DATE,'DD-MON-YYYY') TO_CHAR(EFFECTIVE_END_DATE,'DD-MON-YYYY')
------------------------------------------- -----------------------------------------
01-jan-2010 01-jan-2014

  • Change either Min or Max Age, or Low or High.
  • Check the underlying RANGES data

select to_char(EFFECTIVE_START_DATE,'dd-mon-yyyy'),to_char(EFFECTIVE_END_DATE,'dd-mon-yyyy') from ranges$jn where lab_id=<lab_id>


After update:
TO_CHAR(EFFECTIVE_START_DATE,'DD-MON-YYYY') TO_CHAR(EFFECTIVE_END_DATE,'DD-MON-YYYY')
------------------------------------------- -----------------------------------------
01-jan-4712 15-aug-3501


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms