My Oracle Support Banner

Text Entered In Recipe Steps Into Recipe Designer Not Available As Text Code In GMD Tables, and Line Breaks Not Handled Consistently (Doc ID 2346338.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


On : 12.2.5 version, PD Receipe Designer

There is an Inconsistency in how text works in Recipe Designer vs Forms such as Recipe Details, Routing Details, Formula Details. Recipe Designer always seems to store the text using paragraph code PI (in fm_text_tbl), even if no paragraph with that name has been set up at all, let alone for the specific table involved (fm_rout_dtl, gmd_recipe_routing_steps, fm_matl_dtl). Therefore, if you enter text for a routing step, recipe step, or material line on Recipe Designer, it is not viewable from the Recipe Details or Routing Details or Formula Details forms unless you create a paragraph code PI for the appropriate tables.

It also does not seem to matter what value is entered for the Process Instruction Paragraph parameter on Product Development Parameters.

There was also a second issue that became apparent when this first issue was fixed. Line breaks entered in the text in the Recipe Designer were not displaying as line breaks when viewed in Edit Text from the standard forms.

Expect that when navigating to Edit Text on Recipe Designer, either:
A. The same paragraphs will be available there as on Recipe Details, Routing Details, and Formula Details forms, depending on exactly what entity you are entering text for (routing step, recipe step, formula ingredient, etc.) (per bug 26380947, this may not be feasible or desireable), or:
B. The paragraph set up as the Process Instruction Paragraph on Product Development Parameters will be used, instead of a hardcoded 'PI'.

The issue can be reproduced at will with the following steps:
1. Open Recipe Designer
2. Select either Recipe, Formula, or Routing tab
3. Drill down and click on either a step or an ingredient/product/byproduct.
4. Navigate to Actions > Edit Text.

The issue has the following business impact:
Due to this issue, users cannot see text entered on Recipe Designer anywhere else.


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.