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

POQ_RESPONSE_REPOSITORY

SharedUsed in 2 subject areas13 reporting columns

Source object in the Oracle Fusion data model.

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

Columns

ColumnKeyIn reportsDescription (inferred)
ACCEPTANCE_DATEAcceptance date.
ACCEPTANCE_NOTEAcceptance note.
AGGREGATE_RESPONSE_FLAGIndicator (Y/N) for the aggregate response.
DATA_SOURCE_IDIdentifier for the data source.
DATA_SOURCE_TYPEType of data source.
FIRST_SUBMISSION_DATEFirst submission date.
RESPONSE_ARCHIVE_DATEResponse archive date.
RESPONSE_COMMENTSResponse comments.
RESPONSE_REPOSITORY_IDPK?Identifier for the response repository.
RESPONSE_STATUSStatus of the response.
RESPONSE_SUBMISSION_DATEResponse submission date.
SURROG_ENTRY_DATESurrog entry date.
SURROG_RESPONSE_FLAGIndicator (Y/N) for the surrog response.

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_RESPONSE_REPOSITORY?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us