Unable To Perform Replenishment Counting (Doc ID 2196784.1)

Last updated on AUGUST 08, 2023

Applies to:

Symptoms

On : 12.2.5 version, Replenish

Unable to Perform Replenishment Counting.

Process replenishment counts program is erroring.

ERROR
-----------------------
ORACLE error 1405 in RC_PROCESSOR_LIB
Cause: RC_PROCESSOR_LIB failed due to ORAAPP-FND-01564: ORACLE error 1405 in RC_PROCESSOR
Cause: RC_PROCESSOR failed due to ORA-01405: fetched column value is NULL
.

The SQL statement being executed at the time of the error was: begin MO_GLOBAL.init ( 'INV' ) ; :org_id := FND_API.G_MISS_NUM ; : and was executed from the file 14481998/inv/lib/inlrpr.pc.
APP-INV-05501: C failed

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory > Counting > Replenishment Counts > Counts
2. Create Replenishment Count header.
3. Click Lines button and Enter lines
4. Save
5. Click "Process and Report"
6. Check the Concurrent program "Process replenishment counts"

BUSINESS IMPACT
-----------------------
Due to this issue, unable to perform periodic automatic replenishment.

Changes

Cause

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