Oracle Analytics and AI

Fusion BI Reporting

Getting Error "ORA-00904:"CPI"CLEARING_CCID":invalid identifier" while running US 1099 Payments seeded report

Need to understand the root cause for this error, Can anyone help me on this

Complete error details as below,

oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00904: "CPI"."CLEARING_CCID": invalid identifier

oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataExcep

Sumanth V -Oracle

@User_W5XD2 - This seem to be a Fusion Application Seeded report. This community is dedicated for OAC and OAS related queries.
Reference: https://docs.oracle.com/en/cloud/saas/financials/24d/fappp/us-1099-payments-report.html

@John Hung-Oracle - Kindly assist by moving this thread to OTBI community as customer's query is related to Fusion Applications. Thank you!