XLA Complete Multiperiod Accounting

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Subledger Accounting
Source: Complete Multiperiod Accounting
Short Name: XLARPMPA
DB package: XLA_MULTIPERIOD_RPRTG_PKG
Run XLA Complete Multiperiod Accounting and other Oracle EBS reports with Blitz Report™ on our demo environment
               SELECT TABLE1.EVENT_ID
                     ,TABLE1.EVENT_CLASS
                     ,TABLE1.EVENT_TYPE
                     ,TABLE1.EVENT_NUMBER
                     ,TABLE1.EVENT_DATE
                     ,TABLE1.AE_HEADER_ID
                     ,TABLE1.LEDGER
                     ,TABLE1.GL_DATE
                     ,TABLE1.LEDGER_CURRENCY
                     ,TABLE1.AAD_NAME
                     ,TABLE1.AAD_VERSION
                     ,TABLE1.DESCRIPTION
                     ,TABLE1.JOURNAL_ENTRY_STATUS
                     ,TABLE1.MPA_TYPE
                     ,TABLE1.ACOUNTING_SEQUENCE_NAME
                     ,TABLE1.ACOUNTING_SEQUENCE_VERSION
                     ,TABLE1.ACCOUNTING_SEQUENCE_NUMBER
                     ,TABLE1.REPORTING_SEQUENCE_NAME
                     ,TABLE1.REPORTING_SEQUENCE_VERSION
                     ,TABLE1.REPORTING_SEQUENCE_NUMBER
                     ,TABLE1.DOCUMENT_SEQUENCE_NAME
                     ,TABLE1.DOCUMENT_SEQUENCE_VALUE
                     ,TABLE1.AE_LINE_NUM
                     ,TABLE1.ACCOUNTING_CLASS
                     ,TABLE1.LINE_NUMBER
                     ,TABLE1.ACCOUNT
                     ,TABLE1.CURRENCY
                     ,TABLE1.ENTERED_DEBIT
                     ,TABLE1.ENTERED_CREDIT
                     ,TABLE1.ACCOUNTED_DEBIT
                     ,TABLE1.ACCOUNTED_CREDIT
                     ,TABLE1.TOTAL_ACCTED_DEBITS
                     ,TABLE1.TOTAL_ACCTED_CREDITS
                     ,TABLE1.ERROR_NUMBER
                     ,TABLE1.ERROR_MESSAGE
                     ,substr(USERIDS,1,instr(USERIDS,'|',1,1)-1)                                                    USER_TRX_IDENTIFIER_NAME_1
                     ,substr(USERIDS,instr(USERIDS,'|',1,1)+1,(instr(USERIDS,'|',1,2)-1-instr(USERIDS,'|',1,1)))    USER_TRX_IDENTIFIER_VALUE_1
                     ,substr(USERIDS,instr(USERIDS,'|',1,2)+1,(instr(USERIDS,'|',1,3)-1-instr(USERIDS,'|',1,2)))    USER_TRX_IDENTIFIER_NAME_2
                     ,substr(USERIDS,instr(USERIDS,'|',1,3)+1,(instr(USERIDS,'|',1,4)-1-instr(USERIDS,'|',1,3)))    USER_TRX_IDENTIFIER_VALUE_2
                     ,substr(USERIDS,instr(USERIDS,'|',1,4)+1,(instr(USERIDS,'|',1,5)-1-instr(USERIDS,'|',1,4)))    USER_TRX_IDENTIFIER_NAME_3
                     ,substr(USERIDS,instr(USERIDS,'|',1,5)+1,(instr(USERIDS,'|',1,6)-1-instr(USERIDS,'|',1,5)))    USER_TRX_IDENTIFIER_VALUE_3
                     ,substr(USERIDS,instr(USERIDS,'|',1,6)+1,(instr(USERIDS,'|',1,7)-1-instr(USERIDS,'|',1,6)))    USER_TRX_IDENTIFIER_NAME_4
                     ,substr(USERIDS,instr(USERIDS,'|',1,7)+1,(instr(USERIDS,'|',1,8)-1-instr(USERIDS,'|',1,7)))    USER_TRX_IDENTIFIER_VALUE_4
                     ,substr(USERIDS,instr(USERIDS,'|',1,8)+1,(instr(USERIDS,'|',1,9)-1-instr(USERIDS,'|',1,8)))    USER_TRX_IDENTIFIER_NAME_5
                     ,substr(USERIDS,instr(USERIDS,'|',1,9)+1,(instr(USERIDS,'|',1,10)-1-instr(USERIDS,'|',1,9)))   USER_TRX_IDENTIFIER_VALUE_5
                     ,substr(USERIDS,instr(USERIDS,'|',1,10)+1,(instr(USERIDS,'|',1,11)-1-instr(USERIDS,'|',1,10))) USER_TRX_IDENTIFIER_NAME_6
                     ,substr(USERIDS,instr(USERIDS,'|',1,11)+1,(instr(USERIDS,'|',1,12)-1-instr(USERIDS,'|',1,11))) USER_TRX_IDENTIFIER_VALUE_6
                     ,substr(USERIDS,instr(USERIDS,'|',1,12)+1,(instr(USERIDS,'|',1,13)-1-instr(USERIDS,'|',1,12))) USER_TRX_IDENTIFIER_NAME_7
                     ,substr(USERIDS,instr(USERIDS,'|',1,13)+1,(instr(USERIDS,'|',1,14)-1-instr(USERIDS,'|',1,13))) USER_TRX_IDENTIFIER_VALUE_7
                     ,substr(USERIDS,instr(USERIDS,'|',1,14)+1,(instr(USERIDS,'|',1,15)-1-instr(USERIDS,'|',1,14))) USER_TRX_IDENTIFIER_NAME_8
                     ,substr(USERIDS,instr(USERIDS,'|',1,15)+1,(instr(USERIDS,'|',1,16)-1-instr(USERIDS,'|',1,15))) USER_TRX_IDENTIFIER_VALUE_8
                     ,substr(USERIDS,instr(USERIDS,'|',1,16)+1,(instr(USERIDS,'|',1,17)-1-instr(USERIDS,'|',1,16))) USER_TRX_IDENTIFIER_NAME_9
                     ,substr(USERIDS,instr(USERIDS,'|',1,17)+1,(instr(USERIDS,'|',1,18)-1-instr(USERIDS,'|',1,17))) USER_TRX_IDENTIFIER_VALUE_9
                     ,substr(USERIDS,instr(USERIDS,'|',1,18)+1,(instr(USERIDS,'|',1,19)-1-instr(USERIDS,'|',1,18))) USER_TRX_IDENTIFIER_NAME_10
                     ,substr(USERIDS,instr(USERIDS,'|',1,19)+1,(length(USERIDS)-instr(USERIDS,'|',1,19)))           USER_TRX_IDENTIFIER_VALUE_10
                 FROM (&C_ERRORS_COLS_QUERY
                       &p_trx_identifiers
                       &C_ERRORS_FROM_QUERY
                       &C_ERRORS_WHR_QUERY
                       &xah_appl_filter
                       &acct_batch_filter
                       &xae_appl_filter
                       &ent_appl_filter
                       &xal_appl_filter) TABLE1
                 WHERE :P_REPORT <> 'N'
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Process Category 
 
 LOV Oracle
End GL Date 
 
 Date
Errors Only 
 
 LOV Oracle
Report 
 
 LOV Oracle
Transfer to General Ledger 
 
 LOV Oracle
Post in Generate Ledger 
 
 LOV Oracle
General Ledger Batch Name 
 
 Char
Download
Related Blitz Reports
XLA Subledger Multiperiod Accounting and Accrual Reversal CE General Ledger Reconciliation GL Account Analysis XLA Subledger Period Close Exceptions JG EMEA VAT: Allocation Errors Listing INV Intercompany Invoice Reconciliation MSC Pegging Hierarchy AP Accounted Invoice Aging JTF Grid Datasources
Blitz Report™

Blitz Report™ provides multiple benefits: