Date Correction In AT Views To Pick Correct Latest Records.

(Doc ID 2338089.1)

Last updated on DECEMBER 20, 2017

Applies to:

Oracle Healthcare Foundation - Version 7.1.1 to 7.1.2 [Release 7.1]
Information in this document applies to any platform.

Symptoms

On : 7.1.1 version, Performance

When attempting to run Initial loads to HCD using Oracle supplied Informatica PowerCenter integration scripts, the load fail with the following error.

ERROR
-----------------------
The worksflows not properly marking the jobs complete -
14 10:18:26 : ERROR : (1200 | 139673057851136) : (IS | IS_Common_Datamart_Loaders_711) : node01 : LM_36320 : Session task instance [s_w_hcd_rx_line_fc_load_date]: Execution failed.
2017-10-14 10:18:26 : WARNING : (1200 | 139673057851136) : (IS | IS_Common_Datamart_Loaders_711) : node01 : LM_36331 : Session task instance [s_w_hcd_rx_line_fc_load_date] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [wf_SIL_HCD_W_HCD_RX_LINE_FC] will be failed.
2017-10-14 10:18:28 : ERROR : (1200 | 139673078830848) : (IS | IS_Common_Datamart_Loaders_711) : node01 : LM_36320 : Workflow [wf_SIL_HCD_W_HCD_RX_LINE_FC]: Execution failed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run wf_SIL_HCD_W_HCD_RX_LINE_FC from the HCD_INTIAL_LOAD folder in the Common_Datamart_Loaders repository.
2. Load failed.



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