My Oracle Support Banner

E1: 40R: R47171 Is Not Updating Any F40Rxx Tables (Doc ID 1936089.1)

Last updated on NOVEMBER 08, 2019

Applies to:

JD Edwards EnterpriseOne Demand Scheduling Execution - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.

Symptoms

EDI Inbound Demand Edit/Update (R47171) is not processing records correctly after having run successfully for 4 years. There has been no change to dataset, settings or hardware.

Incoming Data:
F47171 - updated with processed Successfully.
F47172 - no update
F47173 - updated with processed Successfully.

Outgoing data:
F40R10 - no update
F40R11 - no update

The UKID used for F40R42 Cumulative Quantity History is Data Dictionary item CREATETM. This is only 6 characters long. After a prolonged period (4 years for this customer), the F40R42.CREATETM value will rollover from 999999 to 1000000. The result of this is an overflow of the variable during the UPDATE of F40R42 as R47171 processes and a failure to commit to the DB. This exhibits itself in the logs as:                                      
.                                                          
INSERT INTO PRODDTA/F40R42 VALUES                          
(43879.000000,114286,1003312.000000                        
...                                                        
ODBC[Jdbodbc.c,3992] STMT:00 [22003][30160] [IBM][System iAccess ODBC Driver]Column 3: Numeric value out of range.

Changes

 none

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