Problems with multi-organisation tables in Oracle Reports
We are migrating from EBS v11 to v12.1.1 and have a number of reports written using Reports Builder (v10.1.2.0.2).Some of these reports use security-context-sensitive tables, e.g.
Our understanding is that these tables operate in a multi-organization context, and so have security applied.
So for example, if you wanted to query PA_PROJECTS using the SQL*Plus command line, you would get no rows returned until you executed "FND_GLOBAL.APPS_INITIALIZE" with appropriate values.
It's also our understanding that logging into EBS gives users executes this initialization and thus provides the necessary context to enable these tables, so providing the user has access to an appropriate responsibility, they can see records from our example table PA_PROJECTS.
- FINANCIALS_SYSTEM_PARAMETERS
- PA_PROJECTS
Our understanding is that these tables operate in a multi-organization context, and so have security applied.
So for example, if you wanted to query PA_PROJECTS using the SQL*Plus command line, you would get no rows returned until you executed "FND_GLOBAL.APPS_INITIALIZE" with appropriate values.
It's also our understanding that logging into EBS gives users executes this initialization and thus provides the necessary context to enable these tables, so providing the user has access to an appropriate responsibility, they can see records from our example table PA_PROJECTS.
0