Friday, February 10, 2012

ERR-1002 Unable to find item ID for item... after branching to page

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

Can't find why Apex 4.0 is returning the following error?


If you copy and paste the error message into a fixed-width text editor, you'll will hardly notice that there is an extra space between the first double quotes and the name of the item, that I highlighted in red color.

Unexpected error, unable to find item name at application or page level.
Error ERR-1002 Unable to find item ID for item " P33_LOCATION_ID" in application "21673".

When I inspected the branch action, I realized that I had inserted a blank between the comma and the item name in comma separated list of items and this breaks the toy.


Clearly item names are not trimmed by the internal PL/SQL function that does the splitting, so watch out for the extra blanks, they can drive you mad for a while.
I could not check yet if this happens in Apex 4.1.

5 comments:

Anonymous said...

It is always the little things isn't it? Thanks you saved my bacon on troubleshooting this error!

Anonymous said...

Thanks so much, just wasted an hour trying to find the cause of this problem! Just a simple space in the item name...

Anonymous said...

Thank you, thank you, thank you!!! :D I've been going mad for hours. U really made my day.

Anonymous said...

Thank you so much, I've just decided to recreate APEX Pages from scratch - but you saved one day of my life!

Anonymous said...

Thanks! Saved a lot of time for me today in Apex 5...Kudos!

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles