My Oracle Support Banner

Error:ORA-01400: cannot insert NULL into ("<config>"."PR2_RUN_B"."V_FOLDER_NAME") Installing Patch (Doc ID 2391175.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.4 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When installing Oracle Financial Services Enterprise Financial Performance Analytics (EFPA) <Patch 26423457> - ADD ABILITY TO LOAD DATA FROM MULTIPLE MANAGEMENT LEDGER TABLES INTO EFPA, the following errors occurs in the OFS_PFT_patch_installation.log:

Error:ORA-01400: cannot insert NULL into ("<config>"."PR2_RUN_B"."V_FOLDER_NAME")

The error occurs when executing Run_Mgmt_ledger_to_mgmt_report.sql which contains a merge like the following:

MERGE INTO PR2_RUN_B T
USING (
SELECT '1510835197263' V_RUN_ID,'##INFODOM##' V_INFODOM_NAME,'MGMT_LEDGER_TO_MGMT_REPORT' V_RUN_NAME,'0' N_RUN_VERSION,'BR' V_RUN_TYPE_CODE,to_date('01-01-2011','dd-mm-yyyy') D_EFFECTIVE_START_DATE,to_date('31-12-2100','dd-mm-yyyy') D_EFFECTIVE_END_DATE,'Y' F_ACTIVE_FLAG,'##SEGMENT##' V_FOLDER_NAME,'A' V_LAST_OPERATION_TYPE_CODE,'' V_SEEDED_BY,'##REVUSER##' V_CREATED_BY,sysdate D_CREATED_DATE,'' V_LAST_MODIFIED_BY,sysdate D_LAST_MODIFIED_DATE,'##REVUSER##' V_LAST_AUTHORIZED_BY,sysdate D_LAST_AUTHORIZED_DATE,'en_US' SOURCE_LANG FROM DUAL
.
.
.
etc.

It appears the parameter ##SEGMENT## is not getting replaced with a valid folder name.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.