How to do Fixed Asset Tracing Using Diagnostics In Oracle Fusion

Many a times we need to create custom BIP data model and report and if are not sure which all tables the data goes then we can use tracing which is generated as part of Diagnostics in Oracle Fusion.

We can do tracing for many modules. In this Post we will see how we can trace a fixed asset(what data goes in which tables). This will help us create  BIP data model and report easily and also help us understand the data flow. We can easily co-relate  data we see in in UI with the data in Back end tables.

•  We need to have diagnostics roles to our user to run tracing:

 

• After the role is assigned , login to fusion application and click on user icon on the right side and then  click on “Run Diagnostics Tests”

 

 

• Search for “Assets Generate Asset Trace: Basic Information” and select the check box and click on “Add to Run”.  This will give basic information of asset. We can also trace accounting information if we want.

 

 

 

• Click on “Required Input Values Missing”

 

 

•   Enter Asset number, book type code and click Ok

 

 

 

• Enter Run Name and Click on Run

 

• Keep refreshing until the run is complete. After this,  in Run Status check for log of process Click report icon to get the tracing.
   

 

 

This will be in html and it will look like below:

 

 

So with the above tracing report we will get to know where and all this asset basicdata reside in backend tables. This will help us write sql query for data model.