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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
266 views