My Oracle Support Banner

RCA Serials Cost_group_id = 0 Not Correctly Set On Account Alias Receipt (Doc ID 2525308.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

On :  12.2.4 version, Reservations

Actual Behavior
Cost group on serial does not match cost group in MOQD.
Find corruption in some cases against cost_group_id = 0 in the serial table

Expected Behavior
Expect cost group to be properly set in all cases.

Steps
The issue can be reproduced at will with the following steps:
Inspect serials and find that there is corruption on some cost group ids for some serials

1. Account alias Receipt (Organization is non-WMS for this example)

2. Enter Item TEST-01 (Test Unit assy) (Locator GDELS.8305LS...

3. Enter Serial Number TEST-011 - TEST-013

4. Assign end unit to one of the serials (Unit Number 1024

* See here that serial cost groups are as expected:

select msib.segment1, msib.description, serial_number, msn.end_item_unit_number, cost_group_id, msn.current_locator_id
from mtl_serial_numbers msn, mtl_system_items_b msib
where
msn.current_organization_id = 1234 and
msn.current_organzation_id = msib.organization_id and
msn.inventory_item_id = msib.inventory_item_id and
msn.current_status = 3 and
msib.segment1 like 'TEST%' and
msn.serial_number like ('TEST%);

see that all cost_group_id = 12345 as expected

5. Perform subinventory transfer for serial TEST-021, TEST-001, TEST-012

Re-run above SQL and find that for the subinventory transfered serials the cost group id gets nulled out.

Business Impact
The issue has the following business impact:
Due to this issue, users cannot Use serial with incorrect cost group which is causing delays in processing time resulting in stagnating of expected inventory.

Changes

 

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.