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 AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version: 12.0 to 12.0.3 - Release: 12 to 12
Information in this document applies to any platform.
***Checked for relevance on 21-Apr-2011***
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms