E1: 34: Inventory Committed Quantities Are Incorrect On AS/400 (Doc ID 1637684.1)

Last updated on DECEMBER 23, 2015

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.0 to 9.1 [Release 9.0 to 9.1]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Forecasting and MRP P4021

P4021 Creating nonesense DB Select Requests.

When creating a sales order for a configured item with a Q rule, that has an unconditional purchased component, supply & demand does not pick up the demand for the component on the AS400. The commitment is made in summary availability but no demand is shown in supply & demand. This is due to the data that is written in the select statement of the log for the F3215 being corrupt. Testing in windows platform works fine.

Mar 19 12:36:30.389480 dbdrv.c2057 - 29785/145 WRK:ADAMSL_80000000_P4021 DB2/400 DBResetReq Connhdl = 'SPP:0000 :0000 :0:3:12' A DBReqHand = 'SPP:0000 :0000 :0:a5:12' RESET SSSERV02(Business Data - PROD)
Mar 19 12:36:30.389520 dbsql_s.c1825 - 29785/145 WRK:ADAMSL_80000000_P4021 SELECT CCCFGID, CCCFGCID, CCITM, CCMCU, CCQNTY, CCUOM, CCKIT, CCCFGSID, CCSY, CCWADL, CCPDDJ FROM PD910DTA/F3215 WHERE ( CCMCU = ' 002000' AND CCITM = 553863.000000 AND CCSY = '42' AND CCWADL = ' œÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿ Mar 19 12:36:30.389536 dbdrvag.c966 - 29785/145
Mar 19 12:36:30.390008 dbdrv_log.c196 - 29785/145 WRK:ADAMSL_80000000_P4021 OS400QL009 - OpenSQLCursor:Open SQL cursor: Crsr184. QSQLMSG *LIBL - SQL0335 - Character conversion resulted in substitution characters
Mar 19 12:36:30.390208 dbdrv_log.c220 - 29785/145 WRK:ADAMSL_80000000_P4021 OS400QL009 - OpenSQLCursor: QSQLMSG *LIBL - SQL0335 - Character conversion resulted in substitution characters

  jdeNIDcpy(dsSelect[3].Item1.szTable, NID_F3215);
  jdeNIDcpy(dsSelect[3].Item1.szDict, NID_WADL);
  dsSelect[3].nCmp = JDEDB_CMP_EQ;
  dsSelect[3].nAndOr = JDEDB_ANDOR_AND;

  /* S&S FIx -Start */
  /* dsSelect[3].lpValue = (void *)&mnZero;*/
  dsSelect[3].lpValue = _J("0");
  /* S&S FIx End */
  dsSelect[3].nValues = (ushort) 1;
 

ERROR
-----------------------
OS400QL009 Character conversion resulted in substitution characters.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Create a configured parent item.
2.Create a purchased component.
3.Add a simple segment for the parent item from step 1.
4.Add an unconditional Q assembly inclusion rule for the purchased item from step 2.
5.Enter a sales order for the parent item from step 1.
6.Verify the configuration and Add to Order.
7.OK the order.
8.Navigate to summary availability on menu G41112
9.Do a find of the configured component from step 2
10.A commitment was generated for the component.
11.Go to supply and demand on the same menu and do a find on the component.
12.No demand is shown for the component.
13.This is due to the select statement for the F3215 populating values in the log with odd or garbage characters. Review of logs will verify this.
 
Note: Works fine in windows: If tested in windows platform the demand in supply & demand and commitments from summary availability will reconcile the same quantities correctly.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have the system pick up the demand for the component from the configured item Q rule.

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