GLXJEENT: Enter Journals Account LOV Not Restricted by Data Access Set (Doc ID 780336.1)

Last updated on FEBRUARY 11, 2016

Applies to:

Oracle General Ledger - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Form:GLXJEENT.FMB - Enter Journals/Encumbrances

***Checked for relevance on 31-Jan-2014***


Symptoms

You have the following setup:

  1. One Ledger - LEDGER ONE
  2. Associated with this ledger you have Two Legal Entities - LEGAL ENTITY ONE and LEGAL ENTITY TWO
  3. To LEGAL ENTITY ONE, user has the following Balancing Segment Value Assignments setup:
    •     Value Set is COMPANY_VALUE_SET
    •     BSV's values added are: 100, 110, 120
  4. To LEGAL ENTITY TWO, user has the following Balancing Segment Value Assignments setup:
    •     Value Set is COMPANY_VALUE_SET
    •     BSV's values added are: 200, 210, 220 
  5. The company segment in the chart of accounts,  which uses the value set COMPANY_VALUE_SET, has the following valid values 100, 110, 120, 200, 210, 220, 300, 310, 320.
  6. User created a Data Access Set with the Access Set Type: Balancing Segment Value 
    • Ledger: LEDGER  ONE
    • BSV Specific Value : 100 
    • Read Write access

When entering data for the accounting flexfield in the journal entry form,  the user expects only the value 100 to show at the COMPANY prompt (first segment of the accounting flexfield).

Instead all valid values for company - 100, 110, 120, 200, 210, 220, 300, 310, 320 are visible in the Company LOV.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms