“No Primary Key item has been defined for form region”

Otherwise reported as “WWV_FLOW_FORM_REGION.NO_PRIMARY_KEY_ITEM” or merely “Internal error”, this bug caused me to waste hours of investigation, twice, because a simple Google search was not returning any results. This post is merely to remedy that situation.

On an APEX 19.1 page with a new Form region combined with an Interactive Grid region, when the user makes a change to a record and Submits the page, they get this error.

This is caused by bug 29612553 – FORM REGION DML PROCESS THROWS INTERNAL ERROR WHEN INTERACTIVE GRID DML PROCESS IS ON THE SAME PAGE and fixed by APEX patch 29369869.


Comments

  1. Any resolution to this?

  2. ORACLE APEX BELOW ERROR OCCURED DURING SAVING ;
    ****************************************************
    1 ) No Primary Key item has been defined for form region
    EDITING_EMPLOYEE NO.

    2) NO DATA FOUND 1403

    HOW TO RESOLVE IT ABOVE ERROR AND MAIL ME ON MY EMAIL ID

    THANKS

    MAHENDRA
    9820401229 ONLY ON SAT-SUN

  3. I am getting this on Apex 19.2 when I try to add a button to a region.

  4. Mohammad Namazi
    17 June 2020 - 1:31 am

    Hi Jeffrey,

    Just wanted to say thanks. I ran the patch script and the issue went away immediately. Saved me a lot of searching for issues.

    Mohammad

  5. Sammeer S Raawat
    19 June 2020 - 12:50 am

    Hi Jeff,

    How can I get the patch without logging in?

    Please note I am use XE version of DB.

    Regards

    Sammeer

    • Unfortunately, the free version XE does not come with patch support. Hopefully a new version of XE will be released, possibly within the next 6 months.

Leave a Reply

Your email address will not be published / Required fields are marked *