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

Last updated on AUGUST 21, 2016

Applies to:

Oracle Receivables - 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

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