My Oracle Support Banner

Unable to find Column name to retrieve Multi choice/Text Response Type of Questions of performance Document's Questionnaire (Doc ID 2902755.1)

Last updated on NOVEMBER 20, 2022

Applies to:

Oracle Fusion Performance Management Cloud Service - Version 11.13.22.04.0 and later
Information in this document applies to any platform.

Goal

On : 11.13.22.04.0 version, 

While creating a Performance Document using Questionnaire, some of the question types are Multiple Choices and Text.

Unable to find a column name from backend  to view the answers submitted for these questions.

For instance, Single Choice question types can be accessed through HRQ_QSTNR_PCPT_RESPONSES_V (such as HQPRV.LONG_TEXT or HQPRV.ANSWER_CODE).

On the other hand, the answer codes for "Check Multiple Choice and Text types" are not stored in the same location. Please suggest.
 

Solution

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
Goal
Solution


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