Disabling Projects Invoice Line Fact in the Repository for Oracle Fusion Applications
By default, the Billing metrics are mapped to both Invoice Line Fact -W_PROJ_INVOICE_LINE_F and Invoice Line Distribution Fact -W_PROJ_INVOICE_DIST_F. For customers whose only data source is the Fusion database, the Invoice Line fact is an obsolete table and has to be disabled.
Prerequisites:
Oracle recommends that before you start this process you make a back up of the BI metadata repository (that is, the RPD file).
To Disable Projects Invoice Line Fact, first disable metrics that are defined only in the line fact, then disable the invoice line fact. These metrics are around the Retention area and are not supported in the Oracle Fusion Applications currently.
- To delete unnecessary metrics, see Deleting Unnecessary Metrics.
- To disable Invoice Line Fact, see Disabling the Invoice Line Fact.
Deleting Unnecessary Metrics
Before disabling the logical table source, the metrics defined using these Logical Table Sources have to be unmapped / deleted so as to have a consistent repository.
- Delete the listed metrics.
List of 71 metrics that must be deleted:
1. Fact - Project Billing.--------------- Retention Amount --------------- 2. Fact - Project Billing.Current Withheld Amount 3. Fact - Project Billing.Current Withheld Amount - ITD 4. Fact - Project Billing.Current Withheld Amount - MTD 5. Fact - Project Billing.Current Withheld Amount - QTD 6. Fact - Project Billing.Current Withheld Amount - YTD 7. Fact - Project Billing.---------- Retention Billed ------------- 8. Fact - Project Billing.Retention Billed 9. Fact - Project Billing.Retention Billed - ITD 10. Fact - Project Billing.Retention Billed - MTD 11. Fact - Project Billing.Retention Billed - QTD 12. Fact - Project Billing.Retention Billed - YTD 13. Fact - Project Billing.----------- Retention Withheld ------------- 14. Fact - Project Billing.Total Retained Amount 15. Fact - Project Billing.Total Retained Amount - ITD 16. Fact - Project Billing.Total Retained Amount - MTD 17. Fact - Project Billing.Total Retained Amount - QTD 18. Fact - Project Billing.Total Retained Amount - YTD 19. Fact - Project Billing.----------- Retention Write-off ----------- 20. Fact - Project Billing.Retention Write-off 21. Fact - Project Billing.Retention Write-off - ITD 22. Fact - Project Billing.Retention Write-off - MTD 23. Fact - Project Billing.Retention Write-off - QTD 24. Fact - Project Billing.Retention Write-off - YTD 25. Fact - Project Billing.-------------- Unearned Revenue ---------------- 26. Fact - Project Billing.Unearned Revenue 27. Fact - Project Billing.Unearned Revenue - ITD 28. Fact - Project Billing.Unearned Revenue - MTD 29. Fact - Project Billing.Unearned Revenue - QTD 30. Fact - Project Billing.Unearned Revenue - YTD 31. Fact - Project Billing.-------------- Unbilled Receivables ------------ 32. Fact - Project Billing.Unbilled Receivables 33. Fact - Project Billing.Unbilled Receivables - ITD 34. Fact - Project Billing.Unbilled Receivables - MTD 35. Fact - Project Billing.Unbilled Receivables - QTD 36. Fact - Project Billing.Unbilled Receivables - YTD 37. Fact - Project Billing.# of Unapproved Invoices 38. Fact - Project Billing.Retention Amount - MTD - Enterprise Calendar 39. Fact - Project Billing.Retention Amount - QTD - Enterprise Calendar 40. Fact - Project Billing.Retention Amount - YTD - Enterprise Calendar 41. Fact - Project Billing.Retention Billed - MTD - Enterprise Calendar 42. Fact - Project Billing.Retention Billed - QTD - Enterprise Calendar 43. Fact - Project Billing.Retention Billed - YTD - Enterprise Calendar 44. Fact - Project Billing.Retention Withheld - MTD - Enterprise Calendar 45. Fact - Project Billing.Retention Withheld - QTD - Enterprise Calendar 46. Fact - Project Billing.Retention Withheld - YTD - Enterprise Calendar 47. Fact - Project Billing.Retention Write-off - MTD - Enterprise Calendar 48. Fact - Project Billing.Retention Write-off - QTD - Enterprise Calendar 49. Fact - Project Billing.Retention Write-off - YTD - Enterprise Calendar 50. Fact - Project Billing.Unearned Revenue - MTD - Enterprise Calendar 51. Fact - Project Billing.Unearned Revenue - QTD - Enterprise Calendar 52. Fact - Project Billing.Unearned Revenue - YTD - Enterprise Calendar 53. Fact - Project Billing.Unbilled Receivables - MTD - Enterprise Calendar 54. Fact - Project Billing.Unbilled Receivables - QTD - Enterprise Calendar 55. Fact - Project Billing.Unbilled Receivables - YTD - Enterprise Calendar 56. Fact - Project Billing.Internal UBR UER Metric (Invoice Fact) 57. Fact - Project Billing.Internal Unearned Revenue - ITD 58. Fact - Project Billing.Internal Unbilled Receivable - ITD 59. Fact - Project Revenue.------------- Unearned Revenue -------------- 60. Fact - Project Revenue.Unearned Revenue 61. Fact - Project Revenue.Unearned Revenue - ITD 62. Fact - Project Revenue.Unearned Revenue - QTD 63. Fact - Project Revenue.Unearned Revenue - MTD 64. Fact - Project Revenue.Unearned Revenue - YTD 65. Fact - Project Revenue.------------ Unbilled Receivable ------------- 66. Fact - Project Revenue.Unbilled Receivable 67. Fact - Project Revenue.Unbilled Receivable - ITD 68. Fact - Project Revenue.Unbilled Receivable - MTD 69. Fact - Project Revenue.Unbilled Receivable - QTD 70. Fact - Project Revenue.Unbilled Receivable - YTD 71. Fact - Project Revenue.Internal UBR UER Metric (Invoice Fact)
