Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms 12.2.1.19.0 and sysdate / $$DBDATE$$

jabraga98May 5 2025

With our upgrade to this version of forms we cannot reference $$DBDATE$$, $$DBDATETIME$$ as the intital value of a item or reference sysdate until the form is fully intialized. If we attempt to reference it will provide this error:

FRM-40513 : ORACLE ERROR: unable to get date/time from database.

FRM-41829: Record not created.

Then then form just exists. Why is this happening? Our only method start the form using another “block” and once initiaized doing a clear_block / go_block of actual block.

Comments
Post Details
Added on May 5 2025
5 comments
312 views