Search Results po encumbrance

DeepseekETRM - PO Tables and Views in Oracle EBS 12.1.1/12.2.2

Oracle E-Business Suite (EBS) utilizes a comprehensive set of tables and views to manage Procurement (PO) functionalities. The DeepseekETRM framework provides a structured approach to understanding these database objects, their relationships, and their role in the PO module. This summary explores key PO tables and views in Oracle EBS 12.1.1 and 12.2.2, focusing on their purpose and interdependencies.

Core PO Tables:
The PO module relies on foundational tables that store transactional and master data:

1. PO_HEADERS_ALL: This table stores purchase order header information, including PO number, vendor details, currency, and approval status. The PO_HEADER_ID serves as the primary key and links to downstream tables.

2. PO_LINES_ALL: Contains line-level details for each PO, such as item descriptions, quantities, unit prices, and line status. It references PO_HEADER_ID to associate with the parent PO.

3. PO_DISTRIBUTIONS_ALL: Tracks accounting distributions for PO lines, linking to GL code combinations (CODE_COMBINATION_ID). Critical for financial integration.

4. PO_VENDORS: Master table for supplier data, including payment terms, tax details, and vendor sites. Joined with PO_HEADERS_ALL via VENDOR_ID.

5. PO_REQUISITIONS_ALL: Stores requisition data that may feed into POs, with REQUISITION_HEADER_ID and REQUISITION_LINE_ID as key fields.

Key PO Views:
Oracle provides views that simplify reporting and integration by combining related tables:

1. PO_HEADERS_V: A view joining PO_HEADERS_ALL with HR organization tables to include operating unit context.

2. PO_LINES_V: Enhances PO_LINES_ALL with item master data from MTL_SYSTEM_ITEMS_B.

3. PO_RELEASES_V: Combines blanket agreement release information from multiple underlying tables.

4. PO_VENDORS_V: Enriches vendor data with additional attributes from financial and purchasing setups.

Technical Considerations:
- Multi-org architecture is implemented through ORG_ID columns in most tables
- Open Interface tables (PO_HEADERS_INTERFACE, PO_LINES_INTERFACE) facilitate data imports
- Key flexfields like Accounting Flexfield (GL_CODE_COMBINATIONS) appear in distribution tables
- Audit columns (CREATION_DATE, LAST_UPDATE_DATE) follow Oracle standards

Integration Points:
PO tables interact with:
- Inventory (MTL_SYSTEM_ITEMS_B) for item details
- General Ledger (GL_CODE_COMBINATIONS) for accounting
- Payables (AP_INVOICES_ALL) for invoice matching
- Receiving (RCV_TRANSACTIONS) for shipment tracking

Version Differences:
While 12.1.1 and 12.2.2 share the same core PO table structures, 12.2.2 introduces:
- Enhanced web services integration tables
- Additional columns for cloud integration
- Optimized indexes in some high-volume tables

Understanding these tables and views through the DeepseekETRM lens enables effective customization, reporting, and troubleshooting in Oracle EBS Procurement implementations.

Lookup Type: LINE ENCUMBRANCE STATUS 12.2.2
product: AP - Payables , meaning: Line Encumbrance Status , description: Defines values for encumbrance status for a line ,
Lookup Type: LINE ENCUMBRANCE STATUS 12.1.1
product: AP - Payables , meaning: Line Encumbrance Status , description: Defines values for encumbrance status for a line ,
Lookup Type: ENCUMBRANCE OBJECT TYPE 12.1.1
product: PO - Purchasing , meaning: Encumbrance Object Types , description: Encumbrance Object Types ,
Lookup Type: ENCUMBRANCE OBJECT TYPE 12.2.2
product: PO - Purchasing , meaning: Encumbrance Object Types , description: Encumbrance Object Types ,
Lookup Type: PO TYPE 12.1.1
product: PO - Purchasing , meaning: Types of Purchase Orders , description: Types of Purchase Orders ,
Lookup Type: PO SHIPMENT 12.2.2
product: PO - Purchasing , meaning: PO Shipment Notes , description: PO Shipment Notes ,
Lookup Type: PO DISTRIBUTIONS 12.1.1
product: PO - Purchasing , meaning: PO Distributions Options , description: PO Distributions Options ,
Lookup Type: PO RELEASE 12.1.1
product: PO - Purchasing , meaning: PO Release Navigation , description: PO Release Navigation ,
Lookup Type: PO LINES 12.1.1
product: PO - Purchasing , meaning: PO Lines Navigation , description: PO Lines Navigation ,
Lookup Type: PO DISTRIBUTIONS 12.2.2
product: PO - Purchasing , meaning: PO Distributions Options , description: PO Distributions Options ,
Lookup Type: PO LINES 12.2.2
product: PO - Purchasing , meaning: PO Lines Navigation , description: PO Lines Navigation ,
eTRM - PO External Dependencies 12.1.1
Lookup Type: PO APPROVAL 12.1.1
product: PO - Purchasing , meaning: Approval states for a Purchase Order , description: Approval states for a Purchase Order ,
eTRM - PO External Dependencies 12.2.2
Lookup Type: PO RELEASE 12.2.2
product: PO - Purchasing , meaning: PO Release Navigation , description: PO Release Navigation ,
Lookup Type: PO TYPE 12.2.2
product: PO - Purchasing , meaning: Types of Purchase Orders , description: Types of Purchase Orders ,
Lookup Type: PO SHIPMENT 12.1.1
product: PO - Purchasing , meaning: PO Shipment Notes , description: PO Shipment Notes ,
Lookup Type: PO HEADER 12.1.1
product: PO - Purchasing , meaning: PO Header Navigation , description: PO Header Navigation ,
Lookup Type: PO APPROVAL 12.2.2
product: PO - Purchasing , meaning: Approval states for a Purchase Order , description: Approval states for a Purchase Order ,
Lookup Type: PO HEADER 12.2.2
product: PO - Purchasing , meaning: PO Header Navigation , description: PO Header Navigation ,
File: GML_11i_PO Blanket PO System.pdf 12.2.2
product: GML - Process Manufacturing Logistics , size: 17.933 KBytes , file_type: PDF Diagram ,
Lookup Type: PO DIST MATCH 12.1.1
product: AP - Payables , meaning: Po Dist Match , description: Matching Options for PO distribution matching ,
Lookup Type: PO HEADER CONTROL 12.1.1
product: PO - Purchasing , meaning: Control Context Option , description: Control Context Option ,
Lookup Type: PO DIST MATCH 12.2.2
product: AP - Payables , meaning: Po Dist Match , description: Matching Options for PO distribution matching ,
eTRM - PO Tables and Views 12.2.2
description: Temporary table for tracking a receiving upgrade from Release 9 to Release 10 ,
Lookup Type: PO HEADER CONTROL 12.2.2
product: PO - Purchasing , meaning: Control Context Option , description: Control Context Option ,
eTRM - PO Tables and Views 12.1.1
description: Temporary table for tracking a receiving upgrade from Release 9 to Release 10 ,
File: GML_11i_PO Blanket PO System.pdf 12.1.1
product: GML - Process Manufacturing Logistics , size: 17.933 KBytes , file_type: PDF Diagram ,
eTRM - PO Tables and Views 12.2.2
description: Temporary table for tracking a receiving upgrade from Release 9 to Release 10 ,
eTRM - PO Tables and Views 12.1.1
description: Temporary table for tracking a receiving upgrade from Release 9 to Release 10 ,
Lookup Type: RESERVE PO NUM 12.2.2
product: PO - Purchasing , meaning: Reserve PO Number , description: Reserve PO Number ,
Lookup Type: RESERVE PO NUM 12.1.1
product: PO - Purchasing , meaning: Reserve PO Number , description: Reserve PO Number ,
Lookup Type: PO SHIPMENT VIEW OPTION 12.1.1
product: PO - Purchasing , meaning: PO shipment navigation , description: PO shipment navigation ,
Lookup Type: PO SHIPMENT VIEW OPTION 12.2.2
product: PO - Purchasing , meaning: PO shipment navigation , description: PO shipment navigation ,
Lookup Type: PO INVOICE MATCH OPTION 12.2.2
product: PO - Purchasing , meaning: Invoice Match Options , description: Invoice Match Options ,
Lookup Type: PO HEADER VIEW OPTION 12.2.2
product: PO - Purchasing , meaning: Options for PO View form, Header Level , description: Options for PO View form, Header Level ,
Lookup Type: PO LINE VIEW OPTION 12.2.2
product: PO - Purchasing , meaning: Options for PO View form, Line Level , description: Options for PO View form, Line Level ,
Lookup Type: PO INVOICE MATCH OPTION 12.1.1
product: PO - Purchasing , meaning: Invoice Match Options , description: Invoice Match Options ,
Lookup Type: PO DISTRIBUTIONS VIEW OPTION 12.2.2
product: PO - Purchasing , meaning: View PO distributions Options , description: View PO distributions Options ,
Lookup Type: PO SOURCE DOCUMENT TYPE 12.2.2
product: PO - Purchasing , meaning: PO Source Document Types from Vendors , description: PO Source Document Types from Vendors ,
Lookup Type: PO DISTRIBUTIONS VIEW OPTION 12.1.1
product: PO - Purchasing , meaning: View PO distributions Options , description: View PO distributions Options ,
Lookup Type: PO LINE VIEW OPTION 12.1.1
product: PO - Purchasing , meaning: Options for PO View form, Line Level , description: Options for PO View form, Line Level ,
Lookup Type: PO SOURCE DOCUMENT TYPE 12.1.1
product: PO - Purchasing , meaning: PO Source Document Types from Vendors , description: PO Source Document Types from Vendors ,
Lookup Type: PO ACCEPT VIEW OPTION 12.1.1
product: PO - Purchasing , meaning: acceptances lookup type , description: acceptances lookup type ,
Lookup Type: PO HEADER VIEW OPTION 12.1.1
product: PO - Purchasing , meaning: Options for PO View form, Header Level , description: Options for PO View form, Header Level ,
Lookup Type: PO ACCEPT VIEW OPTION 12.2.2
product: PO - Purchasing , meaning: acceptances lookup type , description: acceptances lookup type ,
Lookup Type: XLA_BUSINESS_FLOW_CLASS 12.2.2
product: XLA - Subledger Accounting , meaning: XLA_BUSINESS_FLOW_CLASS , description: Gives meaning for the business flow class ,
Lookup Type: XLA_BUSINESS_FLOW_CLASS 12.1.1
product: XLA - Subledger Accounting , meaning: XLA_BUSINESS_FLOW_CLASS , description: Gives meaning for the business flow class ,
PACKAGE: APPS.AP_ACCOUNTING_UTILITIES_PKG 12.1.1
PACKAGE: APPS.AP_ACCOUNTING_UTILITIES_PKG 12.2.2