Unable to complete a job in Completion Transaction Form - error: ORA-01403: no data found FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502 (Doc ID 843590.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Work in Process - Version 11.5.10.2 to 12.0.4 [Release 11.5 to 12]
Information in this document applies to any platform.
***Checked for relevance 15-JUL-2012***
***Checked for currency 31-Dec-2013***

Symptoms

On 11.5.10.2 and in 12.0.6 in Production:
When attempting to perform WIP completion transactions in Completion Transaction Form, the
following error occurs:

ORA-01403: no data found
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502

The issue can be reproduced at will with the following steps:
1. Work in Process Superuser => Material Transaction => Completion Transaction

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