XLA Create and Assign Sources- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Create and Assign Sources Report
Application: Subledger Accounting
Source: Create and Assign Sources (XML) - Not Supported: Reserved For Future Use
Short Name: XLAABASR_XML
DB package: XLA_XLAABASR_XMLP_PKG
Description: Create and Assign Sources Report
Application: Subledger Accounting
Source: Create and Assign Sources (XML) - Not Supported: Reserved For Future Use
Short Name: XLAABASR_XML
DB package: XLA_XLAABASR_XMLP_PKG
Run
XLA Create and Assign Sources- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
select app.application_name ,ect.event_class_code ,ect.name event_class_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 ,err.extract_object_name ,err.extract_object_type_code ,lk3.meaning extract_object_type_dsp ,err.source_code ,err.source_type_code ,st.name source_name ,err.accounting_source_code ,err.mapping_group_code ,ast.name accounting_source_name ,msg.message_text ,lk4.meaning mapping_group_dsp ,err.extract_column_name ,err.language ,lk5.meaning source_type_dsp from xla_amb_setup_errors err ,xla_event_classes_tl ect ,xla_sources_tl st ,xla_acct_attributes_tl ast ,fnd_new_messages msg ,fnd_application_vl app ,xla_lookups lk1 ,xla_lookups lk2 ,xla_lookups lk3 ,xla_lookups lk4 ,xla_lookups lk5 where msg.message_name = err.message_name and msg.application_id = 602 and app.application_id = err.application_id and ect.application_id = err.application_id and ect.entity_code = err.entity_code and ect.event_class_code = err.event_class_code and ect.language = USERENV('LANG') and st.application_id(+) = err.source_application_id and st.source_type_code(+) = err.source_type_code and st.source_code(+) = err.source_code and st.language(+) = USERENV('LANG') and ast.accounting_attribute_code(+)= err.accounting_source_code and ast.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.mapping_group_code and lk4.lookup_type(+) = 'XLA_ACCT_ATTR_ASSGN_GROUP' and lk5.lookup_code(+) = err.source_type_code and lk5.lookup_type(+) = 'XLA_SOURCE_TYPE' and err.application_id = :P_APPLICATION_ID &CP_QUERY order by 1,3,4,6,5,7,19,9,22,21,20 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Mode |
|
LOV Oracle | |
Event Class |
|
LOV Oracle |