Adam Liu - Oracle Cloud Architect

In this article, I will provide some sample APIs and use cases for the purpose of issue diagnosis. Search User with POST - we can use this API to get user details including id based on userName. With the user id returned in the response payload, we can use the same for other calls to retrieve user specific data. The following is the example to retrieve all users with userName containing 'adam@abccompany.com'. API : {{HOST}}/admin/v1/Users/.search Operation : POST Payload : { "schemas" : [ "urn:ietf:params:scim:api:messages:2.0:SearchRequest" ], "filter" : "userName co \"adam@abccompany.com\"" , "startIndex" : 1 , "count" : 10 } Get User Data from  passwordState  - we can use this API to get data such as lastSuccessfulSetDate. This will help us to find out the date and time when the current password was set. API: {{HOST}}/admin/v1/Users/<id>?attributes=urn:ietf:params:scim:schemas:orac

In this article, I am going to discuss some IDCS Settings APIs and scenarios. Update IdentitySettings We can use UI to manage these settings. But in some scenarios, we may see errors when updating the settings (like below) in the UI. We can certainly use this API to update the settings and fix the UI error. API : {{HOST}}/admin/v1/IdentitySettings/IdentitySettings Operation : PATCH or PUT Payload : { "schemas" : [ "urn:ietf:params:scim:api:messages:2.0:PatchOp" ], "Operations" : [ { "op" : "replace" , "path" : "tokens" , "value" : [ { "expiresAfter" : 1440 , "type" : "emailVerification" }, { "expiresAfter" : 60 , "type" : "passwordReset" },

We may have some use cases that we want to update PARTY_NUMBER values for the existed customers so that we have the aligned values with the boundary systems.  In this article, I am going to discuss how we can update PARTY_NUMBER with profile option setting and SOAP API to achieve this. Please note: You can also update PARTY_NUMBER (Registry ID) in AR Manage Customer UI if you prefer to take UI approach. First, we need to set the value for profile option HZ_GENERATE_PARTY_NUMBER to 'Auto numbering, update allowed'. Then, we can use SOAP API to update the value for PARTY_NUMBER. WSDL: https://FusionPod/crmService/FoundationPartiesOrganizationService?WSDL Operation: updateOrganization Request Payload (I only include header/body. They need to be embedded in Envelope): ###########    <soapenv:Header/>    <soapenv:Body>       <typ:updateOrganization>          <typ:organizationParty>             <org:PartyId>100000006397773</org:PartyId>          

In this article, I am going to cover how to create a client app that can be use to IDCS API authentication, and how to use client ID and secret to generate bearer token. Client Application In Integrated applications, add a Confidential Application as below Select Client credentials for Authorization and add app roles required for the API (note: if app roles are not added, we will see access denied error for some API like enabling attributes for import.) Once the application is created, activate it. Bearer Token Generation Next step, I will provide two options to generate bearer token based on client ID and Client secret. Option#1: cURL curl -i -H "Authorization : Basic <base64encoded clientid:clientsecret>" -H "Content-Type : application/x-www-form-urlencoded;charset=UTF-8" --request POST https://IDCSURL/oauth2/v1/token -d "grant_type=client_credentials&scope=urn:opc:idm:__myscopes__" Option#2: GitHub URL import to Postman Set the Environment Par

Hi, Oracle IDCS provides schema management for us to define custom User attributes. After we define the custom User attributes, how can we enable them for User Import and Export? In this article, I am going to cover the high-level steps for enablement. For example, I created these 2 custom attributes (1 of type String, 1 of type String array) with these information in schema management - ######Attribute1####### Display Name: color Name: color Data Type: String Administrator permissions: Read-Write End-user permissions: Read-Write ######Attribute2####### Display Name: allColors Name: allColors Data Type: String array Administrator permissions: Read-Write End-user permissions: Read-Write First of all, we need to use IDCS REST API to enable Custom Attribute for Import/Export End point : https://IDCSURL/admin/v1/Schemas/urn:ietf:params:scim:schemas:idcs:extension:custom:User Operation : PATCH Request Payload for custom attribute of String type : { "schemas" : [ "urn:ietf

Hi, In this post, I will cover a data import reference I delivered a few years ago and also some general guidance I follow for Fusion Sales Data Import. For this reference, here are the data object, data volume and the import durations Based on my years of experiences of data import, to get the optimal import performance, here are the guidelines I follow, Prepare the data file with ETL tool with data from source systems and Oracle Cloud (for round-trip scenario) Establish the Import Timing baseline on production-sized pod Production Import should follow the same steps as the lower pod where you establish the baseline Use the most efficient tool to import data (e.g. EDLC, WS submission with UCM file IDs) Fine tune the Import Queue Size (e.g. 5-10 active importing jobs in the queue) to get the best throughout Disable the activities which will impact import duration (e.g. ESS job, Adaptive Search Periodic Refresh, OTBI/BIP scheduling, Object Trigger/Workflow, User Access, Inbound/Outbound

Hi, In the post, I will cover the high-level steps of how to use ErpIntegrationService?WSDL to run BIP report with callback feature. This will be useful if you have integration pattern to run BIP report in Asynchronous mode for the cases like long execution time, large report size. 

Hi, In this post, I will discuss how to query records of parent object based on the search conditions of child object attributes.

Hi, In this post, I will show you how to run a BIP report with WS in synchronous mode.

Hi, In this post, I will discuss how to find the business events for standard and custom objects, and their subscriptions. This will be useful if you plan to create real-time integrations based on the object create/update/delete in Fusion CX.

Hi, In this post, I will discuss how we can find the object to DB table mapping. You will find this post useful if you ever wonder what tables/columns are selected for the objects/attributes created in application composer.

Hi, In this post, I will cover the Fusion CX integration patterns and recommended use cases for Inbound and Outbound scenarios. You will find it useful if you have requirements to integrate Fusion CX with any other systems. 

Hi, In this post, I will cover how we can get the event catalog for standard and custom objects. This will be useful if you want to use the catalog info to build your integration with OIC or 3rd-party integration platform.

Hi, I'll cover how you can retrieve login user's information (e.g. Business Unit, Legal Entity) with Groovy. You may find it useful if you want to retrieve transaction data based on BU, stamp BU on your custom object, etc.

Hi, In this post, I will cover the main steps to create a salesperson. Once salesperson is created, you can use it for Sales Credits in Subscription Mgt and also Enterprise Contracts.

Hi, In this post, I will discuss how to call SOAP and REST API for batch operations. With the batch operation, it can help to improve the API execution throughput and performance. You may find it useful if you have use case to CRUD large data set through API.

Hi, Sometimes we may want to build a OIC integration like this use case -  First we want to trigger Fusion ESS job,  then we will retrieve the report output or related data after the ESS job is completed, and send that data to 3rd-party systems. I will cover how we can call Fusion SaaS ESS job from OIC in this post.

Hi, Import Management will become the main tool to import data into CX Sales from 20D. Based on my experiences, this tool has better throughput and performance comparing to Class Import which will be retired on 20D.  I'm going to discuss how we can use this tool to import large volume of data with REST API and EDLC. You may find it useful if you have use cases to migrate and sync large volume of data from your systems to Cloud.

Hi, In this post, I am going to cover how to deploy a VBCS page as a Mashup in CX Sales. This is applicable for use cases like, 1. You want to display 3rd-party system data on Account page without migrating/syncing data 2. You want to display account/contact information on Account page with your preferred layout and data controls. 

Hi, In this post, I will discuss how we can merge duplicate Receivables Billing Accounts and Account Sites with CDM Duplicate Resolution feature. You will find it useful if you want to address the use case like below, I have a single customer with multiple billing accounts and account sites. Some of the billing accounts and sites are duplicates. I will need to merge them.

Hi, In this post, I will discuss how to use cURL to validate IDCS access token. It will be useful if you want to validate the token before you call API in your custom logic (e.g. Access B2C Service API in custom PHP, Access B2C Service API from CX Sales Groovy).

Hi, In this post, I will discuss how to setup IDCS confidential app and B2C Service to access the Connect REST API with OAuth token. You will find it useful if you have use case like Authorize API access via OAuth.

Hi, In this post, I am going to discuss the steps to create a BIP Bursting Report. This will be useful if you have use cases like - Send Consolidated List of all related records owned by Sales Rep Send Work Anniversary Email to Sales Rep

Hi, In this post, I am going to discuss how to generate the dynamic URL in groovy based on Pod.  You may ask why we need this. One main reason is to avoid code change in groovy after CSM migration. 

Hi, In this post, I'll cover how to retrieve 3 levels of object data in a single REST API Call with GET. It is useful if you want to reduce the number of API calls and get optimal data query performance.

Hi, This post provides the guidelines on how to set up SFTP server for BI Publisher in CX Sales. You may find it useful if you have use cases like below, Retrieve the updated records in batch to SFTP where Eloqua can consume with Scheduled Import feature Retrieve the updated records in batch to SFTP where Data Warehouse can consume