FAW : Adhoc Analysis Created Using The Columns Derived From Prebuilt Prediction Applications And Other Dimensions From Financials - AR Subject Area Failed With Error "no fact table exists"
(Doc ID 2965231.1)
Last updated on AUGUST 21, 2023
Applies to:
Fusion Analytics Warehouse - Version 23.R2.x and laterInformation in this document applies to any platform.
Symptoms
An Adhoc analysis was created using the columns derived from prebuilt prediction applications based on machine learning model ("Classifier Score Bucket", "Actual Defaults" and "Classifier Predicted Defaults") along with the other dimensions ("Party Name", "Payment Terms Name") from the Financials - AR Transaction and Financials - AR Aging subject areas failed with error "no fact table exists " in execution log
Changes
In FAW, the prebuilt prediction applications based on machine learning model are designed to abstract complexity and provide these benefits:
- Improved operations and reduced business risk.
- Enhanced visibility and deeper insights that aren't available through exploratory analysis.
- Ability to plan for the future by predicting outcomes.
The "Customer Collections Risk Prediction" application predicts the risk of a scheduled payment on an invoice being late because it won't be paid by the due date.
This application creates a risk score for each customer by considering the likelihood of late payment over all invoices. The risk score for an invoice or a customer is exposed in the Financials - AR Transaction and Financials - AR Aging subject areas.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |