Skip to Main Content

APEX

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!

Show Form Region After Button Click with Pre-Filled PK

Inês ToméJul 14 2025

Hi everyone,

I have a page in my APEX app (Page 2) that includes a form region.

This form has a server-side condition based on the primary key :P2_PER_ID, so it only appears when there is a corresponding record in the PERSONS table.

When there’s no record (i.e., :P2_PER_ID is null), I show an alternate static region instead.

This static region includes a button that should allow the user to start creating a new record.

Here’s what I want to happen:

  • When the user clicks the button:
    • The static region should disappear.
    • The form region should appear.
    • The PER_ID should already be set from the page item P2_PER_ID_PRINCIPAL
    • The rest of the form fields should be blank, ready for input.

Here’s what I’ve tried so far:

  • The button sets the value of PER_ID using a “Set Value” action.

  • Then I added a “Refresh” action on the form region.

But the form still doesn’t appear, and the static region doesn’t hide either.

Has anyone implemented something similar or knows what I might be missing?

Thanks in advance for your help!

Comments
Post Details
Added on Jul 14 2025
4 comments
77 views