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 table AR_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):