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