Write a BI Publisher SQL query to list all customers where 'Send Statement' is not checked, — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!