My Oracle Support Banner

DGS VA - Account Mapper FSI_KICOND_ACCNT_MAP Partition Has Stale Stats (Doc ID 2824738.1)

Last updated on DECEMBER 05, 2021

Applies to:

Oracle Financial Services Data Governance for North America Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.


As part of all MDRMs testing, faced temp space issue while loading data origin table from mapper table due to stale stats in FSI_KICOND_ACCNT_MAP partitions.

Partition Highvalue

P236 237
P237 238 – This partition(P237) has stale stats due to gather stats performed using high value which 238 and we don’t have any data for 238 runskey.

P239 240
P240 241 -- This partition(P240) has stale stats due to gather stats performed using high value which 241 and we don’t have any data for 241 runskey

Failed Task –
Task10 - Task to run the final Mapper Insert Function - FN_ACCT_FINAL_MAPPER_INSERT
Error : "Data Origin table insertion got failed for run_skey 237 Error ORA-12801: error signaled in parallel query server P013, instance (1)
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP"


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.