Analytics Catalog/Data dictionary/POQ_QUESTIONS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

POQ_QUESTIONS

SharedUsed in 2 subject areas25 reporting columns

Source object in the Oracle Fusion data model.

Likely primary key: QUESTION_ID (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

ColumnKeyIn reportsDescription (inferred)
ACTIVATION_DATEActivation date.
ALLOW_RESP_COMMENT_FLAGIndicator (Y/N) for the allow resp comment.
ATTACHMENT_ALLOWED_CODECode identifying the attachment allowed.
CRITICAL_QUESTION_FLAGIndicator (Y/N) for the critical question.
DISPLAY_PREFERRED_RESP_FLAGIndicator (Y/N) for the display preferred resp.
LATEST_REVISION_FLAGIndicator (Y/N) for the latest revision.
PREFERRED_RESPONSE_DATEPreferred response date.
PREFERRED_RESPONSE_DATETIMEPreferred response datetime.
PREFERRED_RESPONSE_NUMBERPreferred response number.
PREFERRED_RESPONSE_TEXTPreferred response text.
QUESTION_HINTQuestion hint.
QUESTION_IDPK?Identifier for the question.
QUESTION_LEVELQuestion level.
QUESTION_NAMEName of the question.
QUESTION_STATUSStatus of the question.
QUESTION_TEXTQuestion text.
QUESTION_TYPEType of question.
RESPONDER_TYPEType of responder.
RESPONSE_REQUIRED_FLAGIndicator (Y/N) for the response required.
RESPONSE_TYPEType of response.
REVISION_NUMBERRevision number.
STDS_ORG_CODECode identifying the stds organization.
SUBJECT_CODECode identifying the subject.
SUPPLIER_ATTRIBUTE_CODECode identifying the supplier attribute.
SUPPLIER_ATTRIBUTE_FLAGIndicator (Y/N) for the supplier attribute.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for POQ_QUESTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us