About Project Billing and Revenue Security for E-Business Suite

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.