My Oracle Support Banner

R12: Import Standard Purchase Orders Concurrent Request Fails with "Exception in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure validate_line_locs.20" (Doc ID 472121.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Purchasing - Version 12.0.0 to 12.0.3 [Release 12]
Information in this document applies to any platform.
ConcurrentProgram:POXPOPDOI - Import Standard Purchase Orders


Symptoms

The standard purchase orders import program fails with the following error message in the log

Exception in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure validate_line_locs.20
User-Defined Exception in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_line_locations.60
User-Defined Exception in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.30
User-Defined Exception in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110
User-Defined Exception in Package po.plsql.PO_PDOI_Concurrent. Procedure POXPDOI.30

Steps to reproduce-
1. Populate the open interface tables for the standard purchase order import.
2. Run the 'Import Standard Purchase Orders' concurrent program.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.