My Oracle Support Banner

Records Stuck in Work Order Transaction Interface tables (Doc ID 2762712.1)

Last updated on AUGUST 20, 2023

Applies to:

Oracle Fusion Manufacturing Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Work Orders

Work order material transaction and work order resource transaction and work order operation transaction still reside in the manufacturing interface tables;
When end user try to close the work order the following error is prompted :

JOP278973 : You can't update to Closed status if pending transactions exist. Purge the stuck or pending transactions. Also, check for corrections in the import process. (WIE-XXXXXXX)

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

Production planner release the work orders from planning ;

Work orders are created with Unreleased status ;
The store change the status to release ;
Then Execute ;

When Requested quantity is completed automatic the completion of the work order –completed status

Search the work order in Manufacturing workbench
Click on Mass Action
Choose Close option
Close date: 28.2.2021
Click ok

The issue has the following business impact:
Due to this issue, users cannot close work orders


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.