My Oracle Support Banner

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 FEBRUARY 18, 2019

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 <number>: Error in Valid_Req_subinvlocator,inventory_item_id=<inventory_item_id>

Session <number>: Error in Valid_Req_subinvlocator,error_tbl(indx).error_msg=WIP_JDI_INVALID_SUBINV;interface_id=<interface_id>

Session <number>: wip_operations

Session <number>: Op Seq <seq1> FUSD <date1> FUCD <date1> LUSD <date1> LUCD <date1>

Session <number>: Op Seq <seq2> FUSD <date1> FUCD <date2> LUSD <date1> LUCD <date2>

Session <number>: wip_operation_resources

Session <number>: Op Seq <seq1> Res Seq <seq1> St Dt <date1> Cm Dt <date1>

Session <number>: Op Seq <seq1> Res Seq <seq6> St Dt <date1> Cm Dt <date1>

Session <number>: Op Seq <seq1> Res Seq <seq7> St Dt <date1> Cm Dt <date1>

Session <number>: Op Seq <seq2> Res Seq <seq4> St Dt <date1> Cm Dt <date1>

Session <number>: Op Seq <seq2> Res Seq <seq210> St Dt <date1> Cm Dt <date1>

Session <number>: error:WIP_WEI_IGNORED (INTERFACE=<interface_id>)

Session <number>: error:WIP_WEI_IGNORED (INTERFACE=<interface_id>)

Session <number>: error:WIP_WEI_IGNORED (INTERFACE=<interface_id>)

Session <number>: error:<interface_id> : System cannot change/delete the following material requirement because the requested job/operation/inventory_item_id_old combo does not exist:

job (job_name): <job_name>

job id (wip_entity_id): <wip_entity_id>

operation (operation_"

Session <number>: error:<interface_id> :Invalid or insufficient component subinventory/locator information for inventory_item_id <inventory_item_id> and subinventory MATERIAL

Session <number>: error:<interface_id> : Job load failed because there were errors loading the job details. Please check the job detail error message.

Session <number>: Session <number>: ended on <date timestamp>

Session <number>: Session <number>: started on <date timestamp>

Session <number>: interface <interface_id> failed: VALIDATION ERROR HAPPENED!

Session <number>: [end wip_massload_pub.massLoadJobs]

Session <number>: 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.


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
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.