My Oracle Support Banner

Autocreate Final Assembly Orders, WICDOL, Fails to Create Works Orders with Message of Failed in wip_massload_pub.massLoadJobs (Doc ID 1056566.1)

Last updated on JANUARY 01, 2021

Applies to:

Oracle Configure to Order - Version 12.0.4 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
***Checked for relevance on 18-Apr-2013***
Executable:WICDOL - AutoCreate Final Assembly Orders
CTOWIPWB.pls and version 120.11.12000000.2

***Checked for relevance on 9-JAN-2015***


WICDOL - AutoCreate Final Assembly Orders fails to create work orders and gives the following messages in the log file:

WICDOL module: AutoCreate Final Assembly Order
Calling CTO_WIP_WRAPPER.get_order_lines
Return status from CTO_WIP_WRAPPER.get_order_lines:1
Group_Id from CTO_WIP_WRAPPER.get_order_lines: -1
Calling wip_massload_pub.massLoadJobs with group Id: -1
Returned from wip_massload_pub.massLoadJobs:
Failed in wip_massload_pub.massLoadJobs.

AUTO CREATE FINAL ASSEMBLY ORDERS does not link WIP job to sales order.  Therefore sales
order cannot be picked and shipped. Can manually associate sales order to WIP job.

The issue can be reproduced at will with the following steps:

1.Enter a Sales order for Item#CENT,enter configuration and book the order.

2.Autocreate configuration item.

3.The configured item will be in supply eligible status.

4.Run " Autocreate Final Assembly" request.
Request ends in warning.   WIP Job is not linked to sales order.


The issue occurred after ct loaded patches.
This may be due to the changes made in <Bug:6146803>.


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

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