XLA Validate Application Accounting Definitions - draft
Description
Categories: BI Publisher
Columns: Application Name, Amb Context Dsp, Amb Context Code, Product Rule Code, Product Rule Name, Product Rule Type Code, Product Rule Type Dsp, Line Definition Owner Code, Line Definition Owner, Line Definition Code ...
Columns: Application Name, Amb Context Dsp, Amb Context Code, Product Rule Code, Product Rule Name, Product Rule Type Code, Product Rule Type Dsp, Line Definition Owner Code, Line Definition Owner, Line Definition Code ...
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
Source: Validate Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use
Short Name: XLAABACR_XML
DB package: XLA_XLAABACR_XMLP_PKG
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 | ||
XLA_SRS_NO_VALIDATION | |||
Report Only Mode |