I have a simple ADF app with a read only table. When I run the page I get an "Access Denied" error. I can successfully query the table from SQL developer and retrieve rows. I can successfully connect to the table using the AppModule and read rows. Any ideas????
I get the exact same problem. The really frustrating part is that I've created these as jsff fragments. Each fragment contains a simple read only table. Drag one jsff onto a jspx and then run the jspx. Poof. Access denied. To make matters even more frustrating, these EXACT SAME jsff fragments were rendering just fine in a different jspx file within the same project and the only difference between the jspx files that I can see is the name!
The trick of putting the jsff into a task flow and putting the task flow into a region in the JSPX worked. Having spent far too many hours on this I can only temper my enormous frustration and say this is just one more thing to pile onto the JDeveloper learning curve.
To answer the question about the type of application, it's a Fusion Web App connected to a database via entity objects. The really odd thing is that it worked for the first jspx, but not the second one. Those are the things that just make this tool so frustrating.
I'm happy to hear the issue is resolved.
We do mention this in the doc http://docs.oracle.com/cd/E16162_01/web.1112/e16182/taskflows_regions.htm#CIHBCHBH:
"You must nest a page fragment that you include in another JSF page within a region (af:region tag). A bounded task flow that you add to a JSF page as a region cannot call pages; it must call page fragments."
One other advantage of using the taskflow wrapper is that you can now parametrize the interaction with your region through the taskflow interfaces - which leads to better reusability later on.