My Oracle Support Banner

Display Of Any Numeric Fields Turns To Pound Signs (####) and/or FRM-40654 After Commit/Post In Forms 12c (Doc ID 2190303.1)

Last updated on APRIL 02, 2019

Applies to:

Oracle Forms - Version and later
Information in this document applies to any platform.


After migrating to Forms 12c, the display of any numeric fields turns to pound signs (####) after a commit or post when running any form.

Along with this behavior, you may even see error:

FRM-40654: Record has been updated. Re-query block to see change.

Problem started only after upgrading to Forms 12.2.1. The previous release worked fine.

The pound (#) sign issue goes away if you change the "DML Returning Value" property to "No".


 Upgrade to Forms 12c.


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.