Update Receivables Revenue Base Summary Failing with Duplicate Records (Doc ID 1612542.1)

Last updated on APRIL 03, 2015

Applies to:

Oracle Financials Intelligence - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

Getting the following error running FII_AR_REVENUE_B_C module: Update Receivables Revenue Base Summary

Checking for duplicate records in staging table.
There are duplicate records in the staging table.
This needs to be fixed before inserting records in FII_AR_REVENUE_B.
Created temp table fii_ar_uni_c
on_rec which stores
records that violate unique constraint on FII_AR_REVENUE_B. Please investigate
this table for duplicate records.

Patch 9368050 has been applied, and the following file versions exist:
fiidartreg.ldt 120.3.12010000.2
fiidart.odf 120.20.12010000.2
FIIAR18B.pls 120.96.12010000.2

 

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