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 FEBRUARY 03, 2019
Applies to:Oracle Work in Process - Version 126.96.36.199 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***
On 188.8.131.52 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
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