PFT 6.1.1 Install ORA- 02291 and ORA-04043 Errors Reported in the Installation Log File (Doc ID 2015782.1)

Last updated on MAY 29, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information 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:/opt/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:/opt/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 'INFODFASG_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 (CONFIGUSER.FK_BATCH_PARAMETER_MASTER_BATC) violated - parent key not found

Solution

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 hundreds of Community platforms