Transfer Report Not Displaying Correct Quantities When NOT Divisible By Pack Size (Doc ID 3076666.1)

Last updated on MARCH 18, 2025

Applies to:

Symptoms

If system parameter 'Default UOM = 2 (cases), item quantities are not displayed incorrectly if item not divisible by pack size:

tsf_item.case_size pack_size,
CASE
WHEN config.value = 2
AND Mod(tsf_item.quantity_requested, tsf_item.case_size) = 0 THEN tsf_item.quantity_requested / tsf_item.case_size
ELSE tsf_item.quantity_requested
END AS qty_req,

Steps to Reproduce:

System Parameter: Default UOM set to Cases

1. Log-in to Requesting Store
2. Create Transfer Request in SOCS-JET (3 items)
3. Enter requested quantities NOT divisible by pack size
4. Note Transfer ID to use to print report
5. Select Footer menu: Save and Exit
6. Note: Report can be generated from EICS without issue
7. Log in to EICS
8. Navigate to Operations > Report
9. Select Transfer Report and Enter ID
10. Print Report

Error: UOM set to 'cases' for ALL items however, requested qty for items is not requested qty/pack size
Note: UOM issue applies to all requested, approved, in-shipping, shipped, received & damaged

Cause

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