XLA Import Initial Balances for Supporting References

➜ Back to Library
Description
Categories: BI Publisher
Application: Subledger Accounting
Source: Import Initial Balances for Supporting References
Short Name: XLAACSUPREF
DB package: XLA_AC_BALANCES_PKG
Run XLA Import Initial Balances for Supporting References and other Oracle EBS reports with Blitz Report™ on our demo environment
select  xla.application_id,
        app.application_short_name app_name,
        xla.ledger_id,
        gl.name ledger_name,
        xla.code_combination_id,
        cc.concatenated_segments,
        xla.analytical_criterion_code,
        xla.analytical_criterion_type_code,
        xla.AC1,
        xla.AC2,
        xla.AC3,
        xla.AC4,
        xla.AC5,
        xla.period_name,
        xla.init_balance_dr,
        xla.init_balance_cr,
        xla.message_codes
from    xla_ac_balances_int xla,
        fnd_application app,
        gl_ledgers gl,
        gl_code_combinations_kfv cc
where   xla.status = 'ERROR'
and     xla.application_id = app.application_id(+)
and     xla.ledger_id = gl.ledger_id(+)
and     xla.code_combination_id = cc.code_combination_id(+)
and     xla.batch_code = NVL(:P_BATCH_CODE,xla.batch_code)
order by    xla.application_id,
            app.application_short_name
Parameter Name SQL text Validation
Batch Code 
 
 LOV Oracle
Purge Mode 
 
 LOV Oracle
Download
Related Blitz Reports
GL Account Analysis AP Accounted Invoice Aging GL Account Analysis (Distributions) XLA Import Initial Balance for Third Party Control Account JA Third Party Detail Trial Balance with Contra Accounts GL Account Analysis (Distributions) 11g XLA Trial Balance - Raw Data GL Account Analysis 11g AP Open Balances Revaluation
Blitz Report™

Blitz Report™ provides multiple benefits: