XLA Subledger Multiperiod Accounting and Accrual Reversal

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Report for the Accounting Program
Application: Subledger Accounting
Source: Subledger Multiperiod Accounting and Accrual Reversal Report
Short Name: XLARPMPX
DB package: XLA_MPA_ACCRUAL_RPRTG_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

               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  :L_RUN_REPORT <> 'N' --added for bug8977840
Download
 
Related Blitz Reports
XLA Complete Multiperiod Accounting XLA Subledger Period Close Exceptions (1) XLA Subledger Period Close Exceptions GL Account Analysis (Distributions) CE General Ledger Reconciliation COPY OF: XLA Subledger Period Close Exceptions GL Account Analysis Blitz Report Text Search JG EMEA VAT: Allocation Errors Listing
Blitz Report™

Blitz Report™ provides multiple benefits: