Why are the certain questions not displayed in the Complex Question's details mapping LOV? (Doc ID 1361944.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

You are attempting to setup an Extract Macro with a complex question in order to concatenate two time/date values into one (see Note 1361970.1). While attempting to assign the two questions in the Complex Question's details mapping, you observe that START_DT and START_TM  are not listed in the LOV.

Setup two questions as follows:

GLIB > Questions > Enter two non-complex question type questions with a Question Data Type of Date and Time, as in the following listed questions:


Question  Question    Question
Name      Type        Data Type
=========:===========:==========
START_DT : DATE TIME :  DATE
START_TM : DATE TIME :  TIME


Create Extract Macro:


OC NAV: GLIB > Data Extract View Builder > Extract Macros


Macro Name: DTTM
Status: A
Date Type: CHAR
SQL MACRO: TO_CHAR(<VALUE_TEXT>C1) ||':'|| TO_CHAR(<VALUE_TEXT>C2)



Create a complex question:


GLIB > Questions > Enter a complex question:


Question  Question  Question
Name      Type      Data Type
=========:=========:==========
DT_TM    : COMPLEX : CHAR


Once the status of the complex question has been set to Active the Details button will become active.

Click the Details button

When you try to assign your question by clicking on the Question Name window, then the LOV ellipsis, the questions you wanted to select are not displayed in the list.

Why are the desired questions not displayed in the list?


Solution

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