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.


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 to

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

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.


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


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.