PFT 6.1.1 Install ORA- 02291 and ORA-04043 Errors Reported in the Installation Log File
(Doc ID 2015782.1)
Last updated on JUNE 07, 2021
Applies to:
Oracle Financial Services Profitability Management - Version 6.1 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Goal
Question 1: Is there any issue with the PFT 6.1.1 log errors?
[Tue 26/5/2015 05:56:53] [OFSPFT] [ INFO] - # of errors in file=1
[Tue 26/5/2015 05:56:53] [OFSPFT] [ INFO] - Number of lines Read: 126
[Tue 26/5/2015 05:56:53] [OFSPFT] [ INFO] - Executing file:/OFSAA/scripts/atomic/create/fn_fsi_adjust_amort_pipe_pft.sql
[Tue 26/5/2015 05:56:54] [OFSPFT] [ERROR] - Query:'drop function FSI_ADJUST_AMORT_PIPE'
Error:ORA-04043: object FSI_ADJUST_AMORT_PIPE does not exist
[Tue 26/5/2015 05:56:54] [OFSPFT] [ERROR] - Query:'drop type FSI_ADJUST_AMORT_TYPE_TYPE'
Error:ORA-04043: object FSI_ADJUST_AMORT_TYPE_TYPE does not exist
[Tue 26/5/2015 05:56:54] [OFSPFT] [ INFO] - # of errors in file=2
Question 2: Can the following PFT 6.1.1 log file error be ignored?
[Tue 26/5/2015 05:55:56] [OFSPFT] [ INFO] - Executing file:/OFSAA/scripts/config/insert/batch_parameter_master_mdb_object_appln_map.sql
[Tue 26/5/2015 05:55:56] [OFSPFT] [ERROR] - Query:'MERGE INTO BATCH_PARAMETER_MASTER e USING ( SELECT '<INFODOM>_MDB_OBJECT_APPLN_MAP' V_BATCH_ID, 'Task1' V_TASK_ID, 6 I_PARAMETER_ORDER, 'Batch Parameter' V_PARAMETER_NAME, 'Y' V_PARAMETER_VALUE from dual ) h ON ( e.V_BATCH_ID = h.V_BATCH_ID AND e.V_TASK_ID = h.V_TASK_ID AND e.V_PARAMETER_NAME = h.V_PARAMETER_NAME) WHEN MATCHED THEN UPDATE SET e.I_PARAMETER_ORDER= h.I_PARAMETER_ORDER, e.V_PARAMETER_VALUE= h.V_PARAMETER_VALUE WHEN NOT MATCHED THEN INSERT (V_BATCH_ID, V_TASK_ID, I_PARAMETER_ORDER, V_PARAMETER_NAME, V_PARAMETER_VALUE) VALUES ( h.V_BATCH_ID, h.V_TASK_ID, h.I_PARAMETER_ORDER, h.V_PARAMETER_NAME, h.V_PARAMETER_VALUE)'
Error:ORA-02291: integrity constraint (<CONFIG>.FK_BATCH_PARAMETER_MASTER_BATC) violated - parent key not found
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 |