Tuesday, 27 July 2021

Create/Update an External Bank Account in Oracle Fusion Cloud

 Scope:

    In this post, we see how to create or update the external bank account in Oracle Fusion Cloud Application using REST service

Requirement:

    The requirement here is to integrate the external bank account to Oracle Fusion Cloud.

How to:

    for creating  External Bank Account :

- Go in Task Manage Cash Management Profile

- profile option CE_USE_EXISTING_BANK_BRANCH enabled at both level site and Rest user level ( Yes)

- then try again to  call the External Bank Account creation REST API using the below payload

POST https://<<hostname>>/fscmRestApi/resources/11.13.18.05/externalBankAccounts
Payload:
{
"BankAccountNumber": "12398765",
"CountryCode": "US",
"BankIdentifier": "300000003692821",
"BankBranchIdentifier": "300000003692825",
"CurrencyCode": "USD",
"AccountType": "SAVINGS",
"AllowInternationalPaymentIndicator": "Y",
"Intent": "Supplier",
"PartyId": 300000003692792,
"BankAccountName": "DDP_01",
"accountOwners": [
{
"AccountOwnerPartyIdentifier": 300000003692792,
"Intent": "Supplier"
}
]
}

Notes: 
      -- Get the "AccountOwnerPartyIdentifier" using the party ID of the supplier

You can update an external bank account- PATCH method
          https://<<hostname>>/fscmRestApi/resources/11.13.18.05/externalBankAccounts/<<ext bank account id which is already created>>

          Sample Payload where the name to update

                {
                  "BankAccountName": "TEST API",
                  "AlternateAccountName": "REST API",
                  "Intent": "Supplier",
                  "PartyId": 300100126889527
                 }

Note: we can also create an external bank account using the SOAP Service as below

https://<<hostname>>/fscmService/ExternalBankAccountServiceV2?WEDL

No comments:

Post a Comment