Skip to Main Content
Forums

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!

Tabular region not finding changed rows to update

reidsterMar 15 2016 — edited Mar 16 2016

I have a tabular region that is not allowing any updates to go through because it appears that it is not detecting that the row has indeed changed.

This page used to work very well.  I'm not sure when this started to fail.  And, I'm not sure how to debug this since the debug info is very vague.

I'm using APEX 5.0.1.00.06

Any input is greatly appreciated.

Thanks,

Reid

"No primary key values were supplied, at least one row must be supplied for updates to occur"

Here is a snippet of the debug output.

0.026650.00028
......display_location: ON_ERROR_PAGE
2

6%

0.026930.00029
......is_internal_error: true
2

6%

0.027220.00029
......apex_error_code: APEX.TABULAR_FORM.MRU.NO_PRIM_KEY_VALS
2

6%

0.027510.00028
......error_backtrace: ----- PL/SQL Call Stack ----- object      line  object handle    number  name 0x20c353760       642  package body APEX_050000.WWV_FLOW_ERROR 0x20c353760       710  package body APEX_050000.WWV_FLOW_ERROR 0x20c353760      1014  package body APEX_050000.WWV_FLOW_ERROR 0x206734bc0      2751  package body APEX_050000.WWV_FLOW_ITEM 0x206734bc0      3707  package body APEX_050000.WWV_FLOW_ITEM 0x207f97aa0       451  package body APEX_050000.WWV_FLOW_PROCESS_NATIVE 0x207f97aa0      1130  package body APEX_050000.WWV_FLOW_PROCESS_NATIVE 0x20d1c2ae0      2017  package body APEX_050000.WWV_FLOW_PLUGIN 0x207fb1a30       188  package body APEX_050000.WWV_FLOW_PROCESS 0x207fb1a30       428  package body APEX_050000.WWV_FLOW_PROCESS 0x20cc2b4d8      6802  package body APEX_050000.WWV_FLOW 0x2077948d0        35  anonymous block
2

6%

0.027790.00028
......component.type: APEX_APPLICATION_PAGE_PROCESS
2

5%

0.028070.00029
......component.id: 17620645992357144
2

6%

0.028360.00022
......component.name: ApplyMRU
2

4%

0.028580.00010
...Show Error on Error Page
4

2%

0.028680.00154
......Performing rollback
4

33%

0.030220.00466
Show page template header
4

99%

0.034880.00092
Rendering form open tag and internal values
4

19%

0.035800.00072
Processes - point: AFTER_ERROR_HEADER
4

15%

0.036520.00006
Processes - point: BEFORE_ERROR_FOOTER
4

1%

0.036580.00004
Show page footer
4

0%

0.036620.00005
Show page tempate footer
4

0%

0.036670.00184
Rendering form close tag and page checksum
4

39%

0.03851-
Logging exception in final_exception_handler: Sqlerrm: 
ORA-20987: APEX - No primary key values were supplied, at least one row must be supplied for updates to occur - 
Contact your application administrator. Details about this incident are available via debug id "69776". Backtrace: 
ORA-06512: at "APEX_050000.WWV_FLOW_ERROR", line 964 ORA-06512: at "APEX_050000.WWV_FLOW_ERROR", line 999 
ORA-06512: at "APEX_050000.WWV_FLOW_PROCESS", line 547 ORA-06512: at "APEX_050000.WWV_FLOW", line 6802
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2016
Added on Mar 15 2016
#apex-discussions
3 comments
1,143 views