My Oracle Support Banner

Update Locator Capacity (WMSLCPUP) Failing with Error ORA-06502: PL/SQL: numeric or value error: NULL index table key value (Doc ID 1545182.1)

Last updated on JANUARY 30, 2021

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
Concurrent: WMSLCPUP - Update Locator Capacity

Symptoms

Release 12.1.3

When launching the Update Locator Capacity concurrent program (WMSLCPUP), it completes with Error the following messages in the request log.
(when debug mode is enabled)

The problem occurs with newly created organizations with no on hand quantities and with no transaction activity.

-- Error

-- Steps
The issue can be replicated per the below steps:

1. Select Responsibility Warehouse Manager

2. Submit the Update Locator Capacity concurrent program

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
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.