Diagnostics Log entry for the query: Total Number Of Rows Processed:15 Diagnostics Log entry for the bursting query: Bursting sql output size = [1] rows. Query does have data for KEY - values:'1'. Bursting is done on '1' key. The error message suggests that there is no data to process: [052925_083844425][][STATEMENT]…

The burst query only produces one row. Not sure what else you could mean.

The bursting query does work, I checked that separately on a paas db. This is an odd one; thanks for helping. Kind regards

This is the error: Waiting Time: 0.8 seconds Data Fetch Time: 0.2 seconds Total Execution Time: 0.4 seconds Job Priority: Normal Waiting Time: 0.8 seconds Data Fetch Time: 0.2 seconds Total Execution Time: 0.4 seconds Job Priority: Normal Job processor caused exception [INSTANCE_ID=bip.bi_serverHA]…

The report/bursting worked before, but has suddenly stopped. Not sure what has happened. The report output has a key column with static data populated '1'. The bursting sql is based on the following (obfuscated here): SELECT '1' KEY ,'xxxx' TEMPLATE ,:xdo_user_report_locale LOCALE ,'csv' OUTPUT_FORMAT ,'FTP' DEL_CHANNEL…

This is important for client security reporting. We should have access to tables that report permissions on bip objects.

Have oracle made any progress on this? I cannot access the ER.

This should get more votes. Oracle are shooting themselves in the foot making Fusion so difficult in so many aspects. EBS life was so much better where we could also access the all_source table to inspect standard pl/sql packages used. Viewing the background logic in pl/sql gave insight in the data models.

Agreed with Emiliano R above. From a support/admin perspective, access to ess job definition/parameters and scheduled data would greatly help. EBS had this info in the following tables for job definitions: FND_REQUEST_SET_PROGRAMS FND_REQUEST_SET_PROGRAM_ARGS fnd_request_sets_vl fnd_req_set_stages_form_v fnd_executables…

Is there any update on this? - we still cannot access FUSION_ORA_ESS.request_metadata Thanks