XLA Import Initial Balances for Supporting References
Description
Categories: BI Publisher
Columns: Application Id, App Name, Ledger Id, Ledger Name, Code Combination Id, Concatenated Segments, Analytical Criterion Code, Analytical Criterion Type Code, Ac1, Ac2 ...
Columns: Application Id, App Name, Ledger Id, Ledger Name, Code Combination Id, Concatenated Segments, Analytical Criterion Code, Analytical Criterion Type Code, Ac1, Ac2 ...
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
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 |