My Oracle Support Banner

Y9C : Incremental DE Refresh With Run Skey Parameter Failing. (Doc ID 2495644.1)

Last updated on NOVEMBER 05, 2019

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.7 and later
Information in this document applies to any platform.

Goal

Post 807 Installation, To test the derived entity Incremental refresh feature, I have a copied a OOB DE DEFD0500 as RUNFLTR01 and tried to refresh the DE passing the run skey parameter to the DT FN_MV_INCREM_REFRESH as suggested in the 807 Documentation.

But it is failing with below error.

RUNFLTR01 - refresh failed for run skey 13950 and mis date 20170801. RUNFLTR01 has been droped while processing and MV physical table creation completed and Data load failed. PREBUILT MV not created. Data Backup available and MV Definition quey before execution available in the column V_DE_MV_DDL.SQL Error Code -14400 SQL Error - ORA-14400: inserted partition key does not map to any partition.

OFSAA_RUNSK_DE_RESAVE is the custom batch that I created as suggested by product team.
 

Solution

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
Goal
Solution


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