How to find Fusion CX Object to Database mapping?

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.Here is the detail -

For any custom objects or custom attributes created in application composer, you can use Metadata Manager in Application Composer (outside of Sandbox) to generate the configuration report like below.

For any standard object and its standard attribute, you can use try this mapping spreadsheet on cloud customer connect -

CX BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet

Hope you find this post helpful, and stay healthy.

Thanks,

Adam Liu

Reference Documents -

https://cloudcustomerconnect.oracle.com/posts/3f1cae5e32?commentId=453862#453862