My Oracle Support Banner

When Copying Recipe With Text Sometimes Receive Error "FRM-40735: KEY-DUPREC Trigger Raised Unhandled" (Doc ID 1632348.1)

Last updated on APRIL 03, 2019

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Product Development Recipes

When attempting to copy some recipes with text
the following error occurs.

ORA-01403: no data found
FRM-40735: KEY-DUPREC trigger raised unhandled exception ORA-06502

followed by:
FRM-41072: cannot create GRUP text_query

followed by:
FRM-41086: Error populating Group

followed by:
FRM-41085: Error getting Group Row count

The issue can be reproduced at will with the following steps:
1. Formulator responsibility
Select Recipes
Query recipe with text
Copy it

The issue has the following business impact:
Due to this issue, users having issues creating new recipe version when  need to keep the same text associated with the recipes.


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.