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!

Excel Parse , Validate and Load to table using Collections

Arun N-OCJun 29 2025

Hi,

I have a requirement to create a simple app for a group of internal users to upload an .xlsx file , validate the input data , provide a user review region/page and submit to target database table.

For this have create singe page with 2 regions - 1 for the file upload/browse which parses and loads data to a collection and the 2nd regions which validates and displays the data in an IR or IG. user will click on Submit once all records are VALID which would verify this is the case and insert the collection object to the target table.

The file browse is a required input however after the upload action the value gets cleared. So on submit action it pops an error that the file input is required. Please advise how to prevent this from happening and allow the flow to continue.

Apex ver 24.2

Thanks,

Arun

Comments
Post Details
Added on Jun 29 2025
6 comments
147 views