Saturday, January 19, 2008

New Feature - Data Access Sets

One of the new features in General Ledger is Data Access Sets. This feature plays a very important role in having a Secured Data Access to the user or one can called it as RBAC (Role Based Access Control).
In previous versions, access to data by users has been restricted only by excluding the menus and functions of the responsibility and then that responsibility is assigned to the particular users who are eligible. This job is carried out by a system administrator or a consultant having system administrator responsibility. This functionality stays as such in Rel 12 also.
Apart from the above, in Rel 12, General Ledger has also contributed a new feature towards securing data.
A Ledger created in General Ledger Module is accessed by various modules using different responsibilities, if one decided to exclude menus for all such responsibilities it will be a time consuming process, instead one can create a security by creating an Data Access Set for a ledger in General Ledger itself, which will apply to all responsibilities using that particular ledger. However, a setting is required for each such responsibilities, that is you have to attach the respective Data Access Set to the respective Responsibility by using GL: Data Access Set profile option. This setting can be done only from system administrator responsibility.
Note: One Responsibility can have only one data access set assigned.

Now let us see what are the types of security that one can have for a ledger or ledger set.
1) Full Ledger 2) Balancing Segment Value 3) Management Segment Value

1) Full Ledger - Full ledger access means having full read and write access to the ledger and all of its balancing segment values or management segment values.

2) BSV - If you assign specific balancing segment values to legal entities and ledgers, you will only be able to use those balancing segment values during transaction processing and journal entry.

3) MSV - When securing management segment values for a ledger, take note of the management segment values you used when you assigned the default accounts to the ledger, such as the retained earnings account and the cumulative translation adjustment account.

The privileges available for all the three Data Access sets are :

Read Only: Allows users to view data in ledgers and balancing or management
segment values.
Read and Write: Allows users to view and enter data in ledgers and balancing or
management segment values.

If you closely observe the BSV and MSV data access types it is more or less similar to a security rule that is defined in General Ledger module. And one more thing, BSV and MSV type Data Access sets also considers Security Rules.
For Eg: Assume that you have blocked a Segment value 01 for your company segment,
whereas you have included segment value 01 in the Data Access set, in which case, the
user will not have access to the segment value 01.

Will confuse you guys more with my other posts shortly !!

48 comments:

Aparna said...

Hi, nice article. Comprehensive.

v.pallavi reddy said...

lot of information for freshers and trainers in oracle financials

Mihir said...

thanks !!

Nag said...

Hi -

It was nice article but I cant able to see the profile called 'SLA: Disable Journal Import' in the system profiles. Do I need to do any thing?
Also, my question is I have created a manual accounting in SLA ( Source : Assets and Category : Addition) which needs to transfer to GL. Pls help me out.

Anonymous said...

Oracle Certifications Guide (Free to Download)
http://tinyurl.com/7x5gbbk

Unknown said...

The information you posted here is useful to make my career better keep updates..If anyone want to become an oracle certified professional reach FITA, which offers real timeOracle Training Chennai with years of experienced professionals.

Unknown said...

Cloud Computing Training

The information you posted here is useful to make my career better keep updates...If anyone want to get Cloud Computing Training in Chennai, Please visit FITA academy located at Chennai Velachery which offer best Cloud Computing Course in Chennai.

Cloud Computing Training Centers in Chennai

Cloud Computing Training Chennai

Unknown said...

Thanks for sharing the new features of oracle. It is very helpful for me.
Web designing Training in chennai | Web designing Training chennai | Web designing course in chennai | Web designing course chennai

Unknown said...

very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information. AWS Training in chennai | AWS Training chennai | AWS course in chennai

Sunny said...

Can we use two data access set one with full ledger access and other with only balancing segment value

Anonymous said...

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Technical Financials, kindly contact us http://www.maxmunus.com/contact
MaxMunus Offer World Class Virtual Instructor led training on Oracle Technical Financials. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/



DBA training courses said...

You have shared informative features of data access. Keep updating.
DBA course syllabus | Oracle dba course

Anonymous said...

Real Estate Consultant in Chennai
Real Estate Private Equity in India
Real Estate Advisory Companies in India
Real Estate Research in Chennai

Anonymous said...

Very interesting article I feel very enthusiastic while reading and the information provided in this article is so useful for me.content in this article guides in clarifying some of my doubts.For additional information please visit our website.Oracle Fusion Cloud Financials Training

oraclefusion said...

It is the amazing and wonderful web site.Thanks for sharing this information

Unknown said...

Nice blog, thank you for sharing our experience for Oracle Financials. It is very useful to me. For more information please visit our website.
Oracle Financials Training in Chennai

Unknown said...

Nice blog, Thank you for sharing. Oracle R12 Financials Training

Unknown said...

this is a very nice article and very good information for Oracle ADF Learners.
Click here:
Oracle Financials Training in Hyderabad

Unknown said...

Nice blog, Thank you for sharing. See More: Oracle Financials Training in Chennai

DeepikaOrange said...


Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.

Cloud Training in Chennai
Big Data Hadoop Admin Training
Oracle DBA Training
Oracle PLSQL Training
Oracle Performance Tunning Training

Mounika said...

Fantastic work! This is the type of information that should follow collective approximately the web. Embarrassment captivating position Google for not positioning this transmit higher! Enlarge taking place greater than and visit my web situate
python training in rajajinagar
Python training in bangalore
Python training in usa

nilashri said...

This blog is the general information for the feature. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.

Data Science course in Indira nagar
Data Science course in marathahalli
Data Science Interview questions and answers
Data science training in tambaram | Data Science Course in Chennai
Data Science course in btm layout | Data Science training in Bangalore
Data science course in kalyan nagar | Data Science Course in Bangalore



gowthunan said...

I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
iosh safety course in chennai

haripriya said...

Really you have done great job,There are may person searching about that now they will find enough resources by your post
Data Science course in kalyan nagar
Data Science course in OMR
Data Science course in chennai
Data science course in velachery
Data science course in jaya nagar
Data Science interview questions and answers

sasitamil said...

I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing..
Believe me I did wrote an post about tutorials for beginners with reference of your blog. 




Selenium training in bangalore
Selenium training in Chennai
Selenium training in Bangalore
Selenium training in Pune
Selenium Online training

Anonymous said...

Excellent post gained so much of information, Keep posting like this.
Aviation Academy in Chennai
Air hostess training in Chennai
Airport management courses in Chennai
Ground staff training in Chennai
Aviation Courses in Chennai
Air Hostess Training Institute in chennai
Airport Management Training in Chennai
airport ground staff training courses in Chennai

Priyanka said...

Attend The Python Training in Bangalore From ExcelR. Practical Python Training in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python Training in Bangalore.

htop said...

thanks for sharing this information
best python training in chennai
best python training in sholinganallur
best python training institute in omr
python training in omr
selenium training in chennai
selenium training in omr
selenium training in sholinganallur

shivanisrdm said...

Thanks for sharing a valuable information...keep sharing
Digital Marketing Training In Hyderabad
sem training in hyderabad
seo training in hyderabad

ExcelR Solutions said...

Thanks for sharing the valuable information. So i think i got some useful information with this content. Thank you and please keep update informative post!!
Machine Learning Course Bangalore

Anonymous said...


smart outsourcing solutions is the best outsourcing training
in Dhaka, if you start outsourcing please
visit us: graphic design training
digital marketing training

Big Data Hadoop training institutes said...

Great post and i never get bored while going through this awsome post.Thank you for sharing this and also if you want to know about Hadoop course visit hadoop training institute in btm layout

Realtime Experts said...

Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts.

sap hybris training in bangalore

sap scm training in bangalore

sap pm training in bangalore

sap crm training in bangalore

sap ewm training in bangalore

Realtime Experts said...

Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts.

sap hybris training in bangalore

sap scm training in bangalore

sap pm training in bangalore

sap crm training in bangalore

sap ewm training in bangalore

raveena said...

This ois good blog.
Oracle Fusion Financials Online Training

yamuna said...

Good Information, thanks for sharing this blog.
Oracle Fusion Financials Online Training

divya said...

It has been simply incredibly generous with you to provide openly what exactly many individuals wouldíve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted god jobs guys
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai

Devi said...

Very nice informative blog. Actually it's great article. Thanks for sharing unique content. oracle training in chennai

Pallavi reddy said...
This comment has been removed by the author.
INFYCLE TECHNOLOGIES said...

Infycle Technologies, the best software training institute in Chennai offers the leading Python course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Cyber Security, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

Alan Curtis said...

Contact: pedroloanss@gmail.com / WhatsApp Number+1-8632310632 for loan offer,
Mr Pedro enabled me to take advantage of an incredible opportunity to relocate and expand my business with his loan offer, at a pivotal time. The support I received from the Loan Firm Pedro working for it was priceless.

Reshma said...


Nice blog! Thanks for sharing this valuable information
RPA Training in Hyderabad
RPA Training in Gurgaon
RPA Training in Delhi

Techwriter said...

I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end.
Python Training In Pune

David Fincher said...

This post is so interactive and informative.keep update more information...
SEO Training in Anna Nagar
SEO Training in Chennai

traininginstitute said...

Hi buddies, it is a great written piece entirely defined, continue the good work constantly.
cyber security course malaysia

Fusion Financials said...

I'm impressed by the depth of knowledge you have on [topic]. It's clear that you're an expert in this field. Fusion financial training in hyderabad

fusion financial training said...

This insightful blog delves into the exciting realm of the new feature - Data Access Sets, unraveling its significance in enhancing data control within oracle Fusion Financials Training. The author adeptly navigates through the intricacies of this advanced feature, providing valuable insights for finance professionals and system administrators seeking to optimize their data management workflows.

IT Education said...

I have enjoyed reading your article since I stumbled upon it recently. I want to express how much I like your writing skills and your capacity to hold readers' attention through to the very end.
Python Course in Pune