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
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVATION_DATE | ● | Activation date. | |
| ALLOW_RESP_COMMENT_FLAG | ● | Indicator (Y/N) for the allow resp comment. | |
| ATTACHMENT_ALLOWED_CODE | ● | Code identifying the attachment allowed. | |
| CRITICAL_QUESTION_FLAG | ● | Indicator (Y/N) for the critical question. | |
| DISPLAY_PREFERRED_RESP_FLAG | ● | Indicator (Y/N) for the display preferred resp. | |
| LATEST_REVISION_FLAG | ● | Indicator (Y/N) for the latest revision. | |
| PREFERRED_RESPONSE_DATE | ● | Preferred response date. | |
| PREFERRED_RESPONSE_DATETIME | ● | Preferred response datetime. | |
| PREFERRED_RESPONSE_NUMBER | ● | Preferred response number. | |
| PREFERRED_RESPONSE_TEXT | ● | Preferred response text. | |
| QUESTION_HINT | ● | Question hint. | |
| QUESTION_ID | PK? | ● | Identifier for the question. |
| QUESTION_LEVEL | ● | Question level. | |
| QUESTION_NAME | ● | Name of the question. | |
| QUESTION_STATUS | ● | Status of the question. | |
| QUESTION_TEXT | ● | Question text. | |
| QUESTION_TYPE | ● | Type of question. | |
| RESPONDER_TYPE | ● | Type of responder. | |
| RESPONSE_REQUIRED_FLAG | ● | Indicator (Y/N) for the response required. | |
| RESPONSE_TYPE | ● | Type of response. | |
| REVISION_NUMBER | ● | Revision number. | |
| STDS_ORG_CODE | ● | Code identifying the stds organization. | |
| SUBJECT_CODE | ● | Code identifying the subject. | |
| SUPPLIER_ATTRIBUTE_CODE | ● | Code identifying the supplier attribute. | |
| SUPPLIER_ATTRIBUTE_FLAG | ● | Indicator (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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Supplier Qualification - Qualifications and Assessments Real Time
- Supplier Qualification - Question Responses Real Time
Need the extract + dbt staging for POQ_QUESTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table