Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Oracle Fixed Asset:Security by Book

Posted on June 13th, 2008 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

You can manage your Asset Book Security, as mention in one of last post.This Functionality you can

  • Secure access to each depreciation book
  • Create a flexible hierarchy of asset organizations
  • Associate a responsibility with one or more depreciation books

Asset Book Security allows multiple asset books/registers to be manage/administered independently.

dgreybarrow-2Oracle Responsibility and Security by Bookbookbysecurity

As mention Oracle FA has the ability to separate access to functionality such as asset additions, changes, inquiries, reporting, disposals, transfers, depreciation and reconciliation in a controlled manner based on the responsibility to which they are assigned.

Security only operates on secured books in secure responsibilities.

dgreybarrow-2Setup step for enabling

As mention , these are the steps need to perform as per this post .

Steps need to Performed

  1. Define your Organizations
  2. Specify the Hierarchy
  3. Set Up Security Profiles
  4. Run the Security List Maintenance Program
  5. Create Responsibilities
  6. Attach Security Profiles to Responsibilities & assign Responsibilities to Users

dgreybarrow-2Instead of setting Security by Book Allows Access to all Books

dgreybarrow-2Even after assigning the FA: Security profile. A subsidiary is still able to see all the information in another book ?

What is missed out ..if all 5 steps done properly

While setting up in another environment( where 8 OU’s each have 2 books(Corporate and Tax),I discovered and found this does access to all books. This is because set_fa_context does not getting any application Id for make secure based out of responsibility.

What you need to do is Just ‘Initialization SQL Statement – Custom’ profile value which needs to be set to call set_fa_context with the application_id of the given responsibility.

This piece of code you need to set in profile options along with 5 steps mention in this post




book by security

dgreybarrow-2 Common issue while enabling Security by Book

By any chance if this feature is troubling you , you need to investigate the root cause.Still these are few one

  • You need to review the functionality and try to see how Security by Book feature enables you to designate an organizational hierarchy in which the assets of an organization can only be seen by the parent organization as well other entities.
  • You can also manage any number of orphan Organization.As you can do set up and define any number of organizations and include as many of them as you wish in the hierarchy. You should design sure that your hierarchy is set up as you planned.
  • If you left Security List Maintenance program then you cann’t get the value populates into LOV’s with the appropriate information.
  • Check Profile options you enable or not for
    • FA: Security Profile
    • Initialization SQL Statement – Custom

dgreybarrow-2Few question before starting implementation for Security by Book

Before implementing the Oracle asset Security by Book feature you need to have clear idea about

  • How you are going to control and limit access to asset books?
  • Do all your books need security?
  • How do you want to organize security?
  • You will maintain the security once system is live?
  • Is any requirement for having control of Reporting Currencies reporting books for security?

dgreybarrow-2Metalink Notes

  • Note.171730.1 How To Set Up Security by Book in Oracle Fixed Assets 11i?
  • Note.218249.1 Security by Book FAQ
  • Note.139518.1 Attaching existing depreciation book to organization hierarchy
  • Note.136995.1 Setup of FA Security Profile does not work
  • Note.218248.1 Oracle Assets Troubleshooting Guide for Security by Book
  • Note.108284.1 Do I Have To Set Up Organizations For Assets Release 11i?
  • Note.184285.1 Poor Performance with Asset Reports When Using Security by Book
  • Note.206638.1 Security by Book does not Work for Globalization Responsibilities
  • Note.212261.1 Secured FA Responsibility Has Access to All TAX Books
  • Note.216381.1 Security by Book Allows Access to all Books
  • User Guide :Chapter 9, System Setup – has a section on setting up Security by Book

dgreybarrow-2Similar Post

Related Posts

Posted in Oracle Asset | 4 Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. FA : Capital Budgeting & Depreciation Forecast Says:

    […] : Capital Budgeting & Depreciation ForecastUnderstanding Depreciation Books: Back to BasicOracle Fixed Asset:Security by BookFNDLOAD for AME’sMigration of XMLPub Templates :XDOLOADER UtilityR12 : Cash Management & […]

  2. goodhawk Says:

    yeah. it’s nice.

  3. ziya ?enol Says:

    Great article, very very useful. Tnx..

  4. Thiago Says:

    Is there how one report made at the EBS using jdev work with these rules?
    Or ill have to make the select to take the rules?

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.