
How to Lock a User Account After Failed Login Attempts in Oracle APEX
Use the built-in lockout, build a failed counter and lock time for custom accounts, and add an administrator page that unlocks them.
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.

Use the built-in lockout, build a failed counter and lock time for custom accounts, and add an administrator page that unlocks them.

Fill application items once after login with After Authentication computations, use them in titles and queries, and block changes from the URL.

Upload many pictures into a BLOB table, show them in a Cards grid and a Carousel Container, open them in full size and reject files that are not images.
Show initials, photos and colored status badges from query columns with the Avatar and Badge template components, and handle missing photos and invalid states.

Show FAQ answers as collapsible details elements in a classic report, group them by category, add a search field, and keep stored HTML from running code.

Build a three-dot Actions menu on Content Row reports, show entries by status and role, run PL/SQL without a reload, and confirm before deleting.

Build a tracker from a dynamic list query and the Wizard Progress template, move records to the next step, and show cancelled records in red.

Store per-user page views in one table with a MERGE in a Before Header process, and show each user's last 10 viewed records with a classic report in Oracle APEX.

Store per-user favorites in one table, toggle a star in each report row with an Ajax Callback, and filter the report to the current user's favorites in Oracle APEX.

Store per-user notifications, show the unread count on a navigation bar bell, list them in an Inline Drawer and mark them as read with Ajax in Oracle APEX.

Store announcements with start and end dates, show them on every page from the Global Page with the Alerts template, and let each user dismiss them in Oracle APEX.

Add per-user and shared counts to the side navigation menu with restricted application items, Before Header computations and square-bracket labels in Oracle APEX.

Cache a shared summary and a per-user list with Server Cache, show the cache date, purge it with APEX_REGION, and avoid cached buttons in Oracle APEX.

Turn on Lazy Loading for a slow report, compare page load times before and after in the activity log, and see what a failing lazy region shows in Oracle APEX.

Add date pickers that refresh a chart and a report, a chart type switch that keeps the user's choice, and checks for wrong or forged ranges in Oracle APEX.

Build an Oracle APEX line chart that compares each month with the same month last year, with percentage tooltips, a fair current month and empty months shown as 0.

Show counts by weekday and hour as a colored grid in Oracle APEX, with every empty hour shown as 0, a legend, a channel filter and checks against SQL.

Build an Oracle APEX combination chart with actuals as green or red bars and the monthly target as a line, with filters and months without data shown as 0.