While creating an Oracle Application SaaS extension in Oracle Visual Builder, you may need to synchronize the master data from Oracle Application to Visual Builder Business Objects. The benefit of having the master data in Business Objects is to increase the performance of an application.

So, in this article, I’ll demonstrate how to synchronize the Suppliers to Oracle VB Business Objects using Oracle Integration. The same approach can be applied to other master data also.

We are using the following REST APIs in Oracle Integration to complete this article:

  • Oracle Fusion Supplier REST API: Look at this doc to know the Get all supplier REST API.
  • Oracle Visual Builder Batch REST API: Look at this video to know about the VB batch REST API.

Following is the sample response of Get all suppliers API:

{
  "items" : [ {
    "SupplierId" : 300000023232,
    "SupplierPartyId" : 300000023232,
    "Supplier" : "test Supplies",
    "SupplierNumber" : "12521",
    "AlternateName" : null,
    "TaxOrganizationTypeCode" : "CORPORATION",
    "TaxOrganizationType" : "Corporation",
    "SupplierTypeCode" : null,
    "SupplierType" : null,
    "InactiveDate" : null,
    "Status" : "ACTIVE",
    "BusinessRelationshipCode" : "SPEND_AUTHORIZED",
    "BusinessRelationship" : "Spend Authorized",
    "ParentSupplierId" : null,
    "ParentSupplier" : null,
    "ParentSupplierNumber" : null,
    "CreationDate" : "2013-11-07T20:14:36.428+00:00",
    "CreatedBy" : "one.test",
    "LastUpdateDate" : "2022-03-25T16:45:09.571+00:00",
    "LastUpdatedBy" : "111.we",
    "CreationSourceCode" : "MANUAL",
    "CreationSource" : "Manual",
    "DataFoxScore" : null,
    "DataFoxScoringCriteria" : null,
    "Alias" : null,
    "DUNSNumber" : "222",
    "OneTimeSupplierFlag" : null,
    "RegistryId" : "2052",
    "CustomerNumber" : null,
    "StandardIndustryClass" : null,
    "IndustryCategory" : null,
    "IndustrySubcategory" : null,
    "NationalInsuranceNumber" : null,
    "NationalInsuranceNumberExistsFlag" : false,
    "CorporateWebsite" : null,
    "YearEstablished" : 1986,
    "MissionStatement" : null,
    "YearIncorporated" : null,
    "ChiefExecutiveTitle" : null,
    "ChiefExecutiveName" : null,
    "PrincipalTitle" : null,
    "PrincipalName" : null,
    "FiscalYearEndMonthCode" : "11",
    "FiscalYearEndMonth" : "November",
    "CurrentFiscalYearPotentialRevenue" : 111,
    "PreferredFunctionalCurrencyCode" : null,
    "PreferredFunctionalCurrency" : null,
    "TaxRegistrationCountryCode" : null,
    "TaxRegistrationCountry" : null,
    "TaxRegistrationNumber" : null,
    "TaxpayerCountryCode" : "US",
    "TaxpayerCountry" : "United States",
    "TaxpayerId" : null,
    "TaxpayerIdExistsFlag" : false,
    "FederalReportableFlag" : true,
    "FederalIncomeTaxTypeCode" : "MISC3111",
    "FederalIncomeTaxType" : "Other Income",
    "StateReportableFlag" : true,
    "TaxReportingName" : null,
    "NameControl" : null,
    "VerificationDate" : null,
    "UseWithholdingTaxFlag" : true,
    "WithholdingTaxGroupId" : dd,
    "WithholdingTaxGroup" : "11-PR1G-10-PCT",
    "BusinessClassificationNotApplicableFlag" : null,
    "DataFoxId" : null,
    "DataFoxCompanyName" : null,
    "DataFoxLegalName" : null,
    "DataFoxCompanyPrimaryURL" : null,
    "DataFoxNAICSCode" : null,
    "DataFoxCountry" : null,
    "DataFoxEIN" : null,
    "DataFoxLastSyncDate" : null,
    "OBNEnabledFlag" : null
  } ],
  "count" : 10,
  "hasMore" : false,
  "limit" : 10,
  "offset" : 0,
  "links" : [ {
    "rel" : "self",
    "href" : "https://test:443/fscmRestApi/resources/11.13.18.05/suppliers",
    "name" : "suppliers",
    "kind" : "collection"
  } ]
}

Following is the sample request of VB batch REST API:

{
  "parts" : [ {
    "id" : "part1",
    "path" : "/Suppliers",
    "operation" : "create",
    "payload" : {
      "supplierNumber" : "nancy",
      "supplierName" : "Kumari",
      "status" : ""
    }
  } ]
}

I have captured an end to end video that will help you to synchronize the suppliers to VB Business Object. Click on the below link and watch the complete video.

Take a membership to watch the video. Click here to buy the membership.

You can look at our YouTube channel for Oracle Integration-related videos. Also, don’t forget to subscribe to our channel.

Further Readings

Scheduled parameters to maintain Last Run Date Time in Oracle Integration

How to Customize the Lock Screen in Oracle Visual Builder

Merging two CSV files into a single file in Oracle Integration

ERP Integration using File Based Data Import: Oracle Integration

Import Suppliers using FBDI in Oracle Integration

How to call Oracle SaaS ESS job using Oracle Integration