When I selected the top list-entry for one of my tables which had a corresponding ALTER grant, the wizard never created the built-in page process to add/update records. I tried it again and selected the last entry which appears to be associated with the UPDATE grant and it created the Save Interactive Grid Data page process.
We are in the same boat: Oracle eBusiness Suite with ApEx 5.1.2. I must agree that the number of times a table appears in the list matches the number of grants. We do 'grant all' which creates 11 grants.
P.S. It is not a good idea to have APPS as the parsing schema. There is a white paper how to integrate ApEx with eBS; it recommends to have a separate parsing schema for ApEx applications with minimum required data access.
You are hitting bug 26407890, which has been addressed for our upcoming 5.1.3 patch release. This query has already been raised in the following threads:
In the meantime, ensure you select the 1st occurrence of the object name in the list, for each of your selections.
Thank you. We actually used the white paper when setting our environment up. We originally had separate parsing schema, but it quickly became overwhelming to manage all of the explicit grants necessary for our projects. Perhaps we will revisit that someday.
Thank you! I tried searching multiple times, but my search terms weren't finding anything.