Distribution effective date and Ineffective date are added in assignment details which shows the dates for which the asset was in the specific location. Please check if you are able to extract the required details with this information.

@Juan Hurtado , Can you please check the below documentation link https://docs.oracle.com/en/cloud/saas/analytics/26r2/faiae/frequent-data-refresh-v2-data-lineage.html#GUID-72B14E54-7C5D-418E-9FB5-07CC6985F201 FDR V2 Database Objects Spreadsheet provides the details of Certified objects and Recommendations. Please query by…

Hi Cameron, Can you please elaborate your question. Currently source line id is at the Asset Level in the asset transaction subject area. Any reason to join DW_FA_MC_SLA_TRX_DEPRN_CF with source lines?

Hi Bharat, Thanks for reaching out. We do not have an OOTB Dashboard as yet. I have shared a sample dashboard file to your mail. Please let me know if you are able to import and if you require further details.

Hi Niaz, Can you please elaborate your requirement. In CAA , have you tried to add the Account class "Burdened Cost" in the report you are trying to fetch the burdened costs? This would get the Burdened Costs accounted from projects source.

Currently the project is at the Invoice distribution level. Depending on the grouping, an Invoice can have multiple projects. Users can see the remaining amount, Contract and Invoice from the AR Transaction subject area. You can add another table with Receivable Number, Contract Number, Project number and the Invoice…