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 03, 2023
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 |