Results for “gml_po_mig_errors”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GML_PO_MIG_ERRORS is a table owned by the GML schema (Process Manufacturing Logistics) within Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a migration error reporting table used during data conversion from Common Purchasing to Common Receiving. When purchase order and receipt data is migrated into the GML environment, rows are written to this table to record failures, exceptions, or validation conflicts encountered at the header, line, and shipment level. Each record captures the specific table, column, and source identifier that caused the error along with the diagnostic message raised by the migration process, giving implementers and support teams an audit trail of what did not transfer cleanly.

Based on the heuristic Data Vault classification mined from its foreign key structure, GML_PO_MIG_ERRORS is best modeled as a standalone object. It does not participate in a hub, link, or satellite pattern with related tables in the classic Data Vault sense; instead it behaves as an operational log table. This is consistent with its transactional, exception-oriented purpose: it records events rather than describing a durable business entity.

Key Information Stored

The table contains 18 documented columns. The most significant are grouped below.

• Migration scope and context: MIGRATION_TYPE identifies the class of migration activity being performed. TABLE_NAME and COLUMN_NAME pinpoint the source table and column associated with the failure, which is essential for diagnosing the root cause.
• Error diagnostics: ERROR_MESSAGE carries the textual diagnostic returned by the migration program. CREATION_DATE and LAST_UPDATE_DATE provide the audit timestamps for when the row was inserted and last modified.
• Purchasing identifiers: PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, and PO_RELEASE_ID link the error to the purchasing document hierarchy. PO_RELEASE_ID references PO_RELEASES_ALL, PO_ID references PO_ORDR_HDR, and AQUI_COST_ID references PO_COST_MST.
• Receiving and requisition identifiers: SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID, REQUISITION_HEADER_ID, and REQUISITION_LINE_ID associate the error with downstream receiving or upstream requisition data where applicable.
• Transaction and line references: TRANSACTION_ID and LINE_ID provide additional linkage to the specific transactional records under migration.

No explicit surrogate primary key or unique business index is documented in the available metadata; the combination of identifier columns and TABLE_NAME/COLUMN_NAME effectively serves as the business-key candidate for uniquely locating an error condition.

Common Use Cases and Queries

Typical uses include post-migration reconciliation, exception reporting, and remediation tracking. A recurring pattern is to summarise errors by migration type and source table:

• Error inventory: SELECT MIGRATION_TYPE, TABLE_NAME, COUNT(*) FROM GML.GML_PO_MIG_ERRORS GROUP BY MIGRATION_TYPE, TABLE_NAME;
• Purchasing exceptions: SELECT PO_HEADER_ID, PO_LINE_ID, COLUMN_NAME, ERROR_MESSAGE FROM GML.GML_PO_MIG_ERRORS WHERE PO_HEADER_ID IS NOT NULL;
• Recent failures: SELECT * FROM GML.GML_PO_MIG_ERRORS WHERE CREATION_DATE > SYSDATE - 30;

These queries support migration cutover sign-off, remediation prioritisation, and audit evidence for conversion testing.

Related Objects

• PO_RELEASES_ALL — joined via PO_RELEASE_ID for release-level error context.
• PO_ORDR_HDR — joined via PO_ID to resolve the purchasing document header.
• PO_COST_MST — joined via AQUI_COST_ID for cost-related migration errors.
• PO_HEADERS_ALL / PO_LINES_ALL / PO_LINE_LOCATIONS_ALL — resolved through PO_HEADER_ID, PO_LINE_ID, and LINE_LOCATION_ID.
• RCV_SHIPMENT_HEADERS / RCV_SHIPMENT_LINES — resolved through SHIPMENT_HEADER_ID and SHIPMENT_LINE_ID for receipt-side failures.
• PO_REQUISITION_HEADERS_ALL / PO_REQUISITION_LINES_ALL — resolved through REQUISITION_HEADER_ID and REQUISITION_LINE_ID.

Together these relationships make GML_PO_MIG_ERRORS a central diagnostic reference during the Common Purchasing to Common Receiving migration.