GL Data Access Sets

Description

Categories
Enginatics, R12 only
Repository
GitHub
Master data report showing ledger security.
Listing of all GL data access sets and the ledgers or ledger sets that each access set can access.

Show Responsibilities adds one row per responsibility using the access set through the GL: Data Access Set profile set at responsibility or application level. Responsibilities inheriting the site level value are not listed.

Summary Accounts Allowed shows Yes when the responsibility's menu grants the Summary Accounts form and the access set gives full read and write access to the whole ledger. Otherwise the form's Ledger list does not offer the ledger (FRM-41830 List of Values contains no entries).

SQL 39 lines

Parameters 5

ParameterTypeList of values SQL
Access SetLOV
gasv.name=:access_set
LedgerLOV
gl.name=:ledger
Access Set TypeLOV
gasv.security_segment_code=:access_set_type
Show ResponsibilitiesLOV
r.responsibility_name responsibility,
r.application_name responsibility_application,
decode(r.level_id,10002,'Application',10003,'Responsibility') profile_level,
xxen_util.yes(nvl2(gasl.ledger_id,r.summary_accounts_form,null)) summary_accounts_allowed,
Summary Accounts AllowedLOV
nvl2(gasl.ledger_id,r.summary_accounts_form,null)='Y'