# DW_REQUISITION_AGG_CF

Requisitions Aggregate Fact

## Details

Module: Purchasing

## Key Columns

SYSTEM_GEN_PK

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_GEN_PK | VARCHAR2 | 512 |  | True | Generated Primary Key for Internal Use Only |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. System Generated |  |
PO_PROC_BU_ID | NUMBER | 38 | 0 |  | Procurement business unit identifier |  |
SECURITY_PROC_BU_ID | NUMBER | 38 | 0 |  | If REQ_PROC_BU_ID is null then PO_PROC_BU_ID else REQ_PROC_BU_ID | DW_INTERNAL_ORG_D | ORGANIZATION_ID
REQUISITION_BU_ID | NUMBER | 38 | 0 |  | Requisition business unit identifier |  |
REQ_BU_PRIMARY_LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledger identifier of requisition business unit |  |
REQ_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. |  |
REQ_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. |  |
REQUISITION_HEADER_CREATION_PERIOD | VARCHAR2 | 64 |  |  | Accounting period name. |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
REQUISITION_AMOUNT | NUMBER |  |  |  | Requisition amount in global currency |  |
REQUISITION_COUNT | NUMBER |  |  |  | Count of requisitions |  |
REQ_SUBMIT_TO_FULFIL_TIME | NUMBER |  |  |  | Time taken to fulfil requisition i.e. from req line last submit date to purchase order line closed date |  |
REQ_APPROVAL_CYCLE_TIME | NUMBER |  |  |  | Time taken to get requisition approved in first cycle i.e. from first submit date to first approval date |  |
COUNT_OF_FULFILLED_REQ | NUMBER |  |  |  | Count of requisition line id from last submit date to purchase order line closed date |  |
COUNT_OF_APPROVED_REQ | NUMBER |  |  |  | Count of requisition header id from first submit date to first approval date |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.