My Oracle Support Banner

Date Field Response that is Greater Than Year 2020 gets Converted to 'YYYYMMDD' Format. (Doc ID 2742388.1)

Last updated on JANUARY 26, 2021

Applies to:

Oracle Clinical Remote Data Capture Option - Version 5.0.1 to 5.1.0 [Release 5.0.0 to 5.1]
Oracle Clinical - Version 5.0.1 to 5.1.0 [Release 5.0 to 5.1]
Information in this document applies to any platform.

Symptoms

1)
OC/RDC: Dates entered into Date Fields (which appear on the DCI Header / Data Entry screen) after the year 2020 are reformatted to an 8 digit 'YYYYMMDD' string. The same date should have appeared in the 'DD-MON-YYYY' format.

2)
The following is observed in Oracle Clinical when entering say the DCI Date for a new document using 2020/2021 year dates:

  • OC Data Entry ('Initial Log-in and First Pass Entry' screen): enter '31-DEC-20' in the DCI Date field
  • tab out > DCI date gets formatted to '31-DEC-2020' (good)
  • press [page down] to navigate to the Data Entry screen which can be accessed (good)
     
  • OC Data Entry ('Initial Log-in and First Pass Entry' screen): enter '05-JAN-21' (partial year) or '05-JAN-2021' (full year) in the DCI Date field
  • tab out > DCI Date gets formatted to '20210105' (bad)
  • press [page down] to navigate to the DE screen > 'FRM-40735: KEY-NXTBLK trigger raised unhandled exception ORA-06502' error appears / unable to enter the DE screen (bad)
  • OC Data Entry ('Initial Log-in' screen): enter '05-JAN-21' (partial year) or '05-JAN-2021' (full year) in the DCI Date field
  • tab out > DCI Date gets formatted to '20210105' (bad)
  • try to save > 'FRM-40735: KEY-COMMIT trigger raised unhandled exception ORA-06502' error appears / unable to save the document (bad)

 

3)
The following is observed in RDC Onsite when entering say the DCI Date for a new document using a 2021 date:

 

4)   
Issue affects both the CRF header and Data Entry screen.



5)   
Please see attached testcase document for more details on the above (click here to access).

Changes

 

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
Changes
Cause
Solution
References


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