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

OKC_CONTRACT_REQUESTS

SharedUsed in 1 subject areas19 reporting columns

Contracts (OKC).

Primary key: not yet catalogued for OKC_CONTRACT_REQUESTS, reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
APPROVED_DATEApproved date.
ASSIGNEE_IDIdentifier for the assignee.
ASSIGNEE_TYPE_CODECode identifying the assignee type.
CANCELLED_DATECancelled date.
CONTACT_DETAILSContact details.
CONTRACT_END_DATEContract end date.
CONTRACT_NUMBERContract number.
CONTRACT_START_DATEContract start date.
CONTRACT_TYPE_IDIdentifier for the contract type.
CREATION_DATEDate and time the row was created.
CURRENCY_CODECode identifying the currency.
DESCRIPTIONDescription.
DUE_DATEDue date.
IDId.
PARTY_CONTACT_IDIdentifier for the party contact.
PARTY_DETAILSParty details.
REQUEST_NUMBERRequest number.
REQUEST_STATUSStatus of the request.
SUBMITTED_DATESubmitted date.

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 OKC_CONTRACT_REQUESTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern