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

Last updated on JULY 14, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Product Development Recipes

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

ERROR
-----------------------
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


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

BUSINESS IMPACT
-----------------------
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.

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