My Oracle Support Banner

Product Development Mass Search And Replace Completes With Warning, No Formulas Updated, Log File Shows "Update of Ingredient : XXX in FORMULA : YYY, Version : 1 Failed (ORA-01403: no data found)" (Doc ID 2406041.1)

Last updated on MAY 31, 2018

Applies to:

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

Symptoms

On : 12.2.7 version, Product Development Mass Search And Replace

When attempting to replace one ingredient with another using Mass Search and Replace under Formulator, the concurrent program completes with warning and the concurrent log file shows errors like the following:

ERROR
-----------------------
About to perform replace of FORMULA , Name / Version = YYY / 3 , Column updated = INGREDIENT
Please Note: This formula that is currently selected for modification is used in one or more recipes.
Update of Ingredient : XXX in FORMULA : YYY, Version : 1 Failed (ORA-01403: no data found).


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the Product Development Mass Search and Replace (Formulator > Mass Search and Replace
2. Attempt to replace one ingredient with another in Formulas

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update formulas using Mass Search and Replace.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.