Data File Name not specified for below processes in <INFODOM> Error Applying 7.3.2.2 Patch (Doc ID 1563335.1)

Last updated on MARCH 26, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For a new OFSAAI installation, on applying <Patch: 16900399>: OFSAAI V7.3.2.0.0 MAINTENANCE RELEASE #2 (7.3.2.2.0), the following error occurs show in the log file:

ERROR
[OFSAAIUPDATE] [2013-06-11 13:08:18,413] Atomic Schema updated
[OFSAAIUPDATE] [2013-06-11 13:08:18,559] Data File Name not specified for below processes in INFODOM
[OFSAAIUPDATE] [2013-06-11 13:08:18,559] ---------------------------------------------------------------------
[OFSAAIUPDATE] [2013-06-11 13:08:18,669] 1267812168756 : NON SEC - STD Option II PM
[OFSAAIUPDATE] [2013-06-11 13:08:18,735] 1267813274233 : NON SEC FIRB - PM
[OFSAAIUPDATE] [2013-06-11 13:08:18,764] 1267821327429 : Non Sec IRB - PM
[OFSAAIUPDATE] [2013-06-11 13:08:18,797] 1269907462574 : IND NON SEC STD - PM
[OFSAAIUPDATE] [2013-06-11 13:08:18,821] 1269911386126 : USA NON SEC IRB - PM
[OFSAAIUPDATE] [2013-06-11 13:08:18,843] 1282874074974 : NON SEC - STD Option I PM
[OFSAAIUPDATE] [2013-06-11 13:08:18,843] ---------------------------------------------------------------------
[OFSAAIUPDATE] [2013-06-11 13:08:18,845] OFSAAI post patch execution started
[OFSAAIUPDATE] [2013-06-11 13:08:19,088] OFSAAI post patch execution completed successfully

New install with no F2T extracts.

The following queries from the 7.3.2.2 install guide return 0 rows:

SQL> select ppb.v_infodom_name,
ppb.v_process_name,
  2 3 ppb.n_process_version,
  4 ppb.f_active_flag,
  5 ppt.v_task_ref_unique_name,
  6 pptp.v_task_parameter_name,
  7 pptp.v_task_parameter_value
  8 from pr2_process_b ppb
  9 join pr2_process_task ppt on ppt.v_infodom_name = ppb.v_infodom_name
 10 and ppt.v_process_id = ppb.v_process_id
 11 and ppt.v_task_type_code = 'F2T'
 12 join pr2_process_task_parameter pptp on pptp.v_infodom_name =
 13 ppt.v_infodom_name
and pptp.v_process_id =
 14 15 ppt.v_process_id
 16 and pptp.n_task_id = ppt.n_task_id
 17 and pptp.v_task_parameter_name =
 18 'Data File Name'
 19 and UPPER(coalesce(trim(pptp.v_task_parameter_value),'NULL')) = 'NULL';

no rows selected

SQL> select prb.v_infodom_name,
prb.v_run_name,
  2 3 prb.n_run_version,
  4 prb.f_active_flag,
  5 pro.v_task_ref_unique_name,
  6 prop.v_object_parameter_name,
  7 prop.v_object_parameter_value
  8 from pr2_run_b prb
  9 join pr2_run_object pro on pro.v_infodom_name = prb.v_infodom_name
 10 and pro.v_run_id = prb.v_run_id
 11 and pro.v_task_type_code = 'F2T'
 12 join pr2_run_object_parameter prop on prop.v_infodom_name =
 13 pro.v_infodom_name
 14 and prop.v_run_id = pro.v_run_id
 15 and prop.v_task_ref_unique_name =
 16 pro.v_task_ref_unique_name
 17 and prop.v_object_parameter_name =
 18 'Data File Name'
 19 and UPPER(coalesce(trim(prop.v_object_parameter_value),'NULL')) = 'NULL';

no rows selected


The issue can be reproduced at will with the following steps:

1. New OFSAA installation
2. Apply 7.3.2.2

Cause

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