My Oracle Support Banner

Receipt having Negative Code Combination ID Value for Secondary Ledger in XLA_AE_LINES (Doc ID 2171240.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


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.





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.