Replenishment Counts Fail With ORACLE Error 1426 In RC_PROCESSOR (After Patching) (Doc ID 1603920.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Run replenishment counts after applying the inventory rollup (RUP) #6 <Patch 16328540> it errors now when it worked before .
However if a replenishment count with one line is entered, there is no issue.

If a replenishment count is entered a fatal error is shown in the concurrent request "INCRPR module: Process replenishment counts".
On the second count it has the error

ERROR
Concurrent request INCRPR module: Process replenishment counts fails
Log reports
16:04:58 : ** Re-Order quantity based on count type 2 is 1.000000 **
16:04:58 : ** Final Re-Order quantity calculated is -159044111609559175205689403438371687018169193701941726109805744320764788261050831723880835251375951037896067753522999783264074808727252952667953402491410358975744860599502299810996434620258828586584136128935387037577176834813924014292775808259817416239653562133503040024518217006546581310720949250792135589888.000000 **
16:04:58 : ** Error Flag is 990 **
ORACLE error 1426 in RC_PROCESSOR_LIB

Cause: RC_PROCESSOR_LIB failed due to ORAAPP-FND-01564: ORACLE error 1426 in RC_PROCESSOR

Cause: RC_PROCESSOR failed due to ORA-01426: numeric overflow


STEPS
1. Inventory Responsibility
2: Navigate to the Process Replenishment Counts window.
3. Choose New to display the Replenishment Count Headers window
4. Create a replenishment Count of two lines
5. Select process and report .

BUSINESS IMPACT
Due to this issue, users cannot complete the replenishment counts.

Changes

Applied a patch:

<Patch 16328540> - INV/RCV RUP6 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1]

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