XLA Import Initial Balances for Supporting References
Description
Categories: BI Publisher
Application: Subledger Accounting
Source: Import Initial Balances for Supporting References
Short Name: XLAACSUPREF
DB package: XLA_AC_BALANCES_PKG
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 |