Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ESS job creation for ATP web service based BIP report

DharaniRMay 5 2023

Hello Team

I have a requirement were I have a BIP report with ATP web service and am trying to create an ESS job but it is failing while creating the report.

I have a rest API call from APEX using below code but when generating report it throws invalid ‘Invalid format requested: html’ error. Unable to create report for the Web service DM.

begin

dbms_scheduler.create_job(

 job\_name => dbms\_scheduler.generate\_job\_name,

 job\_type => 'PLSQL\_BLOCK',

 job\_action => 'begin pa\_pfp\_autogenerate; end;',

 start\_date => SYSTIMESTAMP,

 enabled => true,

 auto\_drop => true); 

htp.p('<?xml version="1.0" encoding="utf-8"?><Autogenerate_triggered version="2.0"></Autogenerate_triggered>');

end;

Please suggest.

Comments
Post Details
Added on May 5 2023
1 comment
346 views