I have a series of pages linked when creating a new user through my Apex app. The first collects general user information, the second prompts the user to select an application, and each application will lead the user to an app-specific attributes form.
The first two pages work fine, but the app-specific forms are giving me trouble.
- The “hand-off” from page 1 to page 2 passes a USERID and EMAIL values.
- Page 2 writes to an table with the user's USERID and app name selected
- When an app matching ‘smi’ is selected, there is a branch tied to that condition that directs the user to the ‘Add SMI’ form and it passes USERID and EMAIL values
- The ‘Add SMI’ form is supposed to populate, but I'm getting an error: ORA-01403: no data found
The debug points to my Initialize form Add SMI component as the source of the error (see screenshot below).
As I understand it, when a form initialization process runs, it takes the primary key and uses it to search a table for a row matching that user. If it finds one, it populates the form with the values from the table. If no row is found, it fails.
In my case, there shouldn't be a row because that's what the form is for.
I'm just confused because Page 2 has a form initialization process that works flawlessly. Also, there are app-specific pages with the same form initialization process that works fine.
The Initialize Form process is set to run Before Header and I haven't made any changes to the default values in the process.
Is there a better way to get my data from one form to the next?
Build 24.2.7
Schema compatibility 2024.11.30
Patch version 7
