Project Analytics supports security over following dimensions in Project Billing and Revenue subject areas. In Oracle BI Applications, the 'Business Unit' entity refers to 'Operating Unit Organizations' in E-Business Suite.
The list of Business Units that a user has access to is determined by E-Business Suite grants.
Project Billing & Revenue FactsDimension Used For Securing | Billing | Revenue | Contract | Funding | Cross Charge- Receiver | Cross Charge - Provider | Cross Charge - Invoice |
---|---|---|---|---|---|---|---|
Project Business Unit |
Y |
Y |
N |
Y |
Y |
N |
Y |
Project Organization |
Y |
Y |
N |
Y |
Y |
N |
Y |
Expenditure Business Unit |
N |
N |
N |
N |
N |
Y |
N |
Contract Business Unit |
Y |
Y |
Y |
Y |
N |
N |
N |
Project |
Y |
Y |
N |
Y |
Y |
Y |
Y |
Resource Organization |
N |
N |
N |
N |
N |
N |
N |
Ledger |
N |
N |
N |
N |
N |
N |
N |
Initialization Blocks
To apply data security filters, enable the appropriate initialization blocks depending on the deployed source system.
Note:
On installation, initialization blocks are enabled for E-Business Suite R12. If you are deploying on a source system other than E-Business Suite R12, then you must enable the appropriate initialization blocks.
Enable data security for Project Billing and Revenue in E-Business Suite by enabling the initialization blocks listed below based on the E-Business Suite adaptor. If only one source system is deployed, then you must make sure that all Project Security initialization blocks for other adapters are disabled. If more than one source system is deployed, then you must also enable the initialization blocks of those source systems.
For R11x
Expenditure Business Unit List EBS11x
Project Business Unit List Funding EBS11x
Project Business Unit List Invoice EBS11x
Project Business Unit List Revenue EBS11x
Project Contract Business Unit List EBS11x
Project Contract Business Unit List Invoice EBS11x
Project Contract Business Unit List Revenue EBS11x
For R12
Expenditure Business Unit List EBSR12
Project Business Unit List Funding EBSR12
Project Business Unit List Invoice EBSR12
Project Business Unit List Revenue EBSR12
Project Contract Business Unit List EBSR12
Project Contract Business Unit List Invoice EBSR12
Project Contract Business Unit List Revenue EBSR12
For both R11x and R12
Project List Funding EBS
Project List Invoice EBS
Project List Revenue EBS
Project Organization List Funding EBS
Project Organization List Invoice EBS
Project Organization List Revenue EBS
BI Duty Roles Options
The following BI Duty Roles are applicable to the Project Billing and Revenue subject area.
OBIA_EBS_PROJECT_EXECUTIVE_ANALYSIS_DUTY
OBIA_EBS_PROJECT_MANAGEMENT_ANALYSIS_DUTY
OBIA_EBS_PROJECT_DATA_SECURITY
These duty roles control the subject areas and dashboard content to which the user has access. Additionally, they ensure that the data security filters are applied to all the queries.
To define new groups and mappings for users and BI roles, see How to Define New Groups and Mappings for Users and BI Roles.