Search Results jai_po_copydoc_t

Overview

The JAI_PO_COPYDOC_T table is a temporary data object within the Oracle E-Business Suite, specifically for releases 12.1.1 and 12.2.2. It is a core component of the JA (Asia/Pacific Localizations) product module. As indicated by its name and the 'T' suffix, this table serves as a transient storage repository. Its primary function is to facilitate the "Copy" functionality for Purchase Orders within the localized environment. When a user copies an existing purchase order to create a new one, this table temporarily holds the source document's key data during the processing logic, ensuring data integrity and transactional control throughout the copy operation.

Key Information Stored

The table's structure is designed to capture the essential identifiers from the source purchase order document. Based on the provided foreign key metadata, the critical columns include PO_HEADER_ID, PO_LINE_ID, and LINE_LOCATION_ID, which store the unique keys from the source purchase order's header, line, and shipment (line location) records, respectively. A notable column is FROM_HEADER_ID, which likely stores the identifier of the original purchase order header being copied, acting as a direct reference to the source document in the PO_HEADERS_ALL table. The data stored is typically session-specific or process-specific and is purged after the copy transaction is complete.

Common Use Cases and Queries

The sole use case for this table is supporting the purchase order copy process within the JA localization. It is not intended for direct reporting or long-term data storage. Database administrators or support personnel might query it during troubleshooting to verify if copy processes are leaving orphaned data or to monitor active sessions. A sample diagnostic query would join the table to the core PO tables to see what data is currently staged:

SELECT j.*, ph.segment1 FROM_po_number FROM jai_po_copydoc_t j, po_headers_all ph WHERE j.from_header_id = ph.po_header_id;

Direct manipulation of this table's data is strongly discouraged, as it is managed by the application's internal logic.

Related Objects

JAI_PO_COPYDOC_T has defined relationships with several fundamental tables in the Purchasing (PO) module, as confirmed by its foreign keys. It is directly linked to:

PO_HEADERS_ALL: Via PO_HEADER_ID and FROM_HEADER_ID columns. This links the temporary data to both the source and target purchase order headers.
PO_LINES_ALL: Via PO_LINE_ID. This links to the specific lines of the purchase order being copied.
PO_LINE_LOCATIONS_ALL: Via LINE_LOCATION_ID. This links to the shipment and quantity details for each line.

These relationships underscore the table's role in replicating the hierarchical structure of a purchase order document during the copy transaction. The table itself is likely referenced by internal JA localization packages or concurrent programs that execute the copy functionality.

Table: JAI_PO_COPYDOC_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_COPYDOC_T, object_name:JAI_PO_COPYDOC_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Temporary table used to store data of Purchase orders during Copy functionality. , implementation_dba_data: JA.JAI_PO_COPYDOC_T ,
Table: JAI_PO_COPYDOC_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_COPYDOC_T, object_name:JAI_PO_COPYDOC_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Temporary table used to store data of Purchase orders during Copy functionality. , implementation_dba_data: JA.JAI_PO_COPYDOC_T ,
APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on JAI_PO_COPYDOC_T 12.1.1
APPS.JAI_PO_TAX_PKG dependencies on JAI_PO_COPYDOC_T 12.2.2
APPS.JAI_PO_LA_TRIGGER_PKG dependencies on JAI_PO_COPYDOC_T 12.1.1
APPS.JAI_PO_LA_TRIGGER_PKG dependencies on JAI_PO_COPYDOC_T 12.2.2
APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on JAI_PO_COPYDOC_T 12.2.2
APPS.JAI_PO_TAX_PKG dependencies on JAI_PO_COPYDOC_T 12.1.1
VIEW: JA.JAI_PO_COPYDOC_T# 12.2.2
owner:JA, object_type:VIEW, object_name:JAI_PO_COPYDOC_T#, status:VALID,
SYNONYM: APPS.JAI_PO_COPYDOC_T 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JAI_PO_COPYDOC_T, status:VALID,
SYNONYM: APPS.JAI_PO_COPYDOC_T 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JAI_PO_COPYDOC_T, status:VALID,
VIEW: JA.JAI_PO_COPYDOC_T# 12.2.2
TABLE: JA.JAI_PO_COPYDOC_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_COPYDOC_T, object_name:JAI_PO_COPYDOC_T, status:VALID,
TABLE: JA.JAI_PO_COPYDOC_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_COPYDOC_T, object_name:JAI_PO_COPYDOC_T, status:VALID,
Table: PO_HEADERS_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL, object_name:PO_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Document headers (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_HEADERS_ALL ,
Table: PO_HEADERS_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL, object_name:PO_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Document headers (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_HEADERS_ALL ,
PACKAGE BODY: APPS.JAI_PO_LA_TRIGGER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_LA_TRIGGER_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_PO_LLA_TRIGGER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_LLA_TRIGGER_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_PO_LA_TRIGGER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_LA_TRIGGER_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_PO_LLA_TRIGGER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_LLA_TRIGGER_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_PO_TAX_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_TAX_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_PO_TAX_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_TAX_PKG, status:VALID,
Table: PO_LINE_LOCATIONS_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL, object_name:PO_LINE_LOCATIONS_ALL, status:VALID, product: PO - Purchasing , description: Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL ,
Table: PO_LINE_LOCATIONS_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL, object_name:PO_LINE_LOCATIONS_ALL, status:VALID, product: PO - Purchasing , description: Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL ,
Table: PO_LINES_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL, object_name:PO_LINES_ALL, status:VALID, product: PO - Purchasing , description: Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL ,
Table: PO_LINES_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL, object_name:PO_LINES_ALL, status:VALID, product: PO - Purchasing , description: Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL ,
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
APPS.JAI_PO_LA_TRIGGER_PKG SQL Statements 12.1.1
APPS.JAI_PO_LA_TRIGGER_PKG SQL Statements 12.2.2
APPS.JAI_PO_TAX_PKG SQL Statements 12.1.1
APPS.JAI_PO_LLA_TRIGGER_PKG SQL Statements 12.1.1
APPS.JAI_PO_TAX_PKG SQL Statements 12.2.2
APPS.JAI_PO_LLA_TRIGGER_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.JAI_PO_LA_TRIGGER_PKG 12.1.1
PACKAGE BODY: APPS.JAI_PO_LA_TRIGGER_PKG 12.2.2
PACKAGE BODY: APPS.JAI_PO_LLA_TRIGGER_PKG 12.1.1
PACKAGE BODY: APPS.JAI_PO_LLA_TRIGGER_PKG 12.2.2
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,
PACKAGE BODY: APPS.JAI_PO_TAX_PKG 12.1.1
PACKAGE BODY: APPS.JAI_PO_TAX_PKG 12.2.2
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,