ZRG6134R Duplicates Financial Transactions of Type Memorial Into fsa#postbak_fft

(Doc ID 2040713.1)

Last updated on AUGUST 14, 2015

Applies to:

Oracle Health Insurance Disbursements and Collections - Version 10.14.2.4 and later
Information in this document applies to any platform.

Symptoms

On production: 10.14.2.4 version, Usage

When attempting to run FIN2008S or FIN3024S for a receivable c.q. payable where the reference is a claim and a financial transactions exists of type Memorandum with the same reference
the following error occurs.

ERROR
-----------------------
FIN2008S gives FIN-2007 = FIN2008S029 : Receivable #1# has not been selected for collection, because not all the financial transactions with the same specification reference have been imported.
FIN3024S gives FIN-2008 = FIN3024S016 : Payable #1# has not been selected for payment, because not all the financial transactions with the same specification reference have been imported.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a financial transaction of type memorandum with id_oorsprong pointing to a claim
2. create a receivable/payable with id_oorsprong pointing to a claim as (1)
3. run FIN2008s or FIN3024s

Verify:
-----------------------
select * from FSA#POSTBAK_FFT
where sub_type ='M';

This query results in 1 or more rows when this problem exists

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proces payables and or receivables linked to claims for which such a financial transaction of type memorandum exists

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