XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Application Accounting Definition Validation Report
Application: Subledger Accounting
Source: Validate Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use
Short Name: XLAABACR_XML
DB package: XLA_XLAABACR_XMLP_PKG
Description: Application Accounting Definition Validation Report
Application: Subledger Accounting
Source: Validate Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use
Short Name: XLAABACR_XML
DB package: XLA_XLAABACR_XMLP_PKG
Run
XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
select * from ( select app.application_name ,lk11.meaning amb_context_dsp ,err.amb_context_code ,err.product_rule_code ,prt.name product_rule_name ,err.product_rule_type_code ,lk4.meaning product_rule_type_dsp ,err.line_definition_owner_code ,lk12.meaning line_definition_owner ,err.line_definition_code ,xld.name line_definition_name ,err.category_sequence_num ,err.message_category_code ,lk2.meaning message_category_dsp ,msg.message_number ,err.message_type_flag ,lk1.meaning message_type_dsp ,ect.event_class_code ,ect.name event_class_name ,ett.event_type_code ,ett.name event_type_name ,err.description_code ,dt.name description_name ,err.description_type_code ,lk5.meaning description_type_dsp ,err.extract_object_name ,err.extract_object_type_code ,lk3.meaning extract_object_type_dsp ,err.source_code ,st.name source_name ,err.source_type_code ,lk9.meaning source_type_dsp ,err.analytical_criterion_code ,act.name analytical_criterion_name ,err.analytical_criterion_type_code ,lk6.meaning analytical_criterion_type_dsp ,err.accounting_line_code ,acb.name accounting_line_name ,err.accounting_line_type_code ,lk7.meaning accounting_line_type_dsp ,err.mapping_set_code ,mst.name mapping_set_name ,err.segment_rule_code ,srt.name segment_rule_name ,err.segment_rule_type_code ,lk8.meaning segment_rule_type_dsp ,err.accounting_source_code ,err.mapping_group_code ,lk10.meaning mapping_group_dsp ,ast1.name accounting_source_name ,err.mpa_accounting_line_code ,malt.name mpa_accounting_line_name ,err.mpa_accounting_line_type_code ,lk13.meaning mpa_accounting_line_type_dsp ,msg.message_text from xla_amb_setup_errors err ,xla_product_rules_tl prt ,xla_line_definitions_tl xld ,xla_event_classes_tl ect ,xla_event_types_tl ett ,xla_descriptions_tl dt ,xla_analytical_hdrs_tl act ,xla_acct_line_types_tl acb ,xla_acct_line_types_tl malt ,xla_sources_tl st ,xla_acct_attributes_tl ast1 ,xla_mapping_sets_tl mst ,xla_seg_rules_tl srt ,fnd_new_messages msg ,fnd_application_vl app ,xla_lookups lk1 ,xla_lookups lk2 ,xla_lookups lk3 ,xla_lookups lk4 ,xla_lookups lk5 ,xla_lookups lk6 ,xla_lookups lk7 ,xla_lookups lk8 ,xla_lookups lk9 ,xla_lookups lk10 ,xla_lookups lk11 ,xla_lookups lk12 ,xla_lookups lk13 where msg.message_name = err.message_name and msg.application_id = 602 and msg.language_code = USERENV('LANG') and app.application_id = err.application_id and prt.application_id(+) = err.application_id and prt.amb_context_code(+) = err.amb_context_code and prt.product_rule_code(+) = err.product_rule_code and prt.product_rule_type_code(+) = err.product_rule_type_code and prt.language(+) = USERENV('LANG') and xld.application_id(+) = err.application_id and xld.amb_context_code(+) = err.amb_context_code and xld.event_class_code(+) = err.event_class_code and xld.event_type_code(+) = err.event_type_code and xld.line_definition_owner_code(+) = err.line_definition_owner_code and xld.line_definition_code(+) = err.line_definition_code and xld.language(+) = USERENV('LANG') and ect.application_id(+) = err.application_id and ect.event_class_code(+) = err.event_class_code and ect.language(+) = USERENV('LANG') and ett.application_id(+) = err.application_id and ett.event_class_code (+) = err.event_class_code and ett.event_type_code(+) = err.event_type_code and ett.language(+) = USERENV('LANG') and dt.application_id(+) = err.application_id and dt.amb_context_code (+) = err.amb_context_code and dt.description_type_code(+) = err.description_type_code and dt.description_code(+) = err.description_code and dt.language(+) = USERENV('LANG') and st.application_id(+) = err.application_id and st.source_type_code(+) = err.source_type_code and st.source_code(+) = err.source_code and st.language(+) = USERENV('LANG') and ast1.accounting_attribute_code(+) = err.accounting_source_code and ast1.language(+) = USERENV('LANG') and acb.application_id(+) = err.application_id and acb.event_class_code(+) = err.event_class_code and acb.amb_context_code (+) = err.amb_context_code and acb.accounting_line_type_code(+) = err.accounting_line_type_code and acb.accounting_line_code(+) = err.accounting_line_code and acb.language(+) = USERENV('LANG') and malt.application_id(+) = err.application_id and malt.event_class_code(+) = err.event_class_code and malt.amb_context_code (+) = err.amb_context_code and malt.accounting_line_type_code(+) = err.mpa_accounting_line_type_code and malt.accounting_line_code(+) = err.mpa_accounting_line_code and malt.language(+) = USERENV('LANG') and act.analytical_criterion_code(+) = err.analytical_criterion_code and act.analytical_criterion_type_code(+) = err.analytical_criterion_type_code and act.amb_context_code(+) = err.amb_context_code and act.language(+) = USERENV('LANG') and mst.mapping_set_code(+) = err.mapping_set_code and mst.amb_context_code(+) = err.amb_context_code and mst.language(+) = USERENV('LANG') and srt.application_id(+) = err.application_id and srt.amb_context_code(+) = err.amb_context_code and srt.segment_rule_type_code(+) = err.segment_rule_type_code and srt.segment_rule_code(+) = err.segment_rule_code and srt.language(+) = USERENV('LANG') and lk1.lookup_code = err.message_type_flag and lk1.lookup_type = 'XLA_ERROR_TYPE' and lk2.lookup_code = err.message_category_code and lk2.lookup_type = 'XLA_AB_MESSAGE_CATEGORY' and lk3.lookup_code(+) = err.extract_object_type_code and lk3.lookup_type(+) = 'XLA_EXTRACT_OBJECT_TYPE' and lk4.lookup_code(+) = err.product_rule_type_code and lk4.lookup_type(+) = 'XLA_OWNER_TYPE' and lk5.lookup_code(+) = err.description_type_code and lk5.lookup_type(+) = 'XLA_OWNER_TYPE' and lk6.lookup_code(+) = err.analytical_criterion_type_code and lk6.lookup_type(+) = 'XLA_OWNER_TYPE' and lk7.lookup_code(+) = err.accounting_line_type_code and lk7.lookup_type(+) = 'XLA_OWNER_TYPE' and lk8.lookup_code(+) = err.segment_rule_type_code and lk8.lookup_type(+) = 'XLA_OWNER_TYPE' and lk9.lookup_code(+) = err.source_type_code and lk9.lookup_type(+) = 'XLA_SOURCE_TYPE' and lk10.lookup_code(+) = err.mapping_group_code and lk10.lookup_type(+) = 'XLA_ACCT_ATTR_ASSGN_GROUP' and lk11.lookup_code = err.amb_context_code and lk11.lookup_type = 'XLA_AMB_CONTEXT_TYPE' and lk12.lookup_code(+) = err.line_definition_owner_code and lk12.lookup_type(+) = 'XLA_OWNER_TYPE' and lk13.lookup_code(+) = err.mpa_accounting_line_type_code and lk13.lookup_type(+) = 'XLA_OWNER_TYPE' and err.amb_context_code = NVL(FND_PROFILE.value('XLA_AMB_CONTEXT'),'DEFAULT') &CP_QUERY &CP_JLD_SELECT &CP_JLD_FROM &CP_JLD_WHERE &CP_JLD_WHERE2 ) Q order by application_name, product_rule_name, product_rule_type_dsp, line_definition_name, line_definition_owner |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger |
|
LOV Oracle | |
Uncompiled Status Only |
|
LOV Oracle | |
Application |
|
LOV Oracle | |
Application Accounting Definition |
|
LOV Oracle | |
Application Accounting Definition Owner |
|
LOV Oracle |