Error ORA-01426: numeric overflow When Running Import Price Catalogs Concurrent Program (Doc ID 1420427.1)

Last updated on AUGUST 18, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:POXPDOI - Import Price Catalogs
ConcurrentProgram:POXPOPDOI - Import Standard Purchase Orders


Symptoms


Import Price Catalog concurrent program completes with error.

Error:

ORA-01426: numeric overflow in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_sync.30
ORA-01426: numeric overflow in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.30
ORA-01426: numeric overflow in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10
ORA-01426: numeric overflow 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. Insert records into PO interface tables PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, PO_DISTRIBUTIONS_INTERFACE
2. Submit concurrent program Import Price Catalogs
3. The concurrent program completes with error
4. Error is logged in the concurrent program logfile

This error is also reported for concurrent program Import Standard Purchase Orders.

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