Transaction Failed Completion Giving Error For Jobs With Project And Task Assigned

(Doc ID 2001026.1)

Last updated on OCTOBER 27, 2016

Applies to:

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



Find while Completing a WIP job which has Project and Task assignment through MSCA forms (both Move and Complete and Complete), client is facing the following error:

" Transaction Failed. Negative Balances are not allowed Transaction Processor Error "

This error is then followed by a second error :

"Transaction failed. There is a mismatch between the current location of the serial number provided and the FM_OPERATION_SEQ_NUM and FM_INTRAOPERATION"


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

1.MSCA > Move & Complete [Organization 001]

2.Enter SN/Job/Assembly/Sequence/Project/Task/Sub/Loc

3. Encounter Error above.

4. Important Note: Customer is able complete the same WIP jobs using MES Forms.

5. Also, if NO project or task are entered, the issue does NOT exist. It works fine.

6. The issue is seen for ALL projects (including newly created ones).


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