ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8143175C7BEA161EE0530100007FF604Y select gasv.name access_set, gasv.description, gasv.chart_of_accounts_name chart_of_accounts, gasv.period_set_name calendar, gasv.user_period_type period_type, decode(gasv.security_segment_code,'F','Full Ledger','B','Balancing Segment Value','M','Management Segment Value') access_set_type, gasv.default_ledger_name default_ledger, gasna.indent||gl.name ledger_name, decode(gl.ledger_category_code,'NONE',xxen_util.meaning('S','LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101)) ledger_category, xxen_util.meaning(gasna.all_segment_value_flag,'YES_NO',0) all_values, gasna.segment_value specific_value, decode(gasna.access_privilege_code,'B','Read and Write','R','Read Only') privilege, &responsibility_columns xxen_util.user_name(gasna.created_by) created_by, xxen_util.client_time(gasna.creation_date) creation_date, xxen_util.user_name(gasna.last_updated_by) last_updated_by, xxen_util.client_time(gasna.last_update_date) last_update_date, gasv.access_set_id from gl_access_sets_v gasv, ( select gasna.ledger_id ledger_id_, null indent, gasna.* from gl_access_set_norm_assign gasna union select glsnav.ledger_id ledger_id_, ' ' indent, gasna.* from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.ledger_id=glsnav.ledger_set_id ) gasna, gl_ledgers gl &responsibility_table where 1=1 and &responsibility_join gasv.access_set_id=gasna.access_set_id(+) and gasna.ledger_id_=gl.ledger_id(+) and nvl(gasna.status_code,'x') not in ('D','I') order by gasv.name, gasna.ledger_id, gl.object_type_code desc, gl.name &responsibility_order Added parameters Ledger, Access Set Type, Show Responsibilities and Summary Accounts Allowed. Show Responsibilities adds one row per responsibility with the GL: Data Access Set profile set at responsibility or application level, and a column showing whether it can define summary accounts for the ledger. AR GL Data Access Sets تقرير بيانات رئيسي يوضح الوصول إلى أمان حساب GL عبر دفاتر الأستاذ المتعددة. D GL Data Access Sets Stammdatenbericht mit Anzeige des GL-Konto-Sicherheitszugriffs über mehrere Ledger hinweg. E GL Data Access Sets Informe de datos maestros que muestra el acceso a la seguridad de la cuenta del libro mayor en varios libros. F GL Data Access Sets Rapport sur les données de base montrant l'accès à la sécurité des comptes de GL dans plusieurs grands livres. I GL Data Access Sets Rapporto dei dati principali che mostra l'accesso di sicurezza del conto GL su più libri mastri. JA GL Data Access Sets 複数の台帳にまたがるGLアカウントのセキュリティアクセスを示すマスターデータレポート。 KO GL Data Access Sets 여러 원장에 대한 GL 계정 보안 액세스를 보여주는 마스터 데이터 보고서. PTB GL Data Access Sets Relatório de dados mestre mostrando o acesso de segurança da conta GL em vários ledgers. RU GL Data Access Sets Отчет об основных данных, показывающий безопасный доступ к учетным записям GL по нескольким бухгалтерским записям. S GL Data Access Sets Huvuddatarapport som visar GL-kontos säkerhetsåtkomst över flera huvudböcker. TR GL Data Access Sets Birden çok defterde GL hesabı güvenlik erişimini gösteren ana veri raporu. US GL Data Access Sets 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). ZHS GL Data Access Sets 主数据报告显示多个分类账的GL账户安全访问。 Enginatics &responsibility_columns &responsibility_join &responsibility_order &responsibility_table 1=1 1 10 1=1 gasv.name=:access_set LOV custom Y select gasv.name value, gasv.description from gl_access_sets_v gasv order by gasv.name fnd_profile.value('GL_ACCESS_SET_ID') US Access Set 2 15 1=1 gl.name=:ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) US Ledger 3 20 1=1 gasv.security_segment_code=:access_set_type LOV custom Y select 'F' id, 'Full Ledger' value, null description from dual union all select 'B' id, 'Balancing Segment Value' value, null description from dual union all select 'M' id, 'Management Segment Value' value, null description from dual US Access Set Type 4 30 &responsibility_columns 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, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Responsibilities One row per responsibility with the GL: Data Access Set profile set at responsibility or application level, including whether it can define summary accounts for the ledger. 5 &responsibility_join to_char(gasv.access_set_id)=r.access_set_id and gasna.access_set_id=gasl.access_set_id(+) and gasna.ledger_id_=gasl.ledger_id(+) and US Show Responsibilities 6 &responsibility_order , r.responsibility_name US Show Responsibilities 7 &responsibility_table , ( select frv.responsibility_name, fav.application_name, x.level_id, x.access_set_id, nvl2(y.responsibility_id,'Y',null) summary_accounts_form from ( select fr.responsibility_id, fr.application_id, max(fpov.level_id) level_id, max(fpov.profile_option_value) keep (dense_rank last order by fpov.level_id) access_set_id from fnd_responsibility fr, fnd_profile_options fpo, fnd_profile_option_values fpov where sysdate between fr.start_date and nvl(fr.end_date,sysdate) and fpo.profile_option_name='GL_ACCESS_SET_ID' and fpo.application_id=fpov.application_id and fpo.profile_option_id=fpov.profile_option_id and fpov.profile_option_value is not null and (fpov.level_id=10002 and fpov.level_value=fr.application_id or fpov.level_id=10003 and fpov.level_value=fr.responsibility_id and fpov.level_value_application_id=fr.application_id) group by fr.responsibility_id, fr.application_id ) x, ( select distinct fr.responsibility_id, fr.application_id from fnd_form_functions fff, fnd_compiled_menu_functions fcmf, fnd_responsibility fr where fff.function_name in ('GLXACSUM','GLXACSUM_G') and fff.function_id=fcmf.function_id and nvl(fcmf.grant_flag,'Y')='Y' and fcmf.menu_id=fr.menu_id and not exists (select null from fnd_resp_functions frf where frf.rule_type='F' and frf.application_id=fr.application_id and frf.responsibility_id=fr.responsibility_id and frf.action_id=fcmf.function_id) and not exists (select null from fnd_resp_functions frf, fnd_compiled_menu_functions fcmf2 where frf.rule_type='M' and frf.application_id=fr.application_id and frf.responsibility_id=fr.responsibility_id and fcmf2.menu_id=frf.action_id and fcmf2.function_id=fcmf.function_id and nvl(fcmf2.grant_flag,'Y')='Y') ) y, fnd_responsibility_vl frv, fnd_application_vl fav where x.responsibility_id=y.responsibility_id(+) and x.application_id=y.application_id(+) and x.responsibility_id=frv.responsibility_id and x.application_id=frv.application_id and x.application_id=fav.application_id ) r, ( select gasl.access_set_id, gasl.ledger_id from gl_access_set_ledgers gasl, gl_ledgers gl where gasl.access_privilege_code='F' and gasl.ledger_id=gl.ledger_id and gl.object_type_code='L' ) gasl US Show Responsibilities 8 40 1=1 nvl2(gasl.ledger_id,r.summary_accounts_form,null)='Y' LOV custom Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where :$flex$.show_responsibilities='Y' and flvv.lookup_type='YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code desc Y US Summary Accounts Allowed Available when Show Responsibilities is Yes. 9 1=1 nvl2(gasl.ledger_id,r.summary_accounts_form,null) is null N US Summary Accounts Allowed