Errors While Applyng Patch 34356128: BEHAVIOR DETECTION 8.0.7.0.0 ML RELEASE #2 (8.0.7.2.0)
(Doc ID 2911681.1)
Last updated on NOVEMBER 30, 2022
Applies to:
Oracle Financial Services Behavior Detection Platform - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
Following errors are in the log file:
[Wed 16/11/2022 01:08:47] [OFS_BD] [ERROR] - Query:'
Update KDD_EFILE set SUBMISSION_MODE ='M' where SUBMISSION_MODE is NULL
'
Error:ORA-00904: "SUBMISSION_MODE": invalid identifier
[Wed 16/11/2022 01:08:48] [OFS_BD] [ERROR] - Query:'
UPDATE KDD_PERSON_ACCT PA SET PA.original_person_seq_id=(SELECT max(P.original_person_seq_id) FROM KDD_PERSON P WHERE P.CTR_ID=PA.CTR_ID AND P.PERSON_SEQ_ID=PA.PERSON_SEQ_ID AND P.INVLV_TYPE_CD=PA.INVLV_TYPE_CD) WHERE PA.ORIGINAL_PERSON_SEQ_ID IS NULL
'
Error:ORA-00904: "PA"."ORIGINAL_PERSON_SEQ_ID": invalid identifier
[Wed 16/11/2022 01:04:47] [OFS_BD] [ERROR] - Query:'
insert into MENU_FUNCTION_MAP (MENU_ID, FUNCTION_CODE, DSN_ID, APP_ID)
values (163, 'ADVANCED', 'FCCMINFO', 'OFS_FCCM')
'
Error:ORA-02291: integrity constraint (OFSAACONF.MENU_FUNCTION_MAP_FK_1) violated - parent key not found
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 |