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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.