BI Publisher (MOSC)

MOSC Banner

XMLElement in BI Publisher SQL Query

edited Jul 13, 2021 8:56AM in BI Publisher (MOSC) 3 commentsAnswered ✓

Hi. 


In Oracle BI Publisher 11.1.1.9 I'm creating a dataset by writing this simple query:


select XMLELEMENT ("Detail",

      XMLELEMENT("Bill To",BILL_TO_CUSTOMER_ID),

      XMLELEMENT("TRX ID",CUSTOMER_TRX_ID)) as DETAIL FROM RA_CUSTOMER_TRX_ALL

WHERE CUSTOMER_TRX_ID = 300000003069790


Of course, data exist. A blank output comes after pressing the "View" button.

Do I need any setting or privilege or role or anything else?


Thank you

Best Regards

Vincenzo

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center