Documenting APEX Applications, Part 1 — From Metadata to Markdown A page acquires another validation, a button changes its behavior, and a process starts calling a different routine. The application keeps moving. A separate document only reflects those changes if someone remembers to update it. For this project, I wanted to see how much of…
Order 42 failed at checkout. The total was BRL 129, and no integration response was recorded. Support’s proposed explanation was simple: the integration had never been called. That explanation turned out to fit this attempt. The empty response log was not what established it. The Incident Is the Prompt followed an exception to an input…
The buyer clicked Place order once. The application returned two purchase references: Order #21 and Order #22, each for BRL 2,098. Both were confirmed. Neither looked like a failed transaction. In The Incident Is the Prompt, an exception gave the investigation a starting point. Here, success was the symptom. Before looking for a faulty line,…
For this series, I want to explore AI beyond writing code: using those same tools to understand what happened when an application does not behave as expected. The work between a screenshot and a diagnosis involves finding the execution, connecting its records, and deciding where to inspect the code. An early assumption can send that…
I have spent enough time reviewing enterprise applications to know that the first successful run is rarely the difficult part. The difficult part begins later, when someone has to explain why a user can see a page, where a secret is stored, which code changes data, how a session value arrived there, and what must…
There was a point when one of my report queries stopped returning only business data. It also decided which CSS class represented an error, assembled pieces of HTML, omitted empty messages, and formatted small lists of labels. The report still worked, but the SQL had quietly become part query and part user interface. I love…
An Oracle APEX service-candidate search that keeps the 384-number embedding behind the application boundary.
In March 2025, I earned the Oracle AI Vector Search Certified Professional certification. I studied vector fundamentals, embeddings, similarity search, and vector indexes. The concepts made sense, but I kept looking for small, practical places to use them. ORDS gave me another one. With the automatic vectorSearch endpoint in AutoREST, I could take those concepts out of the study…
I had been waiting for my Oracle APEX environment on OCI to be updated to version 26. This week it finally happened. So, to celebrate properly, I decided to build a small field-style demo around one of the features that immediately caught my attention in this release: native AI Agents in Oracle APEX. The interesting…
Most of the time, when I build an APEX page, I try to stay inside the declarative model for as long as the page still feels honest. Native regions, template components, lists, cards, reports, buttons, dynamic actions, and Universal Theme options are usually easier to maintain because they remain visible in the Builder and other…