ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 79E1F2C3BA4741AFA656F9F7CF91801FY select gl.name ledger, fav.application_name application, xecv.name event_class, xetv.name event_type, xe.event_date, xe.event_number, xte.transaction_number, nvl(xxen_util.meaning(xe.process_status_code,'XLA_EVENT_PROCESS_STATUS',602),xe.process_status_code) process_status, xxen_util.meaning(xe.event_status_code,'XLA_EVENT_STATUS',602) event_status, xxen_util.yes(xe.on_hold_flag) on_hold, xae.message_number, xae.encoded_msg message, xae.ae_line_num journal_line, xae.request_id, xxen_util.user_name(xae.created_by) created_by, xxen_util.client_time(xae.creation_date) creation_date, xte.entity_code, xae.event_id, xae.entity_id, xae.ae_header_id, xae.accounting_batch_id from xla_accounting_errors xae, fnd_application_vl fav, xla_events xe, xla_transaction_entities xte, gl_ledgers gl, xla_event_types_vl xetv, xla_event_classes_vl xecv where 1=1 and xae.application_id=fav.application_id and xae.event_id=xe.event_id(+) and xae.application_id=xe.application_id(+) and xae.entity_id=xte.entity_id(+) and xae.application_id=xte.application_id(+) and nvl(xae.ledger_id,xte.ledger_id)=gl.ledger_id(+) and xte.application_id=xetv.application_id(+) and xte.entity_code=xetv.entity_code(+) and xe.event_type_code=xetv.event_type_code(+) and xetv.application_id=xecv.application_id(+) and xetv.entity_code=xecv.entity_code(+) and xetv.event_class_code=xecv.event_class_code(+) order by gl.name, fav.application_name, xe.event_date, xte.transaction_number, xae.accounting_error_id US XLA Accounting Errors Errors and warnings of the subledger accounting program (Create Accounting) for each ledger, application, accounting event and transaction, as the Create Accounting output lists them with Errors Only = Yes. Run as the daily check of failed events, so that scheduled Create Accounting runs can use Errors Only = Yes or Report = Summary instead of writing every accounted line to their output. Request Id matches the Create Accounting request or one of its Accounting Program child requests. An accounting program run deletes the earlier errors of the events it processes, so the report shows the errors of each event's latest run. Enginatics R12 only 1=1 1 10 1=1 gl.name=:ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 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 coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) US Ledger 2 20 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 select fav.application_id id, fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name value US Application 3 30 1=1 xae.creation_date>=sysdate-:created_within_days Number US Created within Days 4 40 1=1 xae.request_id in (select fcr.request_id from fnd_concurrent_requests fcr where :request_id in (fcr.request_id,fcr.parent_request_id)) Number US Request Id