ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 2DFCD69525DAF858E06369FB09059C54Y select nvl(gl.short_name, gl.name) Ledger, haou.name Operating_Unit, crb.build_id Build_Id, crb.to_date Run_To_Date, crb.creation_date Creation_Date, crb.last_update_date Last_Update_Date, fu_created.user_name Created_By, fu_last_updated.user_name Last_Updated_By, crb.request_id Request_Id from cst_reconciliation_build crb, hr_organization_information hoi, hr_all_organization_units_vl haou, -- operating unit -- Revision for version 1.2 gl_ledgers gl, fnd_user fu_created, fnd_user fu_last_updated where hoi.org_information_context = 'Operating Unit Information' and hoi.organization_id = haou.organization_id -- this gets the operating unit id and crb.operating_unit_id = haou.organization_id -- Revision for version 1.2 and gl.ledger_id = to_number(hoi.org_information3) -- this joins OU to GL and fu_created.user_id = crb.created_by and fu_last_updated.user_id = crb.last_updated_by -- Revision for version 1.2 -- Revision for version 1.2, Operating Unit and Ledger Controls and Parameters and (nvl(fnd_profile.value('XXEN_REPORT_USE_LEDGER_SECURITY'),'N')='N' or 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 (nvl(fnd_profile.value('XXEN_REPORT_USE_OPERATING_UNIT_SECURITY'),'N')='N' or haou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)) and 1=1 -- p_beg_creation_date, p_operating_unit, p_ledger order by 1,2,3 US CAC AP Accrual Reconciliation Load Request Report to show when the A/P Accrual Reconciliation Load program was run and by whom, including the Ledger, Operating Unit, Build Id, Request Id, Creation Date and Last Updated By. Parameters: =========== Beginning Creation Date: enter the starting creation date to report, based on the operating unit for your session's inventory organization (optional). Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional). /* +=============================================================================+ -- | Copyright 2019 - 2025 Douglas Volz Consulting, Inc. -- | All rights reserved. -- | Permission to use this code is granted provided the original author is -- | acknowledged. No warranties, express or otherwise is included in this permission. -- +=============================================================================+ -- | -- | Original Author: Douglas Volz (doug@volzconsulting.com) -- | -- | Version Modified on Modified by Description -- | ======= =========== ============== ========================================= -- | 1.0 31 Oct 2019 Douglas Volz Initial Coding -- | 1.1 28 Jan 2025 Douglas Volz Added creation date parameter -- | 1.2 15 Feb 2025 Douglas Volz Added Operating Unit and Ledger Security -- | Profile Controls and parameters. -- +=============================================================================+*/ Enginatics 1=1 1 10 1=1 crb.creation_date >= :p_beg_creation_date Date select trunc(min(nvl(crb.creation_date,sysdate))) from cst_reconciliation_build crb where (crb.operating_unit_id in (select operating_unit from org_organization_definitions ood where ood.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) or fnd_profile.value('MFG_ORGANIZATION_ID') is null ) US Beginning Creation Date 2 20 1=1 haou.name = :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name US Operating Unit 3 30 1=1 gl.name = :p_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 xroa.id from xxen_report_org_access xroa where xroa.access_type='LEDGER') 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 US Ledger