Hi All,
we are using OBIA 7964 with EBS source system when incremental loads are running PurchaseReceiptFact failure with the following error.
I checked the source and Stage Fact table, I could not find any duplicates in it. the task running from a year without any issue.
there were no changes in mapping as well as source side.
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6228 : Writing session output to log file [/Informatica/9.5.1/server/infa_shared/SessLogs/.SIL_PurchaseReceiptFact.DATAWAREHOUSE.log].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [.SIL_PurchaseReceiptFact.DATAWAREHOUSE.log] for session parameter:[$PMSessionLogFile].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [25075300] for mapping parameter:[MPLT_GET_ETL_PROC_WID.$$ETL_PROC_WID].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [N] for mapping parameter:[$$INSERT_ONLY_FLG].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [E] for mapping parameter:[mplt_SIL_PurchaseReceiptFact.$$LANGUAGE_CODE].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [] for mapping parameter:[mplt_SIL_PurchaseReceiptFact.$$MASTER_CODE_NOT_FOUND].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [] for mapping parameter:[mplt_SIL_PurchaseReceiptFact.$$SOURCE_CODE_NOT_SUPPLIED].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6014 : Initializing session [SIL_PurchaseReceiptFact] at [Mon Sep 04 20:45:21 2017].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6683 : Repository Name: [BIA_RS_PRD]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6684 : Server Name: [BIA_IS_PRD]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6686 : Folder: [SILOS]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6685 : Workflow: [SIL_PurchaseReceiptFact] Run Instance Name: [] Run Id: [911465]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6101 : Mapping name: SIL_PurchaseReceiptFact [version 1].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6963 : Pre 85 Timestamp Compatibility is Enabled
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6964 : Date format for the Session is [MM/DD/YYYY HH24:MI:SS]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6827 : [/Informatica/9.5.1/server/infa_shared/Storage] will be used as storage directory for session [SIL_PurchaseReceiptFact].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1805 : Recovery cache will be deleted when running in normal mode.
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1802 : Session recovery cache initialization is complete.
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6708 : Using configuration property [overrideMpltVarWithMapVar,Yes]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6708 : Using configuration property [AggSupprtWithNoPartLic,Yes]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6703 : Session [SIL_PurchaseReceiptFact] is run by 64-bit Integration Service [node01_nlaobixva01], version [9.5.1 HotFix2], build [0621].
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24058 : Running Partition Group [1].
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24000 : Parallel Pipeline Engine initializing.
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24001 : Parallel Pipeline Engine running.
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24003 : Initializing session run.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1569 : Server Mode: [UNICODE]
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1570 : Server Code page: [ISO 8859-1 Western European]
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6151 : The session sort order is [Binary].
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6156 : Using low precision processing.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6180 : Deadlock retry logic will not be implemented.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6187 : Session target-based commit interval is [10000].
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6307 : DTM error log disabled.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7022 : TShmWriter: Initialized
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21075 : Connecting to database [pobiee], user [SO_BAW_PROD]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [Lkp_W_PURCH_RCPT_F] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_INVENTORY_ORG_ID] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_INT_ORG_D] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_Primary] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_2nd] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_3rd] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_4th] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_STANDARD_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_PRIMARY_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_STANDARD_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_STANDARD_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_STANDARD_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_PRIMARY_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_PRODUCT_D_Product_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_Codes_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_D_Supplier_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.LKP_W_SUPPLIER_ACCOUNT_D] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_SHIPMENT_TYPE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_PAYMENT_TYPE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.lkp_W_XACT_TYPE_D_Line_Type_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.LKP_W_XACT_TYPE_D_CONSIGNED_TYPE_WID] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_Inventory_Product_D_Inventory_Prod_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_PRODUCT_D_Supplier_Prod_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.GET_GLOBAL_CURR_CODES_AND_RATE_TYPES] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Get_Etl_Proc_Wid.LKP_ETL_PROC_WID] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6007 : DTM initialized successfully for session [SIL_PurchaseReceiptFact]
2017-09-05 00:15:22 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24033 : All DTM Connection Info: [<NONE>].
2017-09-05 00:15:22 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24004 : PETL_24004 Starting pre-session tasks. : (Mon Sep 04 20:45:22 2017)
2017-09-05 00:15:22 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24027 : PETL_24027 Pre-session task completed successfully. : (Mon Sep 04 20:45:22 2017)
2017-09-05 00:15:22 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24006 : Starting data movement.
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6660 : Total Buffer Pool size is 32000000 bytes and Block size is 128000 bytes.
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [Lkp_W_PURCH_RCPT_F]: Lookup override sql to create cache: SELECT TARGET_TABLE.CHANGED_ON_DT AS CHANGED_ON_DT, TARGET_TABLE.AUX1_CHANGED_ON_DT AS AUX1_CHANGED_ON_DT, TARGET_TABLE.AUX2_CHANGED_ON_DT AS AUX2_CHANGED_ON_DT, TARGET_TABLE.AUX3_CHANGED_ON_DT AS AUX3_CHANGED_ON_DT, TARGET_TABLE.AUX4_CHANGED_ON_DT AS AUX4_CHANGED_ON_DT, TARGET_TABLE.DELETE_FLG AS DELETE_FLG, TARGET_TABLE.W_INSERT_DT AS W_INSERT_DT, TARGET_TABLE.ETL_PROC_WID AS ETL_PROC_WID, TARGET_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, TARGET_TABLE.INTEGRATION_ID AS INTEGRATION_ID FROM W_PURCH_RCPT_FS STAGE_TABLE, W_PURCH_RCPT_F TARGET_TABLE
WHERE
STAGE_TABLE.DATASOURCE_NUM_ID = TARGET_TABLE.DATASOURCE_NUM_ID AND
STAGE_TABLE.INTEGRATION_ID = TARGET_TABLE.INTEGRATION_ID
ORDER BY
TARGET_TABLE.DATASOURCE_NUM_ID,
TARGET_TABLE.INTEGRATION_ID -- ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,DELETE_FLG,W_INSERT_DT,ETL_PROC_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [Lkp_W_PURCH_RCPT_F] from [1048576] to [1392640].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_2) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM]: Default sql to create lookup cache: SELECT BASE_UOM_CODE,INTEGRATION_ID,DATASOURCE_NUM_ID,CURRENT_FLG FROM W_PRODUCT_D ORDER BY INTEGRATION_ID,DATASOURCE_NUM_ID,CURRENT_FLG
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_2) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM] from [1048576] to [1497088].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_3) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM]: Default sql to create lookup cache: SELECT PRIMARY_UOM_CODE,DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG FROM W_INVENTORY_PRODUCT_D ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_3) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM] from [1048576] to [1497088].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_4) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_INVENTORY_ORG_ID]: Default sql to create lookup cache: SELECT INVENTORY_ORG_WID,DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG FROM W_INVENTORY_PRODUCT_D ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_4) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_INVENTORY_ORG_ID] from [1048576] to [1497088].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_5) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INT_ORG_D]: Default sql to create lookup cache: SELECT INTEGRATION_ID,ROW_WID FROM W_INT_ORG_D ORDER BY ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_5) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INT_ORG_D] from [1048576] to [1050000].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_6) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_Primary]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_SUPPLIER_PRODUCT_D LOOKUP_TABLE ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_6) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_Primary] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_10) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM]: Default sql to create lookup cache: SELECT CONVERSION_RATE,TO_UOM_CODE,DATASOURCE_NUM_ID,INTEGRATION_ID FROM W_UOM_CONVERSION_G ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_10) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM] from [1048576] to [1392640].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_18) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_PRODUCT_D_Product_Wid]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_PRODUCT_D LOOKUP_TABLE, W_PURCH_RCPT_FS TARGET_STAGE
WHERE
LOOKUP_TABLE.INTEGRATION_ID = TARGET_STAGE.PRODUCT_ID AND
LOOKUP_TABLE.DATASOURCE_NUM_ID = TARGET_STAGE.DATASOURCE_NUM_ID
ORDER BY
LOOKUP_TABLE.DATASOURCE_NUM_ID,
LOOKUP_TABLE.INTEGRATION_ID,
LOOKUP_TABLE.EFFECTIVE_FROM_DT,
LOOKUP_TABLE.EFFECTIVE_TO_DT,
LOOKUP_TABLE.ROW_WID -- ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_18) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_PRODUCT_D_Product_Wid] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_19) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_Codes_UOM]: Lookup override sql to create cache: SELECT W_CODE_D.MASTER_CODE AS MASTER_CODE, W_CODE_D.SOURCE_CODE AS SOURCE_CODE, W_CODE_D.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID FROM W_CODE_D
WHERE
W_CODE_D.CATEGORY = 'UOM' AND
W_CODE_D.LANGUAGE_CODE = 'E' ORDER BY SOURCE_CODE,DATASOURCE_NUM_ID,MASTER_CODE
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_19) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_Codes_UOM] from [1048576] to [1050000].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_20) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_D_Supplier_Wid]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.SUPPLIER_ID AS SUPPLIER_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_PARTY_ORG_D LOOKUP_TABLE
WHERE LOOKUP_TABLE.SUPPLIER_ID IS NOT NULL ORDER BY DATASOURCE_NUM_ID,SUPPLIER_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_20) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_D_Supplier_Wid] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_21) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.LKP_W_SUPPLIER_ACCOUNT_D]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_SUPPLIER_ACCOUNT_D LOOKUP_TABLE ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_21) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.LKP_W_SUPPLIER_ACCOUNT_D] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_22) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_SHIPMENT_TYPE]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID FROM W_XACT_TYPE_D LOOKUP_TABLE ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_22) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_SHIPMENT_TYPE] from [1048576] to [1392640].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_27) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_Inventory_Product_D_Inventory_Prod_Wid]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_INVENTORY_PRODUCT_D LOOKUP_TABLE, W_PURCH_RCPT_FS TARGET_STAGE
WHERE
LOOKUP_TABLE.INTEGRATION_ID = TARGET_STAGE.INVENTORY_PROD_ID AND
LOOKUP_TABLE.DATASOURCE_NUM_ID = TARGET_STAGE.DATASOURCE_NUM_ID
ORDER BY
LOOKUP_TABLE.DATASOURCE_NUM_ID,
LOOKUP_TABLE.INTEGRATION_ID,
LOOKUP_TABLE.EFFECTIVE_FROM_DT,
LOOKUP_TABLE.EFFECTIVE_TO_DT,
LOOKUP_TABLE.ROW_WID -- ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_27) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_Inventory_Product_D_Inventory_Prod_Wid] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_29) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE]: Lookup override sql to create cache: SELECT W_EXCH_RATE_G.EXCH_RATE AS EXCH_RATE, W_EXCH_RATE_G.FROM_CURCY_CD AS FROM_CURCY_CD, W_EXCH_RATE_G.TO_CURCY_CD AS TO_CURCY_CD, W_EXCH_RATE_G.START_DT AS START_DT, W_EXCH_RATE_G.END_DT AS END_DT, W_EXCH_RATE_G.RATE_TYPE AS RATE_TYPE, W_EXCH_RATE_G.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID FROM W_EXCH_RATE_G,
(
SELECT
GLOBAL1_CURR_CODE REQUIRED_TO_CURR,
GLOBAL1_RATE_TYPE REQUIRED_RATE_TYPE,
DATASOURCE_NUM_ID DSN
FROM
W_GLOBAL_CURR_G
UNION
SELECT
GLOBAL2_CURR_CODE REQUIRED_TO_CURR,
GLOBAL2_RATE_TYPE REQUIRED_RATE_TYPE,
DATASOURCE_NUM_ID DSN
FROM
W_GLOBAL_CURR_G
UNION
SELECT
GLOBAL3_CURR_CODE REQUIRED_TO_CURR,
GLOBAL3_RATE_TYPE REQUIRED_RATE_TYPE,
DATASOURCE_NUM_ID DSN
FROM
W_GLOBAL_CURR_G
) GLOBAL_CURR
WHERE
W_EXCH_RATE_G.TO_CURCY_CD = GLOBAL_CURR.REQUIRED_TO_CURR AND
W_EXCH_RATE_G.RATE_TYPE = GLOBAL_CURR.REQUIRED_RATE_TYPE AND
W_EXCH_RATE_G.DATASOURCE_NUM_ID = GLOBAL_CURR.DSN ORDER BY FROM_CURCY_CD,TO_CURCY_CD,START_DT,END_DT,RATE_TYPE,DATASOURCE_NUM_ID,EXCH_RATE
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_29) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] from [40000000] to [40003584].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_29) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Data Cache] size for transformation [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] from [20000000] to [20004864].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_33) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [mplt_Curcy_Conversion_Rates.GET_GLOBAL_CURR_CODES_AND_RATE_TYPES]: Default sql to create lookup cache: SELECT GLOBAL1_CURR_CODE,GLOBAL2_CURR_CODE,GLOBAL3_CURR_CODE,GLOBAL1_RATE_TYPE,GLOBAL2_RATE_TYPE,GLOBAL3_RATE_TYPE,DEFAULT_LOC_RATE_TYPE,DATASOURCE_NUM_ID,TENANT_ID FROM W_GLOBAL_CURR_G ORDER BY DATASOURCE_NUM_ID,TENANT_ID,GLOBAL1_CURR_CODE,GLOBAL2_CURR_CODE,GLOBAL3_CURR_CODE,GLOBAL1_RATE_TYPE,GLOBAL2_RATE_TYPE,GLOBAL3_RATE_TYPE,DEFAULT_LOC_RATE_TYPE
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_33) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_Curcy_Conversion_Rates.GET_GLOBAL_CURR_CODES_AND_RATE_TYPES] from [1048576] to [1392640].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_34) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [mplt_Get_Etl_Proc_Wid.LKP_ETL_PROC_WID]: Default sql to create lookup cache: SELECT ETL_PROC_WID,ROW_WID FROM W_PARAM_G ORDER BY ROW_WID,ETL_PROC_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_34) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_Get_Etl_Proc_Wid.LKP_ETL_PROC_WID] from [1048576] to [1050000].
2017-09-05 00:15:22 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21438 : Reader: Source is [pobiee], user [SO_BAW_PROD]
2017-09-05 00:15:22 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16051 : Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16003 : Initialization completed successfully.
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8147 : Writer: Target is database [pobiee], user [SO_BAW_PROD], bulk mode [OFF]
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8221 : Target database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8397 : Appending output data to file [/Informatica/9.5.1/server/infa_shared/BadFiles/SIL_PurchaseReceiptFact.bad] (initial size [2169]).
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8124 : Target Table W_PURCH_RCPT_F :SQL INSERT statement:
INSERT INTO W_PURCH_RCPT_F(SUPPLIER_WID,PRODUCT_WID,INVENTORY_PROD_WID,SUPPLIER_PROD_WID,REQUESTOR_WID,PLANT_LOC_WID,INVENTORY_ORG_WID,STORAGE_LOC_WID,RCPT_LOC_WID,RCPT_ORG_WID,OPERATING_UNIT_ORG_WID,BUYER_WID,MVMNT_TYPE_WID,XACT_TYPE_WID,CONTRACT_REF_NUM,ORDERED_ON_DT_WID,RECEIVED_ON_DT_WID,RECEIVED_ON_TM_WID,RECEIVED_QTY,UNIT_STD_COST,UNIT_PRICE,RECEIVED_AMT,STD_COST_AMT,UOM_CODE,PURCH_RCPT_NUM,PURCH_RCPT_ITEM,PURCH_ORDER_NUM,PURCH_ORDER_ITEM,PURCH_SCHEDULE_NUM,PURCH_ORDER_INTG_ID,PURCH_SCHEDULE_INTG_ID,PURCH_RQSTN_NUM,PURCH_RQSTN_ITEM,RECEIPT_TEXT,DOC_CURR_CODE,LOC_CURR_CODE,LOC_EXCHANGE_RATE,GLOBAL1_EXCHANGE_RATE,GLOBAL2_EXCHANGE_RATE,GLOBAL3_EXCHANGE_RATE,CREATED_BY_WID,CHANGED_BY_WID,CREATED_ON_DT,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,DELETE_FLG,W_INSERT_DT,W_UPDATE_DT,DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,TENANT_ID,X_CUSTOM,LINE_TYPE_WID,PAYMENT_TYPE_WID,SHIPMENT_TYPE_WID,BLANKET_AGREEMENT_NUM,CONSIGNED_TYPE_WID,RECEIVED_ON_DT,DAYS_EARLY_RECEIPT_ALLOWED,DAYS_LATE_RECEIPT_ALLOWED,DUE_ON_DT,DUE_ON_DT_WID,XACT_SOURCE_WID,SUPPLIER_ACCOUNT_WID,RELEASE_NUM,PRIMARY_UOM_CONV_RATE,PRIMARY_UOM_CODE,STANDARD_UOM_CONV_RATE,STANDARD_UOM_CODE) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8124 : Target Table W_PURCH_RCPT_F :SQL UPDATE statement:
UPDATE W_PURCH_RCPT_F SET SUPPLIER_WID = ?, PRODUCT_WID = ?, INVENTORY_PROD_WID = ?, SUPPLIER_PROD_WID = ?, REQUESTOR_WID = ?, PLANT_LOC_WID = ?, INVENTORY_ORG_WID = ?, STORAGE_LOC_WID = ?, RCPT_LOC_WID = ?, RCPT_ORG_WID = ?, OPERATING_UNIT_ORG_WID = ?, BUYER_WID = ?, MVMNT_TYPE_WID = ?, XACT_TYPE_WID = ?, CONTRACT_REF_NUM = ?, ORDERED_ON_DT_WID = ?, RECEIVED_ON_DT_WID = ?, RECEIVED_ON_TM_WID = ?, RECEIVED_QTY = ?, UNIT_STD_COST = ?, UNIT_PRICE = ?, RECEIVED_AMT = ?, STD_COST_AMT = ?, UOM_CODE = ?, PURCH_RCPT_NUM = ?, PURCH_RCPT_ITEM = ?, PURCH_ORDER_NUM = ?, PURCH_ORDER_ITEM = ?, PURCH_SCHEDULE_NUM = ?, PURCH_ORDER_INTG_ID = ?, PURCH_SCHEDULE_INTG_ID = ?, PURCH_RQSTN_NUM = ?, PURCH_RQSTN_ITEM = ?, RECEIPT_TEXT = ?, DOC_CURR_CODE = ?, LOC_CURR_CODE = ?, LOC_EXCHANGE_RATE = ?, GLOBAL1_EXCHANGE_RATE = ?, GLOBAL2_EXCHANGE_RATE = ?, GLOBAL3_EXCHANGE_RATE = ?, CREATED_BY_WID = ?, CHANGED_BY_WID = ?, CREATED_ON_DT = ?, CHANGED_ON_DT = ?, AUX1_CHANGED_ON_DT = ?, AUX2_CHANGED_ON_DT = ?, AUX3_CHANGED_ON_DT = ?, AUX4_CHANGED_ON_DT = ?, DELETE_FLG = ?, W_INSERT_DT = ?, W_UPDATE_DT = ?, ETL_PROC_WID = ?, TENANT_ID = ?, X_CUSTOM = ?, LINE_TYPE_WID = ?, PAYMENT_TYPE_WID = ?, SHIPMENT_TYPE_WID = ?, BLANKET_AGREEMENT_NUM = ?, CONSIGNED_TYPE_WID = ?, RECEIVED_ON_DT = ?, DAYS_EARLY_RECEIPT_ALLOWED = ?, DAYS_LATE_RECEIPT_ALLOWED = ?, DUE_ON_DT = ?, DUE_ON_DT_WID = ?, XACT_SOURCE_WID = ?, SUPPLIER_ACCOUNT_WID = ?, RELEASE_NUM = ?, PRIMARY_UOM_CONV_RATE = ?, PRIMARY_UOM_CODE = ?, STANDARD_UOM_CONV_RATE = ?, STANDARD_UOM_CODE = ? WHERE DATASOURCE_NUM_ID = ? AND INTEGRATION_ID = ?
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8124 : Target Table W_PURCH_RCPT_F :SQL DELETE statement:
DELETE FROM W_PURCH_RCPT_F WHERE DATASOURCE_NUM_ID = ? AND INTEGRATION_ID = ?
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8270 : Target connection group #1 consists of target(s) [W_PURCH_RCPT_F]
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8003 : Writer initialization complete.
2017-09-05 00:15:22 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16007 : Reader run started.
2017-09-05 00:15:22 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4029 : SQ Instance [Sq_W_PURCH_RCPT_FS] User specified SQL Query [SELECT W_PURCH_RCPT_FS.SUPPLIER_ID, W_PURCH_RCPT_FS.PRODUCT_ID, W_PURCH_RCPT_FS.INVENTORY_PROD_ID, W_PURCH_RCPT_FS.SUPPLIER_PROD_ID1, W_PURCH_RCPT_FS.SUPPLIER_PROD_ID2, W_PURCH_RCPT_FS.SUPPLIER_PROD_ID3, W_PURCH_RCPT_FS.SUPPLIER_PROD_ID4,
W_EMPLOYEE_D_REQUESTOR.ROW_WID REQUESTOR_WID, W_BUSN_LOCATION_D_PLANT.ROW_WID PLANT_LOC_WID,
W_INT_ORG_D_INVENTORY.ROW_WID INVENTORY_ORG_WID,
W_BUSN_LOCATION_D_STORAGE.ROW_WID STORAGE_LOC_WID,
W_BUSN_LOCATION_D_RCPT.ROW_WID RCPT_LOC_WID,
W_INT_ORG_D_RCPT.ROW_WID RCPT_ORG_WID,
W_INT_ORG_D_OPERATING_UNIT.ROW_WID OPERATING_UNIT_ORG_WID,
W_EMPLOYEE_D_BUYER.ROW_WID BUYER_WID,
W_MVMNT_TYPE_D.ROW_WID MVMNT_TYPE_WID,
W_PURCH_RCPT_FS.XACT_TYPE_ID, W_PURCH_RCPT_FS.CONTRACT_REF_NUM, W_PURCH_RCPT_FS.ORDERED_ON_DT, W_PURCH_RCPT_FS.RECEIVED_ON_DT, W_PURCH_RCPT_FS.RECEIVED_QTY, W_PURCH_RCPT_FS.UNIT_STD_COST, W_PURCH_RCPT_FS.UNIT_PRICE, W_PURCH_RCPT_FS.RECEIVED_AMT, W_PURCH_RCPT_FS.STD_COST_AMT, W_PURCH_RCPT_FS.UOM_CODE, W_PURCH_RCPT_FS.PURCH_RCPT_NUM, W_PURCH_RCPT_FS.PURCH_RCPT_ITEM, W_PURCH_RCPT_FS.PURCH_ORDER_NUM, W_PURCH_RCPT_FS.PURCH_ORDER_ITEM, W_PURCH_RCPT_FS.PURCH_SCHEDULE_NUM, W_PURCH_RCPT_FS.PURCH_ORDER_INTG_ID, W_PURCH_RCPT_FS.PURCH_SCHEDULE_INTG_ID, W_PURCH_RCPT_FS.PURCH_RQSTN_NUM, W_PURCH_RCPT_FS.PURCH_RQSTN_ITEM, W_PURCH_RCPT_FS.RECEIPT_TEXT, W_PURCH_RCPT_FS.DELETE_FLG, W_PURCH_RCPT_FS.REJECT_FLG, W_PURCH_RCPT_FS.DOC_CURR_CODE, W_PURCH_RCPT_FS.LOC_CURR_CODE, W_PURCH_RCPT_FS.LOC_EXCH_RATE_TYPE, W_PURCH_RCPT_FS.LOC_EXCHANGE_RATE, W_PURCH_RCPT_FS.EXCHANGE_DT, W_USER_D_CREATED.ROW_WID CREATED_BY_WID,
W_USER_D_CHANGED.ROW_WID CHANGED_BY_WID,
W_PURCH_RCPT_FS.CREATED_ON_DT, W_PURCH_RCPT_FS.CHANGED_ON_DT, W_PURCH_RCPT_FS.AUX1_CHANGED_ON_DT, W_PURCH_RCPT_FS.AUX2_CHANGED_ON_DT, W_PURCH_RCPT_FS.AUX3_CHANGED_ON_DT, W_PURCH_RCPT_FS.AUX4_CHANGED_ON_DT, W_PURCH_RCPT_FS.DATASOURCE_NUM_ID, W_PURCH_RCPT_FS.INTEGRATION_ID, W_PURCH_RCPT_FS.TENANT_ID, W_PURCH_RCPT_FS.X_CUSTOM, W_PURCH_RCPT_FS.LINE_TYPE_ID, W_PURCH_RCPT_FS.PAYMENT_TYPE_ID, W_PURCH_RCPT_FS.SHIPMENT_TYPE_ID, W_PURCH_RCPT_FS.BLANKET_AGREEMENT_NUM, W_PURCH_RCPT_FS.CONSIGNED_TYPE_ID, W_PURCH_RCPT_FS.DAYS_EARLY_RECEIPT_ALLOWED, W_PURCH_RCPT_FS.DAYS_LATE_RECEIPT_ALLOWED, W_PURCH_RCPT_FS.DUE_ON_DT,
W_XACT_SOURCE_D.ROW_WID XACT_SOURCE_WID,
W_PURCH_RCPT_FS.SUPPLIER_ACCOUNT_ID, W_PURCH_RCPT_FS.RELEASE_NUM
FROM
W_PURCH_RCPT_FS,
W_EMPLOYEE_D W_EMPLOYEE_D_REQUESTOR,
W_EMPLOYEE_D W_EMPLOYEE_D_BUYER,
W_INT_ORG_D W_INT_ORG_D_INVENTORY,
W_INT_ORG_D W_INT_ORG_D_RCPT,
W_INT_ORG_D W_INT_ORG_D_OPERATING_UNIT,
W_BUSN_LOCATION_D W_BUSN_LOCATION_D_PLANT,
W_BUSN_LOCATION_D W_BUSN_LOCATION_D_STORAGE,
W_BUSN_LOCATION_D W_BUSN_LOCATION_D_RCPT,
W_MVMNT_TYPE_D,
W_USER_D W_USER_D_CREATED,
W_USER_D W_USER_D_CHANGED,
W_XACT_SOURCE_D
WHERE
{
W_PURCH_RCPT_FS
LEFT OUTER JOIN W_EMPLOYEE_D_REQUESTOR ON
W_PURCH_RCPT_FS.REQUESTOR_ID = W_EMPLOYEE_D_REQUESTOR.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_EMPLOYEE_D_REQUESTOR.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_EMPLOYEE_D_REQUESTOR.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_EMPLOYEE_D_REQUESTOR.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_BUSN_LOCATION_D_PLANT ON
W_PURCH_RCPT_FS.PLANT_LOC_ID = W_BUSN_LOCATION_D_PLANT.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_BUSN_LOCATION_D_PLANT.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_BUSN_LOCATION_D_PLANT.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_BUSN_LOCATION_D_PLANT.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_INT_ORG_D_INVENTORY ON
W_PURCH_RCPT_FS.INVENTORY_ORG_ID = W_INT_ORG_D_INVENTORY.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_INT_ORG_D_INVENTORY.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_INT_ORG_D_INVENTORY.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_INT_ORG_D_INVENTORY.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_BUSN_LOCATION_D_STORAGE ON
W_PURCH_RCPT_FS.STORAGE_LOC_ID = W_BUSN_LOCATION_D_STORAGE.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_BUSN_LOCATION_D_STORAGE.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_BUSN_LOCATION_D_STORAGE.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_BUSN_LOCATION_D_STORAGE.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_BUSN_LOCATION_D_RCPT ON
W_PURCH_RCPT_FS.RCPT_LOC_ID = W_BUSN_LOCATION_D_RCPT.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_BUSN_LOCATION_D_RCPT.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_BUSN_LOCATION_D_RCPT.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_BUSN_LOCATION_D_RCPT.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_INT_ORG_D_RCPT ON
W_PURCH_RCPT_FS.RCPT_ORG_ID = W_INT_ORG_D_RCPT.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID =
W_INT_ORG_D_RCPT.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_INT_ORG_D_RCPT.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_INT_ORG_D_RCPT.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_INT_ORG_D_OPERATING_UNIT ON
W_PURCH_RCPT_FS.OPERATING_UNIT_ORG_ID = W_INT_ORG_D_OPERATING_UNIT.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_INT_ORG_D_OPERATING_UNIT.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_INT_ORG_D_OPERATING_UNIT.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_INT_ORG_D_OPERATING_UNIT.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_EMPLOYEE_D_BUYER ON
W_PURCH_RCPT_FS.BUYER_ID = W_EMPLOYEE_D_BUYER.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_EMPLOYEE_D_BUYER.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_EMPLOYEE_D_BUYER.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_EMPLOYEE_D_BUYER.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_MVMNT_TYPE_D ON
W_PURCH_RCPT_FS.MVMNT_TYPE_ID = W_MVMNT_TYPE_D.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_MVMNT_TYPE_D.DATASOURCE_NUM_ID
LEFT OUTER JOIN W_USER_D_CREATED ON
W_PURCH_RCPT_FS.CREATED_BY_ID = W_USER_D_CREATED.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_USER_D_CREATED.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_USER_D_CREATED.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_USER_D_CREATED.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_USER_D_CHANGED ON
W_PURCH_RCPT_FS. CHANGED_BY_ID = W_USER_D_CHANGED.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_USER_D_CHANGED.DATASOURCE_NUM_ID AND
W_PURCH_RCPT_FS.CREATED_ON_DT >= W_USER_D_CHANGED.EFFECTIVE_FROM_DT AND
W_PURCH_RCPT_FS.CREATED_ON_DT < W_USER_D_CHANGED.EFFECTIVE_TO_DT
LEFT OUTER JOIN W_XACT_SOURCE_D ON
W_PURCH_RCPT_FS.XACT_SOURCE_ID = W_XACT_SOURCE_D.INTEGRATION_ID AND
W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_XACT_SOURCE_D.DATASOURCE_NUM_ID
}]
2017-09-05 00:15:22 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4049 : RR_4049 SQL Query issued to database : (Mon Sep 04 20:45:22 2017)
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8005 : Writer run started.
2017-09-05 00:15:22 : INFO : (17891420 | WRITER_1_*_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : WRT_8158 :
*****START LOAD SESSION*****
Load Start Time: Mon Sep 04 20:45:22 2017
Target tables:
W_PURCH_RCPT_F
2017-09-05 00:15:22 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4011 : Informatica inner/outer join syntax found, SQL query converted to [SELECT
W_PURCH_RCPT_FS.SUPPLIER_ID , W_PURCH_RCPT_FS.PRODUCT_ID , W_PURCH_RCPT_FS.INVENTORY_PROD_ID , W_PURCH_RCPT_FS.SUPPLIER_PROD_ID1 , W_PURCH_RCPT_FS.SUPPLIER_PROD_ID2 , W_PURCH_RCPT_FS.SUPPLIER_PROD_ID3 , W_PURCH_RCPT_FS.SUPPLIER_PROD_ID4 , W_EMPLOYEE_D_REQUESTOR.ROW_WID REQUESTOR_WID , W_BUSN_LOCATION_D_PLANT.ROW_WID PLANT_LOC_WID , W_INT_ORG_D_INVENTORY.ROW_WID INVENTORY_ORG_WID , W_BUSN_LOCATION_D_STORAGE.ROW_WID STORAGE_LOC_WID , W_BUSN_LOCATION_D_RCPT.ROW_WID RCPT_LOC_WID , W_INT_ORG_D_RCPT.ROW_WID RCPT_ORG_WID , W_INT_ORG_D_OPERATING_UNIT.ROW_WID OPERATING_UNIT_ORG_WID , W_EMPLOYEE_D_BUYER.ROW_WID BUYER_WID , W_MVMNT_TYPE_D.ROW_WID MVMNT_TYPE_WID , W_PURCH_RCPT_FS.XACT_TYPE_ID , W_PURCH_RCPT_FS.CONTRACT_REF_NUM , W_PURCH_RCPT_FS.ORDERED_ON_DT , W_PURCH_RCPT_FS.RECEIVED_ON_DT , W_PURCH_RCPT_FS.RECEIVED_QTY , W_PURCH_RCPT_FS.UNIT_STD_COST , W_PURCH_RCPT_FS.UNIT_PRICE , W_PURCH_RCPT_FS.RECEIVED_AMT , W_PURCH_RCPT_FS.STD_COST_AMT , W_PURCH_RCPT_FS.UOM_CODE , W_PURCH_RCPT_FS.PURCH_RCPT_NUM , W_PURCH_RCPT_FS.PURCH_RCPT_ITEM , W_PURCH_RCPT_FS.PURCH_ORDER_NUM , W_PURCH_RCPT_FS.PURCH_ORDER_ITEM , W_PURCH_RCPT_FS.PURCH_SCHEDULE_NUM , W_PURCH_RCPT_FS.PURCH_ORDER_INTG_ID , W_PURCH_RCPT_FS.PURCH_SCHEDULE_INTG_ID , W_PURCH_RCPT_FS.PURCH_RQSTN_NUM , W_PURCH_RCPT_FS.PURCH_RQSTN_ITEM , W_PURCH_RCPT_FS.RECEIPT_TEXT , W_PURCH_RCPT_FS.DELETE_FLG , W_PURCH_RCPT_FS.REJECT_FLG , W_PURCH_RCPT_FS.DOC_CURR_CODE , W_PURCH_RCPT_FS.LOC_CURR_CODE , W_PURCH_RCPT_FS.LOC_EXCH_RATE_TYPE , W_PURCH_RCPT_FS.LOC_EXCHANGE_RATE , W_PURCH_RCPT_FS.EXCHANGE_DT , W_USER_D_CREATED.ROW_WID CREATED_BY_WID , W_USER_D_CHANGED.ROW_WID CHANGED_BY_WID , W_PURCH_RCPT_FS.CREATED_ON_DT , W_PURCH_RCPT_FS.CHANGED_ON_DT , W_PURCH_RCPT_FS.AUX1_CHANGED_ON_DT , W_PURCH_RCPT_FS.AUX2_CHANGED_ON_DT , W_PURCH_RCPT_FS.AUX3_CHANGED_ON_DT , W_PURCH_RCPT_FS.AUX4_CHANGED_ON_DT , W_PURCH_RCPT_FS.DATASOURCE_NUM_ID , W_PURCH_RCPT_FS.INTEGRATION_ID , W_PURCH_RCPT_FS.TENANT_ID , W_PURCH_RCPT_FS.X_CUSTOM , W_PURCH_RCPT_FS.LINE_TYPE_ID , W_PURCH_RCPT_FS.PAYMENT_TYPE_ID , W_PURCH_RCPT_FS.SHIPMENT_TYPE_ID , W_PURCH_RCPT_FS.BLANKET_AGREEMENT_NUM , W_PURCH_RCPT_FS.CONSIGNED_TYPE_ID , W_PURCH_RCPT_FS.DAYS_EARLY_RECEIPT_ALLOWED , W_PURCH_RCPT_FS.DAYS_LATE_RECEIPT_ALLOWED , W_PURCH_RCPT_FS.DUE_ON_DT , W_XACT_SOURCE_D.ROW_WID XACT_SOURCE_WID , W_PURCH_RCPT_FS.SUPPLIER_ACCOUNT_ID , W_PURCH_RCPT_FS.RELEASE_NUM
FROM
W_PURCH_RCPT_FS,
W_EMPLOYEE_D W_EMPLOYEE_D_REQUESTOR,
W_EMPLOYEE_D W_EMPLOYEE_D_BUYER,
W_INT_ORG_D W_INT_ORG_D_INVENTORY,
W_INT_ORG_D W_INT_ORG_D_RCPT,
W_INT_ORG_D W_INT_ORG_D_OPERATING_UNIT,
W_BUSN_LOCATION_D W_BUSN_LOCATION_D_PLANT,
W_BUSN_LOCATION_D W_BUSN_LOCATION_D_STORAGE,
W_BUSN_LOCATION_D W_BUSN_LOCATION_D_RCPT,
W_MVMNT_TYPE_D,
W_USER_D W_USER_D_CREATED,
W_USER_D W_USER_D_CHANGED,
W_XACT_SOURCE_D
WHERE
W_PURCH_RCPT_FS.REQUESTOR_ID = W_EMPLOYEE_D_REQUESTOR.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_EMPLOYEE_D_REQUESTOR.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_EMPLOYEE_D_REQUESTOR.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_EMPLOYEE_D_REQUESTOR.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.PLANT_LOC_ID = W_BUSN_LOCATION_D_PLANT.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_BUSN_LOCATION_D_PLANT.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_BUSN_LOCATION_D_PLANT.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_BUSN_LOCATION_D_PLANT.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.INVENTORY_ORG_ID = W_INT_ORG_D_INVENTORY.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_INT_ORG_D_INVENTORY.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_INT_ORG_D_INVENTORY.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_INT_ORG_D_INVENTORY.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.STORAGE_LOC_ID = W_BUSN_LOCATION_D_STORAGE.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_BUSN_LOCATION_D_STORAGE.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_BUSN_LOCATION_D_STORAGE.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_BUSN_LOCATION_D_STORAGE.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.RCPT_LOC_ID = W_BUSN_LOCATION_D_RCPT.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_BUSN_LOCATION_D_RCPT.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_BUSN_LOCATION_D_RCPT.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_BUSN_LOCATION_D_RCPT.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.RCPT_ORG_ID = W_INT_ORG_D_RCPT.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_INT_ORG_D_RCPT.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_INT_ORG_D_RCPT.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_INT_ORG_D_RCPT.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.OPERATING_UNIT_ORG_ID = W_INT_ORG_D_OPERATING_UNIT.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_INT_ORG_D_OPERATING_UNIT.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_INT_ORG_D_OPERATING_UNIT.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_INT_ORG_D_OPERATING_UNIT.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.BUYER_ID = W_EMPLOYEE_D_BUYER.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_EMPLOYEE_D_BUYER.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_EMPLOYEE_D_BUYER.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_EMPLOYEE_D_BUYER.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.MVMNT_TYPE_ID = W_MVMNT_TYPE_D.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_MVMNT_TYPE_D.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_BY_ID = W_USER_D_CREATED.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_USER_D_CREATED.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_USER_D_CREATED.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_USER_D_CREATED.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.CHANGED_BY_ID = W_USER_D_CHANGED.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_USER_D_CHANGED.DATASOURCE_NUM_ID(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT >= W_USER_D_CHANGED.EFFECTIVE_FROM_DT(+) AND W_PURCH_RCPT_FS.CREATED_ON_DT < W_USER_D_CHANGED.EFFECTIVE_TO_DT(+) AND W_PURCH_RCPT_FS.XACT_SOURCE_ID = W_XACT_SOURCE_D.INTEGRATION_ID(+) AND W_PURCH_RCPT_FS.DATASOURCE_NUM_ID = W_XACT_SOURCE_D.DATASOURCE_NUM_ID(+)
]
2017-09-05 00:15:27 : INFO : (17891420 | READER_1_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4050 : RR_4050 First row returned from database to reader : (Mon Sep 04 20:45:27 2017)
2017-09-05 00:15:27 : INFO : (17891420 | LKPDP_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6660 : Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
2017-09-05 00:15:27 : INFO : (17891420 | LKPDP_1:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21438 : Reader: Source is [pobiee], user [SO_BAW_PROD]
2017-09-05 00:15:27 : INFO : (17891420 | LKPDP_1:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16051 : Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:27 : INFO : (17891420 | LKPDP_1:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16003 : Initialization completed successfully.
2017-09-05 00:15:27 : INFO : (17891420 | LKPDP_1:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16007 : Reader run started.
2017-09-05 00:15:27 : INFO : (17891420 | LKPDP_1:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4049 : RR_4049 SQL Query issued to database : (Mon Sep 04 20:45:27 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4050 : RR_4050 First row returned from database to reader : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21079 : DBG_21079 Creating Lookup Cache : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16008 : Reader run completed.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21682 : Lookup table row count : 20758
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21297 : Lookup cache row count : 20758
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21294 : DBG_21294 Lookup cache creation completed : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1671 : Created new cache files PMLKUP3379_18_0_911465A64.[dat/idx] in directory /Informatica/9.5.1/server/infa_shared/Cache for Lookup [Lkp_W_PURCH_RCPT_F].
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21641 : Lkp_W_PURCH_RCPT_F: Index cache size = [1392640], Data cache size = [2097152]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_1:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21216 : Finished transformations for Source Qualifier [Lkp_W_PURCH_RCPT_F{{DSQ}}]. Total errors [0]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6660 : Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21438 : Reader: Source is [pobiee], user [SO_BAW_PROD]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16051 : Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16003 : Initialization completed successfully.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16007 : Reader run started.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4049 : RR_4049 SQL Query issued to database : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4050 : RR_4050 First row returned from database to reader : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16008 : Reader run completed.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21079 : DBG_21079 Creating Lookup Cache : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21682 : Lookup table row count : 1
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21297 : Lookup cache row count : 1
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21294 : DBG_21294 Lookup cache creation completed : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1671 : Created new cache files PMLKUP3379_458754_0_911465A64.[dat/idx] in directory /Informatica/9.5.1/server/infa_shared/Cache for Lookup [mplt_Get_Etl_Proc_Wid.LKP_ETL_PROC_WID].
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21641 : mplt_Get_Etl_Proc_Wid.LKP_ETL_PROC_WID: Index cache size = [1050000], Data cache size = [2097152]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_34:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21216 : Finished transformations for Source Qualifier [mplt_Get_Etl_Proc_Wid.LKP_ETL_PROC_WID{{DSQ}}]. Total errors [0]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_2) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6660 : Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_2:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21438 : Reader: Source is [pobiee], user [SO_BAW_PROD]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_2:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16051 : Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_2:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16003 : Initialization completed successfully.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_2:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16007 : Reader run started.
2017-09-05 00:15:57 : INFO : (17891420 | LKPDP_2:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4049 : RR_4049 SQL Query issued to database : (Mon Sep 04 20:45:57 2017)
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4050 : RR_4050 First row returned from database to reader : (Mon Sep 04 20:45:58 2017)
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21079 : DBG_21079 Creating Lookup Cache : (Mon Sep 04 20:45:58 2017)
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16008 : Reader run completed.
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21682 : Lookup table row count : 154938
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21297 : Lookup cache row count : 147666
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21294 : DBG_21294 Lookup cache creation completed : (Mon Sep 04 20:45:58 2017)
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1671 : Created new cache files PMLKUP3379_1638403_0_911465A64.[dat/idx] in directory /Informatica/9.5.1/server/infa_shared/Cache for Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM].
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21641 : MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM: Index cache size = [1497088], Data cache size = [2097152]
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_2:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21216 : Finished transformations for Source Qualifier [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM{{DSQ}}]. Total errors [0]
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_3) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6660 : Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_3:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21438 : Reader: Source is [pobiee], user [SO_BAW_PROD]
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_3:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16051 : Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_3:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16003 : Initialization completed successfully.
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_3:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16007 : Reader run started.
2017-09-05 00:15:58 : INFO : (17891420 | LKPDP_3:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4049 : RR_4049 SQL Query issued to database : (Mon Sep 04 20:45:58 2017)
2017-09-05 00:16:02 : INFO : (17891420 | LKPDP_3:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : RR_4050 : RR_4050 First row returned from database to reader : (Mon Sep 04 20:46:02 2017)
2017-09-05 00:16:02 : INFO : (17891420 | LKPDP_3:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21079 : DBG_21079 Creating Lookup Cache : (Mon Sep 04 20:46:02 2017)
2017-09-05 00:16:50 : INFO : (17891420 | LKPDP_3:READER_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : BLKR_16008 : Reader run completed.
2017-09-05 00:16:50 : INFO : (17891420 | LKPDP_3:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21682 : Lookup table row count : 7001277
2017-09-05 00:16:50 : INFO : (17891420 | LKPDP_3:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21297 : Lookup cache row count : 6959921
2017-09-05 00:16:50 : INFO : (17891420 | LKPDP_3:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21294 : DBG_21294 Lookup cache creation completed : (Mon Sep 04 20:46:50 2017)
2017-09-05 00:16:50 : INFO : (17891420 | LKPDP_3:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1671 : Created new cache files PMLKUP3379_1638404_0_911465A64.[dat/idx] in directory /Informatica/9.5.1/server/infa_shared/Cache for Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM].
2017-09-05 00:16:50 : INFO : (17891420 | LKPDP_3:TRANSF_1_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21641 : MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM: Index cache size = [1497088], Data