My Oracle Support Banner

After Applying PFT 8.0.2 Found ORA-12899 Value Too Large for Column on Insert to BATCH_PARAMETER_MASTER (Doc ID 2169850.1)

Last updated on MARCH 17, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 to 8.0.2 [Release 8]
Oracle Financial Services Profitability Management - Version 8.0.2 to 8.0.2 [Release 8]
Oracle Financial Services Funds Transfer Pricing - Version 8.0.2 to 8.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

After applying PFT 8.0.2 Patch 23054124 found the following error in OFS_PFT_patch_installation.log.

Error:

INSERT
 (V_RULE_ID,V_INFODOM_NAME,V_OBJECT_UNIQUE_NAME,V_OBJECT_LOCATION_CODE,V_MEMBER_UNIQUE_NAME,V_MEMBER_TYPE_CODE,N_MEMBER_ORDER,F_DEFAULT_FLAG)
VALUES
 (S.V_RULE_ID,S.V_INFODOM_NAME,S.V_OBJECT_UNIQUE_NAME,S.V_OBJECT_LOCATION_CODE,S.V_MEMBER_UNIQUE_NAME,S.V_MEMBER_TYPE_CODE,S.N_MEMBER_ORDER,S.F_DEFAULT_FLAG )'
 Error:ORA-02291: integrity constraint (OFSAACONF.FK_PR2_RULE_OBJECT_MEMBER_1) violated - parent key not found

INSERT
 (V_BATCH_ID,V_TASK_ID,I_PARAMETER_ORDER,V_PARAMETER_NAME,V_PARAMETER_VALUE)
VALUES
 (S.V_BATCH_ID,S.V_TASK_ID,S.I_PARAMETER_ORDER,S.V_PARAMETER_NAME,S.V_PARAMETER_VALUE )'
 Error:ORA-12899: value too large for column "OFSAACONF"."BATCH_PARAMETER_MASTER"."V_BATCH_ID" (actual: 42, maximum: 41)


Steps To Replicate:

1. Applied PFT 8.0.0 and did not faced any error during the installation.
2. Applied PFT 8.0.2 and found the error above in OFS_PFT_patch_installation.log.

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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