Receipt having Negative Code Combination ID Value for Secondary Ledger in XLA_AE_LINES
Last updated on AUGUST 21, 2016
Applies to:Oracle Receivables - 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 :
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms