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!

Form on REST Data Source occasionally returns no data found error (but there's no local data)

Carey AJun 6 2022

I created an interactive report and form on a REST data source using APEX's page builder tools. On some rows, I will get a no data found error. Normally this would mean the PK was not found in the local table, but I'm not using any tables. Or it could mean the PK isn't getting passed to the form page, but I've confirmed that it is being passed over via the debug tools. The vast majority of rows work as expected, but a handful of rows consistently return this error. In Postman, these records work as expected, so I don't think there's anything wrong with the source data, which is a Shopify website. These records also work fine on Shopify itself. I've manually compared the rows that work to the rows that don't, and can't see anything wrong. The backtrace on the no data found error sends me to APEX code (see pic).
Has anyone seen this before and solved it? This is version 22.1.0.
Screen Shot 2022-06-06 at 12.22.13 PM.png (815.05 KB)Screen Shot 2022-06-06 at 12.24.45 PM.png (196.32 KB)Screen Shot 2022-06-06 at 12.25.33 PM.png (290.38 KB)

Comments
Post Details
Added on Jun 6 2022
9 comments
1,344 views