Configure Access to Source Journal Entries from Joint Venture Transactions, Distributions, and Invoices

In the work areas for viewing joint venture transactions and their subsequent distributions and invoices, users can use a link to drill down to a view only page to review source journal entries from which these items originated. However, the link is enabled only for users who are set up with access to view journal entries in Oracle Financials Subledger Accounting and General Ledger.

To set up this access, you must identify the data access sets of the source transactions and associate these data access sets to the joint venture user’s profile and role.

Caution:

This setup might result in the user having manage access to all subledgers.

  1. Navigate to Setup and Maintenance and access the Users and Security functional area.
  2. Select the Manage Job Roles task and select Create Role.

    The Create Role setup wizard appears.

  3. On Basic Information, add information to create a new role with role category as Financials-Job Roles, and select Next.
  4. On Function Security Policies, select Add Function Security Policy.
  5. Search for and add the following function security policies, and then select Next:
    • Manage Journal Activities

    • Review Subledger Journal Entry Rule Set

    • Review Journal

      This image shows the Add Function Security Policy page with these policies added to a role: Manage Journal Activities, Review Subledger Journal Entry Rule Set, and Review Journal.
  6. On Data Security Policies, select Create Data Security Policy.
  7. Use the information in the following table to add the required data security policies:
    Policy Required values
    Grant on Subledger Application

    Data Resource: Subledger Source Transaction

    Policy description: Joint venture users can review subledger source transaction data for authorized General Ledger data access sets.

    Data set: Select By Instance Set

    Condition name: Access All Subledger Source Transactions for a Ledger

    Actions: Manage Subledger Source Transaction Data

    Grant on Subledger Application

    Data Resource: Subledger Application

    Policy description: Joint venture users can review subledger application data for authorized General Ledger data access sets.

    Data set: Select By Instance Set

    Condition name: Subledger Application Instance Set

    Actions: Manage Subledger Application Data

    Grant on Ledger

    Data Resource: Ledger for Table GL_LEDGERS

    Policy description: Joint venture users can report Oracle General Ledger for ledgers derived from authorized data access sets.

    Data set: Select By Instance Set

    Condition name: Access the ledger for table GL_LEDGERS for the ledgers derived from data access sets for which they're authorized

    Actions: Read; Report Oracle Fusion General Ledger

    Grant on General Ledger Access Sets

    Data Resource: Data Access Set for Table GL_ACCESS_SETS

    Policy description: Joint venture users can review Oracle General Ledger data for authorized data access sets.

    Data set: Select By Instance Set

    Condition name: Access the general ledger data access set for table GL_ACCESS_SETS for the general ledger data access sets for which they're authorized

    Actions: Read; Inquire and Analyze Oracle Fusion General Ledger Account Balance

  8. Review the Summary page and select Save and Close.

    The application proceeds to the Roles page.

  9. Add the new role to the joint venture user:
    1. Select Users on the menu on the Roles page.
    2. On User Accounts, search for and select your joint venture user.
    3. Select Edit and add the new role to the user.

      The user’s profile should now have two roles associated with it, the role that you associated here and the joint venture role, for example the prescribed joint venture accounting manager or joint venture accountant role.

  10. Configure access to this user and role for all the data access sets under which the subledger and general ledger transactions were created:
    1. Navigate to Setup and Maintenance and access the Enterprise Profile functional area.
    2. Select the Manage Reference Data Set Data Access task.
    3. On Manage Data Access for Users, select the Users with Data Access option.
    4. Select Data access set for Security Context.
    5. Enter your joint venture user in the User Name field.
    6. Select Add and enter information to assign the required data access sets to the joint venture user and role, as shown in this example:

      This image shows the Manage Data Access Set for Users page, the details of which are described in the surrounding text.

    The example shows two records added with the following details to enable data access for a joint venture user:

    User Name Role Role Name Security Context Security Context Value
    JVAccountingManager View_Journals ORA_JV_JOINT_VENTURE Data access set HEPPLedger US
    JVAccountingManager View_Journals ORA_JV_JOINT_VENTURE Ledger HEPPLedger US