After Upgrading From 11.5.10.2 To 12.2.4 WIP Mass Load Error Error in Valid_Req_subinvlocator (Doc ID 2200582.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Work in Process - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 11.5.10.2 to 12.2.4 users are receiving the following error from WIP Mass Load:


ERROR

VALIDATION ERROR HAPPENED!

Debug Log Shows:

  Session 927123: Error in Valid_Req_subinvlocator,inventory_item_id=43475
  Session 927123: Error in Valid_Req_subinvlocator,error_tbl(indx).error_msg=WIP_JDI_INVALID_SUBINV;interface_id=13720416
  Session 927123: wip_operations
  Session 927123: Op Seq 10 FUSD 16-JUN-17 FUCD 16-JUN-17 LUSD 16-JUN-17 LUCD 16-JUN-17
  Session 927123: Op Seq 20 FUSD 16-JUN-17 FUCD 16-JUL-09 LUSD 16-JUN-17 LUCD 16-JUL-09
  Session 927123: wip_operation_resources
  Session 927123: Op Seq 10 Res Seq 10 St Dt 16-JUN-17 Cm Dt 16-JUN-17
  Session 927123: Op Seq 10 Res Seq 60 St Dt 16-JUN-17 Cm Dt 16-JUN-17
  Session 927123: Op Seq 10 Res Seq 70 St Dt 16-JUN-17 Cm Dt 16-JUN-17
  Session 927123: Op Seq 20 Res Seq 40 St Dt 16-JUN-17 Cm Dt 16-JUN-17
  Session 927123: Op Seq 20 Res Seq 210 St Dt 16-JUN-17 Cm Dt 16-JUN-17
  Session 927123: error:WIP_WEI_IGNORED (INTERFACE=13720414)
  Session 927123: error:WIP_WEI_IGNORED (INTERFACE=13720415)
  Session 927123: error:WIP_WEI_IGNORED (INTERFACE=13720416)
" Session 927123: error:13720414 : System cannot change/delete the following material requirement because the requested job/operation/inventory_item_id_old combo does not exist:
job (job_name): 1225764
job id (wip_entity_id): 8609973
operation (operation_"
  Session 927123: error:13720416 :Invalid or insufficient component subinventory/locator information for inventory_item_id 43475 and subinventory MATERIAL
  Session 927123: error:13720415 : Job load failed because there were errors loading the job details. Please check the job detail error message.
  Session 927123: Session 927123: ended on 06/07/2016 10:56:17
Session 927124: Session 927124: started on 06/07/2016 10:56:17
Session 927124: interface 13720413 failed: VALIDATION ERROR HAPPENED!
Session 927124: [end wip_massload_pub.massLoadJobs]
Session 927124: return status: E

STEPS

The issue can be reproduced at will with the following steps:
1. Release a Planned Order from the Supply Chain Workbench to create a discrete job.
2. WIP Mass Load Fails with error.


Changes

 

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