Search Results po_requisition_headers_all
The PO_REQUISITION_HEADERS_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for purchase requisition header-level data, serving as the foundation for procurement processes. This table stores metadata and control information for requisitions, which are internal requests for goods or services before they are converted into purchase orders. Below is a detailed analysis of its structure, purpose, key columns, and integration within Oracle EBS.
Table Overview
PO_REQUISITION_HEADERS_ALL is a multi-organization table, denoted by the "_ALL" suffix, meaning it stores data across operating units. Each record represents a requisition header, which includes attributes like requisition number, creation date, status, and requester details. The table links to subsidiary tables such as PO_REQUISITION_LINES_ALL (for line items) and integrates with modules like Purchasing, Inventory, and General Ledger.Key Columns and Descriptions
- REQUISITION_HEADER_ID: Primary key, uniquely identifying each requisition.
- SEGMENT1: The human-readable requisition number (e.g., "REQ12345").
- PREPARER_ID: Foreign key to PER_ALL_PEOPLE_F, identifying the employee who created the requisition.
- DESCRIPTION: Optional text describing the requisition's purpose.
- AUTHORIZATION_STATUS: Tracks workflow approval states (e.g., "APPROVED," "PENDING").
- CREATION_DATE and LAST_UPDATE_DATE: Audit columns for tracking record lifecycle.
- ORG_ID: Operating unit identifier, enabling multi-org functionality.
- TYPE_LOOKUP_CODE: Classifies requisitions (e.g., "PURCHASE," "INTERNAL").
Functional Significance
The table supports core procurement workflows:- Requisition Creation: Users initiate requests via Oracle Self-Service Procurement or Purchasing forms, inserting records into this table.
- Approval Routing: The AUTHORIZATION_STATUS column interacts with Oracle Workflow to manage approvals.
- Conversion to POs: Approved requisitions are sourced by buyers to generate purchase orders, linking to PO_HEADERS_ALL.
- Reporting & Analytics: The table feeds OTBI (Oracle Transactional Business Intelligence) for spend analysis.
Integration Points
- Inventory: Requisitions for stock items reference MTL_SYSTEM_ITEMS_B.
- General Ledger: Charge accounts are validated against GL_CODE_COMBINATIONS.
- HRMS: Employee data ties to PER_ALL_PEOPLE_F for requester details.
Technical Considerations
- Indexes: Key indexes include PO_REQUISITION_HEADERS_U1 (on REQUISITION_HEADER_ID) and PO_REQUISITION_HEADERS_N1 (on SEGMENT1).
- Partitioning: In large implementations, partitioning by CREATION_DATE improves performance.
- Purge Strategies: Archiving old requisitions via PO_PURGE_REQUISITIONS prevents table bloating.
Customization Scenarios
Extensions might include:- Adding descriptive flexfields (DFFs) for industry-specific attributes.
- Creating triggers to enforce custom validation rules.
- Developing APIs to integrate with third-party systems.
Conclusion
The PO_REQUISITION_HEADERS_ALL table is a linchpin in Oracle EBS Procurement, enabling end-to-end requisition management. Its design supports scalability, auditability, and integration with financial and supply chain modules. Understanding its structure is essential for troubleshooting, customization, and optimizing procurement operations.-
Table: PO_REQUISITION_HEADERS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQUISITION_HEADERS_ALL, object_name:PO_REQUISITION_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Requisition headers , implementation_dba_data: PO.PO_REQUISITION_HEADERS_ALL ,
-
Table: PO_REQUISITION_HEADERS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQUISITION_HEADERS_ALL, object_name:PO_REQUISITION_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Requisition headers , implementation_dba_data: PO.PO_REQUISITION_HEADERS_ALL ,
-
APPS.POA_DBI_PO_DIST_F_C dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.JAI_RCV_TAX_PKG dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.CST_EAMCOST_PUB dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.CSP_SUPPLY_DEMAND_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.PA_CHECK_COMMITMENTS dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.CST_PACEAMCOST_GRP dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.POR_CANCEL_NOTIF_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.AHL_OSP_RCV_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.INV_DIAG_RCV_IPROC_COMMON dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.INV_DIAG_RCV_IO dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.RCV_AVAILABILITY dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.PO_CREATE_REQUISITION_SV dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.POR_PURGE_SYS_SAVED_REQ dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.IGC_CBC_FUNDS_CHECKER dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.INV_MGD_MVT_SO_MDTR dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.1.1
-
APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.OE_INTERNAL_REQUISITION_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.EAM_WORKORDER_UTIL_PKG dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.INV_DIAG_RCV_IO dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.INV_MGD_MVT_STATS_PROC dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.CSP_PLAN_DETAILS_PKG dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.FV_YE_CLOSE dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.POR_PURGE_SYS_SAVED_REQ dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.EAM_DIRECT_ITEMS_VALIDATE_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PJM_SCHED_INT_WF dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.FV_FACTS_TRX_REGISTER dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_AME_SETUP_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.OE_PROCESS_REQUISITION_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.POR_AME_APPROVAL_LIST dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.FV_GTAS_TRX_REGISTER dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.AHL_MM_MTL_MGT_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.JAI_PO_TAX_PKG dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2
-
APPS.PO_REQ_LINES_SV dependencies on PO_REQUISITION_HEADERS_ALL
12.2.2