Supplier and Supplier Site Bank account assignment can be end dated using below REST API in oracle Fusion.

Step1: Get INSTRUMENT_PAYMENT_USE_ID for Supplier/ Supplier Sites level.

Run below SQL queries to get INSTRUMENT_PAYMENT_USE_ID for Supplier and Supplier Site level.

Supplier:

SELECT DISTINCT 
  APS.SEGMENT1,
  IPIUA.INSTRUMENT_PAYMENT_USE_ID
  FROM 
  POZ_SUPPLIERS_V APS,
  IBY_EXTERNAL_PAYEES_ALL IEPA,
  IBY_EXT_PARTY_PMT_MTHDS PMTMTHDS,
  IBY_PMT_INSTR_USES_ALL IPIUA,
  IBY_EXT_BANK_ACCOUNTS IEBA
  WHERE 1                                   =1
  AND APS.PARTY_ID                          = IEPA.PAYEE_PARTY_ID
  AND IEPA.SUPPLIER_SITE_ID                IS NULL 
  AND IEPA.PARTY_SITE_ID                   IS NULL
  AND IEPA.EXT_PAYEE_ID=PMTMTHDS.EXT_PMT_PARTY_ID(+)
  AND IEPA.EXT_PAYEE_ID=IPIUA.EXT_PMT_PARTY_ID
  AND IPIUA.INSTRUMENT_ID                   = IEBA.EXT_BANK_ACCOUNT_ID
  AND IPIUA.INSTRUMENT_TYPE                 = 'BANKACCOUNT'
  AND IPIUA.PAYMENT_FLOW                    = 'DISBURSEMENTS';

Supplier Site:

SELECT APS.SEGMENT1 ,
  TRIM(PSSV.VENDOR_SITE_CODE),
  IPIUA.INSTRUMENT_PAYMENT_USE_ID
  FROM 
  POZ_SUPPLIERS_V APS,
  IBY_EXTERNAL_PAYEES_ALL IEPA,
  IBY_EXT_PARTY_PMT_MTHDS PMTMTHDS,
  IBY_PMT_INSTR_USES_ALL IPIUA,
  IBY_EXT_BANK_ACCOUNTS IEBA,
  POZ_SUPPLIER_SITES_V PSSV
  WHERE 1                                   =1
  AND APS.PARTY_ID                          = IEPA.PAYEE_PARTY_ID
  AND IEPA.SUPPLIER_SITE_ID                = PSSV.VENDOR_SITE_ID
  AND IEPA.PARTY_SITE_ID                   =PSSV.PARTY_SITE_ID
  AND IEPA.EXT_PAYEE_ID=PMTMTHDS.EXT_PMT_PARTY_ID(+)
  AND IEPA.EXT_PAYEE_ID=IPIUA.EXT_PMT_PARTY_ID
  AND IPIUA.INSTRUMENT_ID                   = IEBA.EXT_BANK_ACCOUNT_ID
  AND IPIUA.INSTRUMENT_TYPE                 = 'BANKACCOUNT'
  AND IPIUA.PAYMENT_FLOW                    = 'DISBURSEMENTS'
  AND PSSV.VENDOR_ID=APS.VENDOR_ID;

Step2: Rest API for End Date Assignment.

Rest API Endpoint:

https://fa-xxxx-xxx.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/instrumentAssignments/{{INSTRUMENT_PAYMENT_USE_ID}}

Method: Patch

Body:

{

      "EndDate": "2024-03-11",

      "Intent":"Supplier"

  }