My Oracle Support Banner

When Modifying Text on a Formula Receive Errors: "ORA-03123: Operation Would Block" and "ORA-01403: No Data Found" (Doc ID 2925582.1)

Last updated on FEBRUARY 02, 2023

Applies to:

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

Symptoms

When modifying existing text on a formula using Edit Text function the below errors occur.
This worked correctly before applying patches which upgraded the file version SYTXTSEL.fmb from 12.0.14.12020000.4 to 12.0.14.12020000.5.


ERROR
-----------------------
ORA-03123: Operation would block
ORA-01403: no data found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation --> Formulator -- > Formulas
2. Query Formula
3. Click on the Menu, Actions --> Edit Text
4. Click on General Text
5. Click on Edit Text button
6. Errors occur and then text editor screen is displayed.


Changes

 Form SYTXTSEL.fmb version during patching was upgraded from version 12.0.14.12020000.4 to version 12.0.14.12020000.5

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.