WIP Assembly Return SN LOV Not Able To Validate SNs Returned As Components From Parent Jobs

(Doc ID 2380608.1)

Last updated on MARCH 30, 2018

Applies to:

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

Symptoms

On Inventory Management, 12.1.3 version, Serial Transactions

ACTUAL BEHAVIOR
-----------------------
The serial numbers issued as materials on other jobs cannot be returned against the job that created them in the first place. This is because wip issue transaction will overwrite the mtl_serial_numbers.original_wip_entity_id value with the new job id but when doing wip material return it is not reverted to previous value.

EXPECTED BEHAVIOR
-----------------------
Expect to be able to return the subassembly SN to the original job.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. WIP Completion for SN1 on JOB1
2. WIP Issue for SN1 on JOB2
3. WIP Material Return for SN1 on JOB2
4. Cannot select SN1 for WIP Completion Return against JOB1.

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