DMS Error and Incorrect Inventory Adjustments Created While Performing CF Pick (Doc ID 2933932.1)

Last updated on MARCH 09, 2023

Applies to:

Symptoms

DMS Error and incorrect Inventory adjustments created while performing CF pick.

Steps To Recreate:

1.PICK_FROM_LOC record:
  ITEM_ID='CFPICK ,unit_qty = 66 , casepack =6 , unit_capacity =150, unit_replen_qty = 60
2.Create CF picks for 6 units.
3.Start Picking Operation. Confirm the quantity to pick with Huge value(7 digits) Say "8877888".
  System reported the Warning "The Indicated Quantity is Invalid". Confirm with OK.
4.Press TAB . Confirm the quantity to pick with Huge value(7 digits) Say "8877888".
  Again System reported the Warning "The Indicated Quantity is Invalid". Confirm with OK.
5.Press F3-EXIT.
  Confirm NO for the message "Do you want to Exit This Screen".
6.Press F7-Skip.
7.Again Confirm the quantity to pick with Huge value(7 digits) Say "8877888" and Press F5-FULL.
  Again System reported the Warning "The Indicated Quantity is Invalid". Confirm with OK.
8.Press F7-SKIP and then F3-EXIT.
Confirm "OK" to the "Successful Operation" Message.
9.System throws DMS error message.Confirm the message with OK
10.Press F7-SKIP.
Confirm "OK" to the "Successful Operation" Message.
  Again System throws DMS error message.Confirm the message with OK.
 Form was blocked.
 
Inventory adjustments of 53267328 units was created which is wrong.

Below are the records in ERROR_LOG

FACILITY_ID ERROR_CODE USER_ID ERROR_TS ERROR_SOURCE ERROR_LOC ERROR_MSG
PR -1438 PAR3214 9-Oct-20 HH_FCP_PTP_SYSPAL_OUTB_S HH_FCP_PTP_SYSPAL_OUTB_S.FINAL_PROCESS_PICK ORA-01438: value larger than specified precision allowed for this column

Cause

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