“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.
AbheekG
11 December 2019 - 3:41 pm
Any resolution to this?
Jeffrey Kemp
11 December 2019 - 3:47 pm
Yes, apply the patch mentioned in the article.
MAHENDRA
19 January 2020 - 11:11 am
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
Jeffrey Kemp
21 January 2020 - 9:22 am
Hi Mahendra, did you apply the patch?
Jane
12 June 2020 - 2:45 am
I am getting this on Apex 19.2 when I try to add a button to a region.
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
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
Jeffrey Kemp
19 June 2020 - 7:19 am
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.
s kola
20 November 2020 - 6:59 am
i am using an oracle apex workspace how do i get around this error, i am going crazy.
Jeffrey Kemp
20 November 2020 - 7:30 am
Hi s kola – have you had the patch installed?
Carlos Ortega
16 September 2022 - 12:52 am
You need to switch on an item as pk in source section.
Nivaldo batista
23 August 2023 - 5:30 pm
como resolver esse tipo de erro:No Primary Key item has been defined for form region CADASTRO DE FUNCIONARIO
Nivaldo batista
23 August 2023 - 5:33 pm
como resolver _No Primary Key item has been defined for form region CADASTRO DE FUNCIONARIO