Oracle Clinical One Analytics

Fixed issue Description
39189816

New data element with correct spelling PRECISION_FOR_EACH_DOSE is added in the Kits and Randomization Design dataset

Now, the Calculated Dose folder in the Kits and Randomization Design dataset includes a new data element for PRECISION_FOR_EACH_DOSE with correct spelling. Another data element already existed for this data point, but its name is misspelled as PERCISION_FOR_EACH_DOSE.

The existing misspelled data element is now obsolete, but still available as part of the dataset for backward compatibility. This is to avoid impacting on existing integrations, if any downstream systems are currently using it. Both, the existing misspelled data element and the new one with correct spelling, display the same value.

Note: Systems consuming the Kits and Randomization Dataset API will require a full refresh before they can use the new column.

38644641

Data Collection Dataset API responds in an adequate amount of time

Now, the Data Collection Dataset API for incremental load scenarios takes an adequate time to complete, ensuring overall API stability. Previously, queries using DH_TIMESTAMP filters timed out and could not complete successfully within the expected response time.

38903987

Queries Dataset API populates select fields correctly in Oracle Clinical one Analytics

Now, the Queries Dataset API correctly populates the CURRENT_STUDY_ROLE_NAME, CURRENT_STUDY_ROLE_ID, and CURRENT_STUDY_ROLE fields in Oracle Clinical One Analytics, ensuring consistency in study role information.

Note: Systems using the Queries dataset API will refresh all queries.

38633742

Subject Forms SVFL datasets return only a single active record for lock actions

Now, Subject Forms SVFL datasets correctly return a single active record for lock actions at the outer form instance level, while duplicate section-level records are excluded from support dataset views, providing more consistent SVFL data for downstream integrations and reporting workflows.

Note: Systems using the Subject Forms SVFL dataset API require a full refresh.

39200955

Subject Forms dataset displays the correct form title

Now, the Subject Forms dataset correctly displays the Study-Version-Specific form title as FORM_NAME for triggered dynamic forms, while form names in Oracle Clinical One Analytics datasets and related reporting views are now aligned with the configured form titles, instead of internal reference names.

Note: Systems using the Subject Forms dataset API will have the data for all triggered dynamic forms refreshed.

38784240

SAS variables and column names are validated and mapped correctly in Oracle Clinical One Analytics

Now, Oracle Clinical One Analytics validates SAS variables and column names using a case-insensitive and standardized uppercase format, preventing duplicate mapping conflicts during study version updates and ensuring successful incremental load processing.

39031900

Accurate dataset API descriptions are provided in Oracle Clinical One Analytics

Now, dataset API descriptions in Oracle Clinical One Analytics include standardized recommendations for order-by columns across supported datasets, providing clear guidance for consistent sorting and reliable dataset retrieval behavior.