POR_REQUISITION_HEADERS_ALL is the table used by Oracle Fusion to store the Requisition Header data. Related tables are por_requisition_lines_all which is the child table for header table and stores the line level data. So lets have a look at the table structure, indexes and constraints.
Want to give back to the society? (Do you have something which you think can be used by folks working on Oracle world wide?) Then Click here, share your email id and a brief description of the topic. And keep your photo and the content ready.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports. Try them only when nothing else works.. kind of SOS...
POR_REQUISITION_HEADERS_ALL Table Structure
| COLUMN_NAME | DATA_TYPE | NULLABLE |
| REQUISITION_HEADER_ID | NUMBER | N |
| EXTERNALLY_MANAGED_FLAG | VARCHAR2(4) | Y |
| PREPARER_ID | NUMBER | N |
| REQUISITION_NUMBER | VARCHAR2(256) | N |
| REQ_BU_ID | NUMBER | N |
| DESCRIPTION | VARCHAR2(960) | Y |
| DOCUMENT_STATUS | VARCHAR2(100) | Y |
| JUSTIFICATION | VARCHAR2(4000) | Y |
| ACTIVE_REQUISITION_FLAG | VARCHAR2(4) | Y |
| MODIFYING_APPROVER_ID | NUMBER | Y |
| EMERGENCY_REQ_FLAG | VARCHAR2(4) | Y |
| EMERGENCY_PO_NUMBER | VARCHAR2(120) | Y |
| PRC_BU_ID | NUMBER | Y |
| PCARD_ID | NUMBER | Y |
| CHANGE_PENDING_FLAG | VARCHAR2(4) | Y |
| INTERFACE_SOURCE_CODE | VARCHAR2(100) | Y |
| INTERFACE_SOURCE_LINE_ID | NUMBER | Y |
| SUBMISSION_DATE | TIMESTAMP(6) | Y |
| APPROVED_DATE | TIMESTAMP(6) | Y |
| REQ_IMPORT_APPROVER_ID | NUMBER | Y |
| DEFAULT_TAXATION_COUNTRY | VARCHAR2(8) | Y |
| DOCUMENT_SUB_TYPE | VARCHAR2(960) | Y |
| TAX_USER_OVERRIDE_HDR_FLAG | VARCHAR2(4) | Y |
| APPROVAL_INSTANCE_ID | NUMBER | Y |
| ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| SOLDTO_LE_ID | NUMBER | Y |
| HAS_WITHDRAWN_LINES | VARCHAR2(4) | Y |
| HAS_CANCELED_LINES | VARCHAR2(4) | Y |
| HAS_RETURNED_LINES | VARCHAR2(4) | Y |
| HAS_REJECTED_LINES | VARCHAR2(4) | Y |
| HAS_INCOMPLETE_LINES | VARCHAR2(4) | Y |
| LOCKED_BY_BUYER_FLAG | VARCHAR2(4) | Y |
| HAS_PENDING_APPR_LINES | VARCHAR2(4) | Y |
| LINE_GROUP | VARCHAR2(120) | Y |
| FUNDS_STATUS | VARCHAR2(120) | Y |
| PROCESS_STATUS | VARCHAR2(120) | Y |
| ATTRIBUTE1 – ATTRIBUTE20 | VARCHAR2(600) | Y |
| ATTRIBUTE_DATE1 – ATTRIBUTE_DATE10 | DATE | Y |
| ATTRIBUTE_TIMESTAMP1 – ATTRIBUTE_TIMESTAMP10 | TIMESTAMP(6) | Y |
| ATTRIBUTE_NUMBER1 – ATTRIBUTE_NUMBER10 | NUMBER | Y |
| CREATED_BY | VARCHAR2(256) | N |
| CREATION_DATE | TIMESTAMP(6) | N |
| LAST_UPDATED_BY | VARCHAR2(256) | N |
| LAST_UPDATE_DATE | TIMESTAMP(6) | N |
| LAST_UPDATE_LOGIN | VARCHAR2(128) | Y |
| REQUEST_ID | NUMBER | Y |
| JOB_DEFINITION_NAME | VARCHAR2(400) | Y |
| JOB_DEFINITION_PACKAGE | VARCHAR2(3600) | Y |
| OBJECT_VERSION_NUMBER | NUMBER | N |
| FUNDS_CHK_FAIL_WARN_FLAG | VARCHAR2(4) | Y |
| BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2(4) | N |
| OVERRIDING_APPROVER_ID | NUMBER | Y |
| FUNDS_OVERRIDE_APPROVER_ID | NUMBER | Y |
| INSUFFICIENT_FUNDS_FLAG | VARCHAR2(4) | Y |
| INTERNAL_TRANSFER_REQ_FLAG | VARCHAR2(4) | Y |
Indexes
Index type F means Function Based while N means Normal index.
| INDEX_NAME | INDEX_TYPE | UNIQUENESS | COLUMN_NAME |
| POR_REQUISITION_HEADERS_N1 | N | N | PREPARER_ID |
| POR_REQUISITION_HEADERS_N1 | N | N | REQUISITION_NUMBER |
| POR_REQUISITION_HEADERS_N10 | F | N | SYS_NC00104$ |
| POR_REQUISITION_HEADERS_N11 | F | N | SYS_NC00105$ |
| POR_REQUISITION_HEADERS_N12 | N | N | EMERGENCY_PO_NUMBER |
| POR_REQUISITION_HEADERS_N13 | N | N | REQ_BU_ID |
| POR_REQUISITION_HEADERS_N13 | N | N | PREPARER_ID |
| POR_REQUISITION_HEADERS_N13 | N | N | REQUISITION_HEADER_ID |
| POR_REQUISITION_HEADERS_N13 | N | N | CREATION_DATE |
| POR_REQUISITION_HEADERS_N14 | N | N | REQUEST_ID |
| POR_REQUISITION_HEADERS_N2 | N | N | CREATION_DATE |
| POR_REQUISITION_HEADERS_N2 | N | N | REQ_BU_ID |
| POR_REQUISITION_HEADERS_N3 | N | N | DOCUMENT_STATUS |
| POR_REQUISITION_HEADERS_N4 | N | N | MODIFYING_APPROVER_ID |
| POR_REQUISITION_HEADERS_N5 | N | N | LAST_UPDATE_DATE |
| POR_REQUISITION_HEADERS_N6 | N | N | ACTIVE_REQUISITION_FLAG |
| POR_REQUISITION_HEADERS_N6 | N | N | LAST_UPDATED_BY |
| POR_REQUISITION_HEADERS_N8 | F | N | SYS_NC00101$ |
| POR_REQUISITION_HEADERS_N9 | F | N | SYS_NC00102$ |
| POR_REQUISITION_HEADERS_N9 | F | N | SYS_NC00103$ |
| POR_REQUISITION_HEADERS_U1 | N | Y | REQUISITION_HEADER_ID |
Related Posts
- POR_REQUISITION_LINES_ALL: Table Structure, Index and Constraints
- P2P Or Procure To Pay Cycle in Oracle
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
1 thought on “POR_REQUISITION_HEADERS_ALL: Columns & Indexes”
Comments are closed.