Skip to main content

Data Access Privilege

NOTE: In accordance with the changes made in Oracle E-Business Suite Release 12, all references to the term “set of books” have been replaced with “ledger” .

Data access privilege allows the Noetix query user or the business intelligence (BI) tool user, who is linked to Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) type (see About Noetix Query Users and Roles) to access data from Noetix views, such as rows from a Noetix view. In NoetixViews, the rows returned by the Noetix views for a Noetix query user is decided based on the row-level security set for the Noetix query user. When row-level security is applied, the Noetix query user's access to data within Noetix views corresponding to a role can be further restricted.

The row-level security consists of organizational unit security and application-specific security. Row-level security is supported in only global forms of the Noetix views for the following Oracle E-Business Suite modules:

  • Oracle Advanced Benefits

  • Oracle Assets

  • Oracle Bills of Material

  • Oracle Cost Management

  • Oracle Depot Repair

  • Oracle Enterprise Asset Management

  • Oracle Field Service

  • Oracle General Ledger

  • Oracle Human Resources

  • Oracle Install Base

  • Oracle Inventory

  • Oracle Master Scheduling/MRP

  • Oracle Order Management

  • Oracle Payables

  • Oracle Payroll

  • Oracle Projects

  • Oracle Purchasing

  • Oracle Quality

  • Oracle Receivables

  • Oracle TeleService

  • Oracle Service Contracts

  • Oracle Time and Labor

  • Oracle U.S. Federal Financials

  • Oracle Work in Process

NOTE: NoetixViews supports only application-specific security for the Noetix views corresponding to Depot Repair, Field Service, and TeleService.

For Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types, the restrictions to access data are applied based on the data access privileges defined in Oracle E-Business Suite. For Noetix query users of the Database User (Type U) type, these restrictions are configured by the Noetix System Administration User (Type N) through Noetix Views Administrator (NoetixViews Administrator). For more information on users and roles, see About Noetix Query Users and Roles.

Row-level security is enforced by global views in the database when a Noetix query user queries data from them. Each global view has an access control list (ACL) that defines the organizational units that a Noetix query can access. These organizational units include business groups, ledgers, operating units, and inventory organizations. When a Noetix query user queries data from global views, global views validate the user and ACL information and enforce the row-level security on the user.

Additionally, data security similar to row-level security is supported in standard and Cross Operations Extension (XOP) forms of Noetix views for Oracle General Ledger and Oracle U.S. Federal Financials. This type of security is also supported in standard form of Noetix views for Oracle Advanced Benefits, Oracle Human Resources, Oracle Time and Labor, and Oracle Payroll.

In Oracle E-Business Suite, an Oracle E-Business Suite user can be assigned multiple General Ledger responsibilities to which security rules are attached and multiple Oracle Human Resource Management System (HRMS) responsibilities to which security profiles are attached. After adding this user as a Noetix query user and assigning the Derived from Oracle EBS security mode in NoetixViews Administrator, when the Noetix query user or a BI tool user who is linked to this Noetix query user queries data from the global form of Noetix views for General Ledger, Advanced Benefits, Human Resources, Time and Labor, and Payroll through a BI tool, the number of rows returned will be further filtered by the responsibility with which the user logs on.

In BI tools, such as Noetix WebQuery (NWQ) and Oracle Discoverer, Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) type can select a General Ledger or HRMS responsibility when they log on to these BI tools. After logging on, if the Noetix query users want to select a different General Ledger or HRMS responsibility, they will have to log off from the current user session and then log on to the BI tool again.

In BI tools, such as Oracle Business Intelligence (Oracle BI), SAP Business Objects, and IBM Cognos Business Intelligence (Cognos BI), users log on with the responsibility associated with the Noetix query user of the Oracle E-Business Suite Authenticated User (Type A) type to which they are linked. After logging on, if the BI tool users want to select a different General Ledger or HRMS responsibility, they can run the Noetix Responsibility Tool to change the responsibility. This application allows BI tool users to change their General Ledger or HRMS responsibility without logging off from their current user session.

Organizational Unit Security

Organizational unit security is applied to Noetix query users based on their access to organizational units. These organizational units include business groups, ledgers, operating units, and inventory organizations. In the global forms of Noetix views that support row-level security, the organizational unit security is applied by default. Additionally, organizational unit security is supported in standard and XOP forms of Noetix views for Oracle U.S. Federal Financials. Organizational unit security can be set up for the following types of Noetix query users:

  • Database User (Type U)

  • Oracle E-Business Suite Authenticated User (Type A)

  • Oracle E-Business Suite Authenticated Responsibility (Type R)

  • Noetix System Administration User (Type N)

For more information on users and roles, see About Noetix Query Users and Roles.

NoetixViews also provides the functionality to override the organizational unit security defined for the Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types in Oracle E-Business Suite.

NoetixViews supports organizational unit security for the global forms of the Noetix views for the following Oracle E-Business Suite modules:

Oracle E-Business Suite modules

Organizational unit

Oracle Advanced Benefits, Oracle Human Resources, Oracle Time and Labor, and Oracle Payroll

Business group

Oracle Assets, Oracle General Ledger, and Oracle U.S. Federal Financials

Ledger

Oracle Order Management, Oracle Payables, Oracle Projects, Oracle Purchasing, Oracle Receivables, Oracle Service Contracts

Operating unit

Oracle Install Base

Operating unit and item instance

Oracle Bills of Materials, Oracle Cost Management, Oracle Enterprise Asset Management, Oracle Inventory, Oracle Master Scheduling/MRP, Oracle Quality, and Oracle Work in Process

Inventory organization

Also, for Oracle E-Business Release 12 and later, global form of Noetix views support organizational unit security provided by the Multi-Org Access Control (MOAC) feature for Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types.

Application-Specific Security

Application-specific security is applied over the existing organizational unit based security applied to Noetix query users. The application-specific security restricts their access to data in Noetix views based on security rules, security profiles, budget access levels, and service request types.  NoetixViews supports application-specific security in global Noetix views for the following Oracle E-Business Suite modules:

Oracle E-Business Suite modules

Application-specific security based on

Oracle Advanced Benefits, Oracle Human Resources, Oracle Time and Labor, and Oracle Payroll

Security profiles

Oracle General Ledger

Security rules for the Accounting key flexfield

Oracle U.S. Federal Financials

Budget access levels

Oracle Depot Repair, Oracle Field Service, and Oracle TeleService

Service request types

Application-specific security is also supported in standard and XOP forms of views for Oracle U.S. Federal Financials and General Ledger and in standard form of views for Human Resources, Advanced Benefits, Payroll, and Time and Labor. By default, for the standard views of Human Resources, Advanced Benefits, Payroll, and Time and Labor, application-specific security is defined in Oracle E-Business Suite and cannot be modified through NoetixViews Administrator.

Application-specific security that is applied based on security rules, service request types, and budget access levels can be set up for the following Noetix query users:

  • Database User (Type U)

  • Oracle E-Business Suite Authenticated User (Type A)

  • Oracle E-Business Suite Authenticated Responsibility (Type R)

  • Noetix System Administration User (Type N)

Application-specific security that is applied based on security profiles can be set up for the following Noetix query users:

  • Oracle E-Business Suite Authenticated User (Type A)

  • Oracle E-Business Suite Authenticated Responsibility (Type R)

For more information on users and roles, see About Noetix Query Users and Roles.

NOTE: For Noetix query users of the Database User (Type U) and Noetix System Administration User (Type N) types, the security profiles will apply only if the Noetix query users are also defined in Human Resources as reporting users for the security profiles.

NoetixViews also provides the functionality to override the application-specific security defined for the Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types in Oracle E-Business Suite.

The following list provides information about the Noetix views that support application-specific security:

  • For Advanced Benefits, the following views support application-specific security:

    • BEN COBRA Beneficiaries

    • BEN Elig Elec Enrollments

    • BEN Emp Dependents

    • BEN Life Evnt Workflow

    • BEN Payroll Ben Costs

    • BEN Potential Life Evnts

    • BEN Ptpnt Benefit Costs

    • BEN Ptpnt Communications

    • BEN Ptpnt Court Orders

    • BEN Ptpnt Electabilities

    • BEN Ptpnt Eligibilities

    • BEN Ptpnt Enroll Actions

    • BEN Ptpnt Enrollments

    • BEN Ptpnt Flex Credits

    • BEN Ptpnt Flex Spending

    • BEN Ptpnt Life Events

    • BEN Ptpnt Mthly Premiums

  • For Depot Repair, the following views support application-specific security:

    • CSD AP Repair Invoices

    • CSD AR Repair Invoices

    • CSD OE Repair Actuals

    • CSD OE Repair RMA Orders

    • CSD OE Repair Shipments

    • CSD PO Repair Req Orders

    • CSD Repair Estimate Notes

    • CSD Repair Estimates

    • CSD Repair Notes

    • CSD Repair Order Services

    • CSD Repair Orders

    • CSD Repair Task Notes

    • CSD Repair Tasks

    • CSD Service Requests

    • CSD WIP Repair Jobs

  • For Field Service, the following views support application-specific security:

    • CSF Debrief Charge Lines

    • CSF Debrief Expense Lines

    • CSF Debrief Labor Lines

    • CSF Debrief Material Lines

    • CSF Task Resources

  • For TeleService, the following views support application-specific security:

    • CS Interaction Activities

    • CS Service Request Audits

    • CS Service Request Notes

    • CS Service Request Tasks

    • CS Service Requests

    • CS SR Attachments

    • CS SR Task Audits

    • CS Task Notes

  • For U.S. Federal Financials, the following views support application-specific security:

    • FV Budget Appr GL JE

    • FV Budget Auth SLA GL JE

    • FV Budget Authority Trans

    • FV Budget Transactions

    • FV Fund Distr GL JE

    • FV Fund Distr SLA GL JE

    • FV Fund Distributions

    • FV SLA Budget Auth Trans

    • FV SLA Budget RPR Trans

    • FV SLA Budget Trans

    • FV SLA Fund Distributions

  • For General Ledger, the following views support application-specific security:

    • GL All Balances

    • GL All Budgets

    • GL All Encumb Je Lines

    • GL All Je Lines

    • GL AP Inv Je Line Details

    • GL Archived Balances

    • GL Archived Je Lines

    • GL Balances

    • GL Budget Actuals Encumb

    • GL Budget To Actuals

    • GL Budgets

    • GL Encumbrance Balances

    • GL Foreign Balances

    • GL Foreign Je Lines

    • GL Foreign Summaries

    • GL Funds Available

    • GL Je AP Inv Dist Details

    • GL Je AP Pmt Dist Details

    • GL Je SLA AP Inv Dist

    • GL Je SLA AP Pmt Dist

    • GL Je SLA AR Adj Dist

    • GL Je SLA AR Misc Rcpt Dist

    • GL Je SLA AR Std Rcpt Dist

    • GL Je SLA AR Tran Dist

    • GL Je Tran AR Adj Dist

    • GL Je Tran AR Misc Dist

    • GL Je Tran AR Pymt Dist

    • GL Je Tran AR Tran Dist

    • GL Journal Entry Lines

    • GL Org Balances

    • GL Org Budget To Actuals

    • GL Org Budgets

    • GL Parent Budget To Actuals

    • GL Parent Child Balances

    • GL Parent Child Budgets

    • GL Rollup Account Balances

    • GL Rollup Account Budgets

    • GL Rollup Parent Balances

    • GL Rollup Parent Budgets

    • GL Stat Balances

    • GL Stat Budget To Actuals

    • GL Stat Budgets

    • GL Summary Balances

    • GL Summary Budget To Actuals

    • GL Summary Budgets

    • XLA GL All Balances

    • XLA GL Journal Lines

    • XLA SLA Hub Journal Lines

  • For Human Resources, the following views support application-specific security:

    • HR Accrual Pln Hist

    • HR Address Hist

    • HR AP 1099 Payments

    • HR Applicant Hist

    • HR Ben Elig Info

    • HR Budgets

    • HR Carrier Asg Hist

    • HR COBRA Prem Stat

    • HR COBRA Track

    • HR Contact Hist

    • HR Contingent Worker Info

    • HR EI Academic Rank

    • HR EI Asg Ben Derived

    • HR EI Asg Federal

    • HR EI Asg Locality

    • HR EI Asg Types

    • HR EI GHR Probations

    • HR EI GHR Sep Retire

    • HR EI Job Types

    • HR EI Loc Types

    • HR EI Per Types

    • HR EI Pos Types

    • HR EI US Add Details

    • HR EI US Passport Dtls

    • HR EI US Visa Dtls

    • HR Element Links

    • HR Emp Absence Hist

    • HR Emp ADA Info

    • HR Emp Asg Details

    • HR Emp Assign Costs

    • HR Emp Assign Costs Hist

    • HR Emp Assign Hist

    • HR Emp Ben Health

    • HR Emp Ben Others

    • HR Emp Beneficiary

    • HR Emp Element Entry Vals

    • HR Emp Emergency

    • HR Emp Ethnic Info

    • HR Emp Headcnt Hist

    • HR Emp Headcounts

    • HR Emp Info

    • HR Emp LOS

    • HR Emp Reviews

    • HR Emp Sal Analysis

    • HR Emp Sal Hist

    • HR Emp Sal Pro Current

    • HR Emp Sal Pro Hist

    • HR Emp Tax Details

    • HR Emp Terms Hist

    • HR Emp Total Comp

    • HR Emp Veteran Info

    • HR Emp Work Hist

    • HR Emp Xfers Hist

    • HR New Hire Hist

    • HR Oth Headcnt Hist

    • HR Pay Scales

    • HR People Grp Hist

    • HR Person Hist

    • HR Phones Hist

    • HR Pos Hierarchies

    • HR Pos Requirements

    • HR Req Vac Track

    • HR Schools Attended

    • HR SI Type

    • HR Turnover Hist

    • HR Vac Job Match

    • HR Vac Pos Match

  • For Time and Labor, the following views support application-specific security:

    • HXC Assignment Time Info

    • HXC BEE Batch Headers

    • HXC BEE Batch Lines

    • HXC BEE Error Messages

    • HXC PUI Latest Timecards

    • HXC PUI Missing Timecards

    • HXC PUI Timecard History

    • HXC SS Latest Timecards

    • HXC SS Missing Timecards

    • HXC SS Time Category Hours

    • HXC SS Timecard History

    • HXC Timecard Summary

  • For Payroll, the following views support application-specific security:

    • PAY Accruals

    • PAY Check Register

    • PAY Costing Analysis

    • PAY Costing Details

    • PAY Costing Summary

    • PAY Custom Balances

    • PAY Deductions Owed

    • PAY Emp Not Paid

    • PAY Gre Totals

    • PAY Gross And Net Balances

    • PAY Gross To Net Summary

    • PAY Hours By Cost Center

    • PAY Invalid Addresses

    • PAY Payment Methods

    • PAY Payment Register

    • PAY Payroll Activities

    • PAY Payroll Audit

    • PAY Payroll Messages

    • PAY Payroll Proc Summary

    • PAY Run Results

    • PAY Tax Balances

    • PAY Third Party Register

    • PAY US Payroll Register

    • PAY US W2 Register

    • PAY Void Payments

Was this article helpful?

We're sorry to hear that.