Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked,
Summary:
i Found out we cannot write this query in the BI Publisher and it can be done in the OTBI only if yes what is the reason and if possible please help us to fix this?
it is not possible to write a BI Publisher SQL query in Oracle Fusion to get the "Send Statement" flag because:
- The field
Send Statement
is stored in the tableAR_CUSTOMER_PROFILES
- This table is not exposed in BI Publisher’s
ApplicationDB_FSCM
data source - Even users with admin roles cannot access this table directly via SQL in Fusion
Content (please ensure you mask any confidential information):
Tagged:
0