Receipt having Negative Code Combination ID Value for Secondary Ledger in XLA_AE_LINES
(Doc ID 2171240.1)
Last updated on APRIL 18, 2025
Applies to:
Oracle Receivables - Version 12.1.3 and laterOracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
Receipts were marked as successfully accounted in XLA and posted to GL while having xla_ae_lines.code_combination_id=-1.
Secondary Ledger Set-up was recently done.
SQL to Identify the corruption :
SELECT ledger_id,currency_code
FROM xla_ledger_relationships_v xlrv
WHERE xlrv.primary_ledger_id = &&Primary_ledger_id
AND xlrv.ledger_id <> primary_ledger_id
AND xlrv.relationship_enabled_flag = 'Y'
AND xlrv.ledger_category_code <> 'ALC'
AND exists (select 1 from xla_historic_control xhc
where xhc.primary_ledger = xlrv.primary_ledger_id
and xhc.secondary_alc_ledger =xlrv.ledger_id);
-- Pass the primary ledger Id as Input parameter.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |