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

How to use SUBSTR on Clob in BI Publisher which is not an XML

in BI Publisher Learning Center

I am trying to get the Report delivery information of the reports executed with Bursting from the AuditViewDB in Fusion SaaS. The delivery details are in a CLOB column which is not XML.
Query:
SELECT
repstart.requestid requestid
, repstart.iau_resource report_path
, TO_CHAR(repstart.iau_tstzoriginating, 'IW') Week_Number
, TO_CHAR(repstart.iau_tstzoriginating, 'Day', 'NLS_DATE_LANGUAGE = AMERICAN') Week_Day
, TO_CHAR(repstart.iau_tstzoriginating, 'DD/MM/YYYY HH24:MI:SS') start_time
, TO_CHAR(repend.iau_tstzoriginating, 'DD/MM/YYYY HH24:MI:SS') end_time
, repdelivery.deliveryproperties deliveryproperties
, repstart.iau_initiator submitted_by
, INSTR(repdelivery.deliveryproperties,'cc=',1,1) ccpos

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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