ETL Package "PKG_HDI_PT" Completed But No Rows Inserted Into Target Table "HDM_PT" or "HDM_PRTY".

(Doc ID 2055231.1)

Last updated on JANUARY 22, 2016

Applies to:

Oracle Healthcare Analytics Data Integration - Version 3.0 and later
Information in this document applies to any platform.


When attempting to execute ETL via ODI for package "PKG_HDI_PT", the session is completing successfully but no rows being Inserted into HDM_PT or HDM_PRTY as expected. On the other hand, manually running the query yields  the expected results.

Execution of package "PKG_HDI_PT" should have inserted records into HDM_PT or HDM_PRTY tables..

1. Login to ODI.
2. In Designer Tab > Expand the “Oracle Healthcare Analytics Data Integration” Project
3. Expand the “DI_HDWF_INCREMENTAL_LOAD” folder
4. Expand the “Load_DI_HDWF_INCREMENTAL_LOAD_HDI_PT” folder
5. Expand Packages > PKG_HDI_PT > Scenarios > select PKG_OHADI_HDI_PT_INCREMENTAL Version 001
6. Execute the Scenario > Select "Logical Agent Name from the List Of Values (Instead of "Local (No@ Agent)") > OK > OK.
7. ETL completes successfully but no data is written to corresponding HDM tables. 



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