Filtering stops being pushed into WHERE clause about oracle_fdw HOT 4 CLOSED

ALTER PROCEDURE name_of_procedure() SET plan_cache_mode = force_custom_plan;

shudslong01a=> alter procedure uds_long.copy_co_session() set plan_cache_mode = force_custom_plan;
ALTER PROCEDURE
shudslong01a=>  call uds_long.copy_co_session();
ERROR:  invalid transaction termination
CONTEXT:  PL/pgSQL function uds_long.copy_co_session() line 91 at COMMIT

create or replace procedure uds_long.copy_co_session()
 LANGUAGE plpgsql
 AS $$
 DECLARE

   v_run_date		TIMESTAMP;
   v_exit		BOOLEAN := FALSE;
   v_start_time		TIMESTAMP;
   v_end_time		TIMESTAMP;
   v_rows_processed	INTEGER;

   v_state                     TEXT;
   v_msg                       TEXT;
   v_detail                    TEXT;
   v_hint                      TEXT;
   v_context                   TEXT;

BEGIN


  WHILE v_exit = FALSE
  LOOP

     SELECT last_run_date
       INTO v_run_date
       FROM uds_long.copy_tracker
      WHERE table_name = 'co_session';

     /* Stop copying when caught up to current day - 2 */

     IF date_trunc('day', v_run_date) = date_trunc('day', now()) OR date_trunc('day', v_run_date) = date_trunc('day', now() - interval '1 day') THEN

        v_exit = TRUE;

     ELSE

        /* copy 1 day of data.  Putting inside a BEGIN/END block to allow committing between days if there are multiple days to copy */
        /* if there are multiple days to copy and 1 day fails the procedure will stop processing. */

        BEGIN
           v_start_time := clock_timestamp();


            INSERT into uds_long.co_session
   		   (SESSION_ID, ONE_PASS_USER_NAME, FIRST_NAME, LAST_NAME, EMAIL_ADDRESS, EXPIRES_TIME,SITE,
		   CREATED_TIME, SESSION_EXPIRES_TIME, PRISM_GUID, SATOKEN, SESSION_ENDED_DATE, SESSION_STATUS,
		   LAST_UPDATED_TIME, USER_CLASSIFICATION, ORPHAN_EXPIRES_TIME, EXPIRES_TIME_REASON,
		   SESSION_ENDED_REASON, PRODUCT_NAME, EMULATEE_PRISM_GUID, EMULATEE_PRISM_REN_AUTH_TOKEN,
		   PRISM_RENEWED_AUTH_TOKEN, TIER, SESSION_BASED_PREFS, SESSION_SOURCE,SERVICE_TYPE,
		   PMD_DATA_VERSION, CREATED_TIME_AND_TZ, PAYMENT_TYPE, PRISM_REGISTRATION_KEY, CREATED_TIME_LONG,
		   ONE_PASS_PRODUCT, SESSION_STORAGE_PROFILE, PRODUCT_VIEW, IP_ADDRESS,USER_CATEGORY,
		   BILLING_METHOD, ROAMING_STATUS, ONE_PASS_USER_ID)
            SELECT SESSION_ID, ONE_PASS_USER_NAME, FIRST_NAME, LAST_NAME, EMAIL_ADDRESS, EXPIRES_TIME,SITE,
		   CREATED_TIME, SESSION_EXPIRES_TIME, PRISM_GUID, SATOKEN, SESSION_ENDED_DATE, SESSION_STATUS,
		   LAST_UPDATED_TIME, USER_CLASSIFICATION, ORPHAN_EXPIRES_TIME, EXPIRES_TIME_REASON,
		   SESSION_ENDED_REASON, PRODUCT_NAME, EMULATEE_PRISM_GUID, EMULATEE_PRISM_REN_AUTH_TOKEN,
		   PRISM_RENEWED_AUTH_TOKEN, TIER, SESSION_BASED_PREFS, SESSION_SOURCE,SERVICE_TYPE,
		   PMD_DATA_VERSION, CREATED_TIME_AND_TZ, PAYMENT_TYPE, PRISM_REGISTRATION_KEY, CREATED_TIME_LONG,
		   ONE_PASS_PRODUCT, SESSION_STORAGE_PROFILE, PRODUCT_VIEW, IP_ADDRESS,USER_CATEGORY,
		   BILLING_METHOD, ROAMING_STATUS, ONE_PASS_USER_ID
              FROM uds_long_link.co_session
             WHERE created_time >= date_trunc('day', v_run_date)
               AND created_time < date_trunc('day', v_run_date + interval '1 day');


            GET DIAGNOSTICS v_rows_processed  = row_count;

            v_end_time := clock_timestamp();

            UPDATE uds_long.copy_tracker
               SET last_run_date = v_run_date + interval '1 day'
             WHERE table_name = 'co_session';

            INSERT into uds_long.copy_tracker_log
            VALUES ('co_session','SUCCESS',v_start_time, v_end_time, v_run_date, v_rows_processed);

            

        EXCEPTION WHEN OTHERS THEN

           v_exit = TRUE;

           get stacked diagnostics
             v_state   = returned_sqlstate,
             v_msg     = message_text,
             v_detail  = pg_exception_detail,
             v_hint    = pg_exception_hint,
             v_context = pg_exception_context;

           raise exception 'state: %, message: %, detail: %, hint: %, context: %', v_state, v_msg, v_detail, v_hint, v_context;
        END;

        COMMIT;

     END IF;

  END LOOP;

END $$;