{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"6643954fc04f0d1d955722b3","instance_id":"e6b0674a-432c-407a-88bf-16b0fe1732a1","instance_version":5,"link_map":{"link416":{"dst_id":"ec4236ca-81c9-43e3-a49f-6937b2022b49","dst_view_id":"input0","src_id":"faac3b6c-ae07-41b4-a7a6-c949701b7e52","src_view_id":"outputRows","isGoto":false},"link421":{"dst_id":"83ec47d0-a3c0-47a0-a1a2-8ebef52eb226","dst_view_id":"input0","src_id":"5bdb055f-14e7-4574-a491-da9765afd717","src_view_id":"output0","isGoto":false},"link422":{"dst_id":"faac3b6c-ae07-41b4-a7a6-c949701b7e52","dst_view_id":"input103","src_id":"98e86011-bcfc-4aa3-b771-94af95031f24","src_view_id":"output0","isGoto":false},"link423":{"dst_id":"6d2a90ec-8cf5-4d9c-bafd-e69ab2ca4798","dst_view_id":"input0","src_id":"83ec47d0-a3c0-47a0-a1a2-8ebef52eb226","src_view_id":"output0","isGoto":false},"link424":{"dst_id":"f018b7fa-9ede-496e-90fb-686e7065ab33","dst_view_id":"input0","src_id":"e147aa6f-5cb9-4a94-8c46-1b124a486839","src_view_id":"output0","isGoto":false},"link425":{"dst_id":"e147aa6f-5cb9-4a94-8c46-1b124a486839","dst_view_id":"input0","src_id":"6d2a90ec-8cf5-4d9c-bafd-e69ab2ca4798","src_view_id":"output0","isGoto":false},"link426":{"dst_id":"bbea65a3-8ee4-4b67-8685-8fa43bd1f394","dst_view_id":"input0","src_id":"4fec137e-5ee9-42cb-803d-cc4ee836a427","src_view_id":"output0","isGoto":false},"link427":{"dst_id":"4fec137e-5ee9-42cb-803d-cc4ee836a427","dst_view_id":"input0","src_id":"f018b7fa-9ede-496e-90fb-686e7065ab33","src_view_id":"output102","isGoto":false},"link430":{"dst_id":"98e86011-bcfc-4aa3-b771-94af95031f24","dst_view_id":"input0","src_id":"42214a52-c68b-44bf-b458-c0a0f597990c","src_view_id":"outputRows","isGoto":false},"link442":{"dst_id":"5bdb055f-14e7-4574-a491-da9765afd717","dst_view_id":"input0","src_id":"fbb54403-470a-44b0-8890-88aac7e625a0","src_view_id":"output102","isGoto":false},"link443":{"dst_id":"fbb54403-470a-44b0-8890-88aac7e625a0","dst_view_id":"input101","src_id":"ec4236ca-81c9-43e3-a49f-6937b2022b49","src_view_id":"output0","isGoto":false}},"link_serial":444,"property_map":{"info":{"label":{"value":"V2_SILVERDATA_LOAD_RAPTOR_CAAPS-STAGE_PARENT"},"author":{"value":"a756144@fmr.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"error_behavior":{"value":"none"}},"settings":{"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]},"cache_pipelines":{"value":[]}},"input":{},"output":{}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"6597edc09f1b69c420b154f6","detail_map":{"42214a52-c68b-44bf-b458-c0a0f597990c":{"grid_x_int":1,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"98e86011-bcfc-4aa3-b771-94af95031f24":{"grid_x_int":2,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"faac3b6c-ae07-41b4-a7a6-c949701b7e52":{"grid_x_int":3,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"ec4236ca-81c9-43e3-a49f-6937b2022b49":{"grid_x_int":4,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}},"5bdb055f-14e7-4574-a491-da9765afd717":{"grid_x_int":6,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}},"83ec47d0-a3c0-47a0-a1a2-8ebef52eb226":{"grid_x_int":7,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"6d2a90ec-8cf5-4d9c-bafd-e69ab2ca4798":{"grid_x_int":8,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"e147aa6f-5cb9-4a94-8c46-1b124a486839":{"grid_x_int":9,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"f018b7fa-9ede-496e-90fb-686e7065ab33":{"grid_x_int":10,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"4fec137e-5ee9-42cb-803d-cc4ee836a427":{"grid_x_int":11,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"bbea65a3-8ee4-4b67-8685-8fa43bd1f394":{"grid_x_int":12,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}},"fbb54403-470a-44b0-8890-88aac7e625a0":{"grid_x_int":5,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"output":{},"input":{},"error":{}}}},"snap_map":{"42214a52-c68b-44bf-b458-c0a0f597990c":{"class_fqid":"com-snaplogic-snaps-oracle-select_3-main23721","class_id":"com-snaplogic-snaps-oracle-select","class_version":3,"instance_fqid":"42214a52-c68b-44bf-b458-c0a0f597990c_1","instance_id":"42214a52-c68b-44bf-b458-c0a0f597990c","instance_version":1,"property_map":{"info":{"label":{"value":"FILE NOTIF Select"},"notes":{}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"orderBy":{"value":[{"columns":{"value":"NOTIF_TMSTMP","expression":false}}]},"autoCommit":{"value":"False"},"maxRetryProp":{"value":3,"expression":false},"execution_mode":{"value":"Validate & Execute"},"matchDataTypes":{"value":false},"schemaName":{"value":"\"CAAPS_ENG\"","expression":false},"limitOffset":{"value":null,"expression":false},"retryIntervalProp":{"value":30,"expression":false},"nanosecondTimestampPrecision":{"value":false},"limitRows":{"value":"1","expression":false},"passThrough":{"value":true},"whereClause":{"value":"NOTIF_TYPE_CD='Security' and NOTIF_FILE_NAME LIKE '%AP161677%' and NOTIF_STATUS_CD='Received'","expression":false},"ignoreEmptyResult":{"value":false},"tableName":{"value":"\"CAAPS_ENG\".\"CORP_ACTION_FILE_NOTIF\"","expression":false},"fetchOutputFieldsInSchema":{"value":true},"outputFields":{"value":[{"outputField":{"value":"NOTIF_FILE_NAME","expression":false}},{"outputField":{"value":"CORP_ACTION_FILE_NOTIF_KEY","expression":false}},{"outputField":{"value":"NOTIF_TYPE_CD","expression":false}},{"outputField":{"value":"CORP_ACTION_DATA_PROVIDER_KEY","expression":false}},{"outputField":{"value":"NOTIF_STATUS_CD","expression":false}}]},"stagingMode":{"value":"In memory"}},"account":{"account_ref":{"value":{"label":{"value":"caaps_app_dit","label":"ap161677-caaps/caaps_app_dit","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"value":"f66cf14c-464f-4e4a-9e4e-b9cda2e9236d","expression":false}},"expression":false}},"view_serial":102,"input":{}},"class_build_tag":"main23721"},"98e86011-bcfc-4aa3-b771-94af95031f24":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-main23721","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"98e86011-bcfc-4aa3-b771-94af95031f24_1","instance_id":"98e86011-bcfc-4aa3-b771-94af95031f24","instance_version":1,"property_map":{"info":{"label":{"value":"Helper Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":true},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"value":"$CORP_ACTION_FILE_NOTIF_KEY","expression":true},"targetPath":{"value":"CORP_ACTION_FILE_NOTIF_KEY"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main23721"},"faac3b6c-ae07-41b4-a7a6-c949701b7e52":{"class_fqid":"com-snaplogic-snaps-oracle-select_3-main23721","class_id":"com-snaplogic-snaps-oracle-select","class_version":3,"instance_fqid":"faac3b6c-ae07-41b4-a7a6-c949701b7e52_1","instance_id":"faac3b6c-ae07-41b4-a7a6-c949701b7e52","instance_version":1,"property_map":{"info":{"label":{"value":"BATCH JOB TABLE Select"},"notes":{}},"output":{"outputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"orderBy":{"value":[]},"autoCommit":{"value":"False"},"maxRetryProp":{"value":3,"expression":false},"execution_mode":{"value":"Validate & Execute"},"matchDataTypes":{"value":false},"schemaName":{"value":"\"CAAPS_ENG\"","expression":false},"limitOffset":{"value":null,"expression":false},"retryIntervalProp":{"value":30,"expression":false},"nanosecondTimestampPrecision":{"value":false},"limitRows":{"value":"1","expression":false},"passThrough":{"value":true},"whereClause":{"value":"JOB_NAME='Sec Stage Pipeline'","expression":false},"ignoreEmptyResult":{"value":false},"tableName":{"value":"\"CAAPS_ENG\".\"CORP_ACTION_BATCH_JOB\"","expression":false},"fetchOutputFieldsInSchema":{"value":true},"outputFields":{"value":[{"outputField":{"value":"BATCH_JOB_KEY","expression":false}}]},"stagingMode":{"value":"In memory"}},"account":{"account_ref":{"value":{"label":{"value":"caaps_app_dit","label":"caaps_app_dit","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"value":"f66cf14c-464f-4e4a-9e4e-b9cda2e9236d","expression":false}},"expression":false}},"view_serial":103,"input":{"input103":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"main23721"},"ec4236ca-81c9-43e3-a49f-6937b2022b49":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-main23721","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"ec4236ca-81c9-43e3-a49f-6937b2022b49_1","instance_id":"ec4236ca-81c9-43e3-a49f-6937b2022b49","instance_version":1,"property_map":{"info":{"label":{"value":"B_JOB_LOG_MAPPER"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":true},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"value":"$original.CORP_ACTION_FILE_NOTIF_KEY","expression":true},"targetPath":{"value":"$BATCH_JOB_RUN_KEY"}},{"expression":{"value":"$BATCH_JOB_KEY","expression":true},"targetPath":{"value":"$BATCH_JOB_KEY"}},{"expression":{"value":"\"SYS\"","expression":true},"targetPath":{"value":"$CREATE_ID"}},{"expression":{"value":"Date.now().toLocaleDateTimeString({\"timeZone\":\"US/Eastern\"})","expression":true},"targetPath":{"value":"$CREATE_TMSTMP"}},{"expression":{"value":"Date.now().toLocaleDateTimeString({\"timeZone\":\"US/Eastern\"})","expression":true},"targetPath":{"value":"$JOB_START_TMSTMP"}},{"expression":{"value":"\"In Progress\"","expression":true},"targetPath":{"value":"$JOB_STATUS_CD"}},{"expression":{"value":"\"SYS\"","expression":true},"targetPath":{"value":"$UPDATE_ID"}},{"expression":{"value":"Date.now().toLocaleDateTimeString({\"timeZone\":\"US/Eastern\"})","expression":true},"targetPath":{"value":"$UPDATE_TMSTMP"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main23721"},"5bdb055f-14e7-4574-a491-da9765afd717":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-main23721","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"5bdb055f-14e7-4574-a491-da9765afd717_1","instance_id":"5bdb055f-14e7-4574-a491-da9765afd717","instance_version":1,"property_map":{"info":{"label":{"value":"MAP_FIELDS_FOR_EXECUTE_SNAP"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":false},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"value":"$original.original.CORP_ACTION_FILE_NOTIF_KEY","expression":true},"targetPath":{"value":"CORP_ACTION_FILE_NOTIF_KEY"}},{"expression":{"value":"$original.original.NOTIF_FILE_NAME.replace(\"s3://\",\"s3:///\")","expression":true},"targetPath":{"value":"$MESSAGE_FILE_URI"}},{"expression":{"value":"$original.original.CORP_ACTION_DATA_PROVIDER_KEY","expression":true},"targetPath":{"value":"CORP_ACTION_DATA_PROVIDER_KEY"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main23721"},"83ec47d0-a3c0-47a0-a1a2-8ebef52eb226":{"class_fqid":"com-snaplogic-snaps-flow-pipeexec_1-main25112","class_id":"com-snaplogic-snaps-flow-pipeexec","class_version":1,"instance_fqid":"83ec47d0-a3c0-47a0-a1a2-8ebef52eb226_3","instance_id":"83ec47d0-a3c0-47a0-a1a2-8ebef52eb226","instance_version":3,"property_map":{"info":{"label":{"value":"Staging Pipeline Execute"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"timeout":{"value":null,"expression":false},"pipeline":{"expression":false,"value":"V2_SILVERDATA_LOAD_RAPTOR_CAAPS-STAGE_CHILD"},"execLabel":{"expression":true,"value":null},"params":{"value":[{"paramValue":{"expression":true,"value":"$CORP_ACTION_FILE_NOTIF_KEY"},"paramName":{"value":"FILE_NOTIF_KEY"}},{"paramName":{"value":"FILE_URI"},"paramValue":{"value":"$MESSAGE_FILE_URI","expression":true}},{"paramName":{"value":"CORP_ACTION_DATA_PROVIDER_KEY"},"paramValue":{"value":"$CORP_ACTION_DATA_PROVIDER_KEY","expression":true}}]},"execution_mode":{"value":"Validate & Execute"},"snaplexGovernor":{"value":"SNAPLEX_WITH_PATH"},"retryInterval":{"value":null,"expression":false},"retryLimit":{"value":null,"expression":false},"reuse":{"value":false},"snaplex":{"expression":false},"executable_during_suggest":{"value":true},"batchSize":{"value":1},"poolSize":{"value":5,"expression":false},"loopDocument":{"expression":true}},"view_serial":100},"class_build_tag":"main25112"},"6d2a90ec-8cf5-4d9c-bafd-e69ab2ca4798":{"class_fqid":"com-snaplogic-snaps-flow-filter_2-main25112","class_id":"com-snaplogic-snaps-flow-filter","class_version":2,"instance_fqid":"6d2a90ec-8cf5-4d9c-bafd-e69ab2ca4798_1","instance_id":"6d2a90ec-8cf5-4d9c-bafd-e69ab2ca4798","instance_version":1,"property_map":{"info":{"label":{"value":"On Completion"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"filterExpression":{"expression":true,"value":"$state == 'COMPLETED'"},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main25112"},"e147aa6f-5cb9-4a94-8c46-1b124a486839":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-main23721","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"e147aa6f-5cb9-4a94-8c46-1b124a486839_1","instance_id":"e147aa6f-5cb9-4a94-8c46-1b124a486839","instance_version":1,"property_map":{"info":{"label":{"value":"Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"expression":true,"value":"\"Success\""},"targetPath":{"value":"NOTIF_STATUS_CD"}},{"expression":{"value":"$original.get('CORP_ACTION_FILE_NOTIF_KEY')","expression":true},"targetPath":{"value":"CORP_ACTION_FILE_NOTIF_KEY"}}]}}},"schemaName":{"value":null,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"updateCondition":{"value":null,"expression":false},"passThrough":{"value":false},"nullSafeAccess":{"value":false},"tableName":{"value":null,"expression":false},"sessionParamsProp":{"value":[]}},"view_serial":100},"class_build_tag":"main23721"},"f018b7fa-9ede-496e-90fb-686e7065ab33":{"class_fqid":"com-snaplogic-snaps-oracle-update_1-main25112","class_id":"com-snaplogic-snaps-oracle-update","class_version":1,"instance_fqid":"f018b7fa-9ede-496e-90fb-686e7065ab33_1","instance_id":"f018b7fa-9ede-496e-90fb-686e7065ab33","instance_version":1,"property_map":{"info":{"label":{"value":"FILE NOTIF Update"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Execute only"},"executable_during_suggest":{"value":false},"maxRetryProp":{"value":0,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"schemaName":{"value":"\"CAAPS_ENG\"","expression":false},"tableName":{"value":"\"CAAPS_ENG\".\"CORP_ACTION_FILE_NOTIF\"","expression":false},"updateCondition":{"value":"CORP_ACTION_FILE_NOTIF_KEY=$CORP_ACTION_FILE_NOTIF_KEY","expression":false},"sessionParamsProp":{"value":[]}},"account":{"account_ref":{"value":{"label":{"value":"caaps_app_dit","label":"caaps_app_dit","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"value":"f66cf14c-464f-4e4a-9e4e-b9cda2e9236d","expression":false}}}},"view_serial":102,"output":{"output102":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"main25112"},"4fec137e-5ee9-42cb-803d-cc4ee836a427":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-main23721","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"4fec137e-5ee9-42cb-803d-cc4ee836a427_1","instance_id":"4fec137e-5ee9-42cb-803d-cc4ee836a427","instance_version":1,"property_map":{"info":{"label":{"value":"UPDATE_MAPPER"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"passThrough":{"value":false},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"value":"Date.now().toLocaleDateTimeString({\"timeZone\":\"US/Eastern\"})","expression":true},"targetPath":{"value":"$UPDATE_TMSTMP"}},{"expression":{"value":"\"SYS\"","expression":true},"targetPath":{"value":"$UPDATE_ID"}},{"expression":{"value":"Date.now().toLocaleDateTimeString({\"timeZone\":\"US/Eastern\"})","expression":true},"targetPath":{"value":"$JOB_END_TMSTMP"}},{"expression":{"value":"\"Success\"","expression":true},"targetPath":{"value":"$JOB_STATUS_CD"}},{"expression":{"value":"$original.CORP_ACTION_FILE_NOTIF_KEY","expression":true},"targetPath":{"value":"BATCH_JOB_RUN_KEY"}}]}}},"nullSafeAccess":{"value":false}},"view_serial":100},"class_build_tag":"main23721"},"bbea65a3-8ee4-4b67-8685-8fa43bd1f394":{"class_fqid":"com-snaplogic-snaps-oracle-update_1-main25112","class_id":"com-snaplogic-snaps-oracle-update","class_version":1,"instance_fqid":"bbea65a3-8ee4-4b67-8685-8fa43bd1f394_1","instance_id":"bbea65a3-8ee4-4b67-8685-8fa43bd1f394","instance_version":1,"property_map":{"info":{"label":{"value":"B JOB LOG UPDATE"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Execute only"},"executable_during_suggest":{"value":false},"maxRetryProp":{"value":0,"expression":false},"retryIntervalProp":{"value":1,"expression":false},"schemaName":{"value":"\"CAAPS_ENG\"","expression":false},"tableName":{"value":"\"CAAPS_ENG\".\"CORP_ACTION_BATCH_JOB_LOG\"","expression":false},"updateCondition":{"value":"BATCH_JOB_RUN_KEY=$BATCH_JOB_RUN_KEY","expression":false},"sessionParamsProp":{"value":[]}},"account":{"account_ref":{"value":{"label":{"value":"caaps_app_dit","label":"caaps_app_dit","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"value":"f66cf14c-464f-4e4a-9e4e-b9cda2e9236d","expression":false}}}},"view_serial":102,"output":{}},"class_build_tag":"main25112"},"fbb54403-470a-44b0-8890-88aac7e625a0":{"class_fqid":"com-snaplogic-snaps-oracle-execute_1-main25112","class_id":"com-snaplogic-snaps-oracle-execute","class_version":1,"instance_fqid":"fbb54403-470a-44b0-8890-88aac7e625a0_1","instance_id":"fbb54403-470a-44b0-8890-88aac7e625a0","instance_version":1,"property_map":{"info":{"label":{"value":"Oracle - Execute"},"notes":{}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"sqlStatement":{"value":"INSERT INTO CAAPS_ENG.CORP_ACTION_BATCH_JOB_LOG\n(BATCH_JOB_RUN_KEY, BATCH_JOB_KEY, JOB_START_TMSTMP, JOB_STATUS_CD, CREATE_ID, CREATE_TMSTMP)\nVALUES($BATCH_JOB_RUN_KEY, $BATCH_JOB_KEY, TO_TIMESTAMP($JOB_START_TMSTMP, 'YYYY-MM-DD\"T\"HH24:MI:SS.FF3'), $JOB_STATUS_CD, $CREATE_ID, TO_TIMESTAMP($CREATE_TMSTMP, 'YYYY-MM-DD\"T\"HH24:MI:SS.FF3'))\n","expression":false},"queryType":{"value":"Auto","expression":false},"autoCommit":{"value":"Use account setting"},"maxRetryProp":{"value":0,"expression":false},"execution_mode":{"value":"Execute only"},"retryIntervalProp":{"value":1,"expression":false},"nanosecondTimestampPrecision":{"value":false},"passThrough":{"value":true},"ignoreEmptyResult":{"value":false},"executable_during_suggest":{"value":false}},"account":{"account_ref":{"value":{"label":{"value":"caaps_app_dit","label":"caaps_app_dit","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"value":"f66cf14c-464f-4e4a-9e4e-b9cda2e9236d","expression":false}}}},"view_serial":102,"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"output":{"output102":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"main25112"}},"path_id":"/fmr-fda-dev/ffio-shared/ap161677-caaps","path_snode":"658571a0281c2652dfed62a0","target_runtime":"standard"}