How to Build a Search Panel in Oracle Forms
Let users find records by any mix of criteria in Oracle Forms 14.1.2, with a WHERE clause built from bind variables instead of typed values.
AI-Assisted
Posts tagged AI-Assisted are created with support from artificial intelligence. I use AI tools to research, draft, and refine ideas—combining human insight with machine precision to deliver clear, informed, and creative content.
How to Use the Oracle Forms Java API
Inventory, change, and build Oracle Forms 14.1.2 modules from Java with JDAPI, and add what Forms Builder would have added for you.
How to Automate Oracle Forms Builds from the Command Line
Compile a whole Oracle Forms 14.1.2 application in the right order from a script, and keep forms as XML to see every change.
How to Upgrade Oracle Forms Applications to 14.1.2
Move Oracle Forms applications from older releases to 14.1.2: what changed, the upgrade steps, the Migration Assistant, and RP2RRO.
How to Secure Oracle Forms Applications
Identify users, keep secrets on the server, and close the common holes of an Oracle Forms 14.1.2 installation, with a security checklist.
How to Trace a Session with Forms Trace in Oracle Forms
Record user actions, triggers, built-ins, and SQL of an Oracle Forms 14.1.2 session with Forms Trace, and read the trace with Xlate.
How to Manage an Oracle Forms Production Domain
The full Oracle Forms 14.1.2 domain in production: its servers, the start order, maintenance without cutting users off, and the logs.
How to Set the Oracle Forms Runtime Environment with default.env
The environment of the Oracle Forms 14.1.2 runtime process: default.env variables, several environment files, and every other config file.
How to Configure formsweb.cfg in Oracle Forms 14.1.2
How an Oracle Forms 14.1.2 application reaches its users, and how formsweb.cfg sections, URL rules, and parameters control it.
How to Reduce Round Trips to the Forms Server
What each user action sends to the Oracle Forms 14.1.2 server, why a clock is expensive, and how to start faster and serve more users.
How to Reduce Database Round Trips in Oracle Forms
Real measurements from Oracle Forms 14.1.2: what POST-QUERY lookups cost, and how array sizes cut 4,149 database round trips to 19.
How to Run Oracle Reports from a Form Using RUN_REPORT_OBJECT
Report objects, RUN_REPORT_OBJECT, job status, output, and security: running Oracle Reports 14.1.2 from an Oracle Forms 14.1.2 form.
How to Create a Report with Oracle Reports 14.1.2
Oracle Reports 14.1.2 for Forms applications: the domain it needs, the Report Wizard, reports as XML, rwrun, rwservlet, and PDF fonts.
How to Generate REST Packages Using the REST Package Designer in Oracle Forms
Turn an OpenAPI document into PL/SQL with the REST Package Designer of Oracle Forms 14.1.2, then call the generated packages from a form.
How to Call REST Services from Oracle Forms
GET and POST JSON from Oracle Forms 14.1.2 with the new FHTTP and FJSON packages, with status codes, errors, and credentials.
How to Connect a Form to a Web Page Using JavaScript in Oracle Forms
WebSocket JavaScript integration in Oracle Forms 14.1.2: run JavaScript in a web page from a form, and raise form events from the page.
How to Add Java Beans to Oracle Forms
Java beans in bean areas, pluggable Java components, and FBEAN in Oracle Forms 14.1.2, with properties, events, and JAR deployment.
How to Work with Client Files Using WebUtil in Oracle Forms
Reach the user's computer from Oracle Forms 14.1.2 with WebUtil: setup, file dialogs, client images and text files, transfers, and security.