R12.1 : FAH Oracle Subledger Balance is having duplicate data (Doc ID 2228208.1)

Last updated on MARCH 23, 2017

Applies to:

Oracle Financials Accounting Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :   12.1.3 version, Other Issues


ACTUAL BEHAVIOR  
---------------
In Financial Accounting Hub, Oracle subledger balance is showing double amount for one specific day

EXPECTED BEHAVIOR
-----------------------
Expect to see data from external system reconciled with data imported in oracle Financials Accounting Hub (FAH)

STEPS
-----------------------
The issue can be reproduced with the following steps:
(Since this is a technical issue, data is visible using SQL)

1. Prepared data from external system
2. Import data in Oracle Applications
3. Check the table xla_ac_balances and found duplicates for 10-JAN-2017


Changes

 

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