I created a page (P502) that displays a tabular form with a query that is filtered based on page items in which the user sets the value using a drop down box. The tabular form was created from scratch and not the wizard because I need to do custom processing. The form is based off a staging table used to hold data before it is uploaded to the main tables. P502 is where the user fixed errors found in the data. On a previous page (P500) a PL/SQL script checked for errors (mostly allowable value and null checks) and logged them in 2 columns within the staging table. The first column stores the columns within the staging table where the errors were found delimited by a :. The second column stores the custom error messages delimited by a :. On P502 I use these columns to determine which columns to show in the tabular form, if a column didn't have an error it isn't shown. I have also created 2 additional columns in the tabular form for each column of data in the staging table. The first one is used to show suggested values if the error was an allowable value error. The second is where the user chooses the new value which is usually a drop down box displaying the allowable values they can choose from.
The issue I am having is running the custom process I created. I created a process (PL/SQL Code type) that updates the staging table columns with the data the user input. The issue I am having is that it won't execute the process because when it goes to run the process APEX doesn't recognize the tabular from as having any rows.
When I debug the page this is what I get :
| 0.02372 | 0.00012 | ...Process "Run Process Tab From" - Type: NATIVE_PLSQL | 4 | 4% |
| 0.02383 | 0.00004 | ......Skip because tabular form doesn't contain rows | 4 | 1%
|
Any ideas on why it is not recognizing the rows. I have tried an Execution Scope of both All Submitted Rows and For Created and Modified Rows but neither one works. Any ideas or insight would be greatly appreciated.
Caveats:
- I'm using APEX 5.0 and not 5.1.
- I can't use the native APEX upload process because it doesn't allow for error checking/fixing and the file I am trying to upload exceeds the column limit allowed by APEX.