BI Publisher (MOSC)

MOSC Banner

Creating User audit Reports faced error that "requestid" column does not exist in the view bipublish

edited Aug 5, 2020 5:01AM in BI Publisher (MOSC) 13 commentsAnswered

RequestID Column missing in bipublisher_v view that stores user audit data for bi publisher.

Below is the query used by the model:-

SELECT

    "RequestID",

    "User",

    "Report Path",

    "Report Name",

    "Report Type",

    "Datamodel Path",

    "Execution Type",

    "Status",

    "Message Text",

    "Template",

    "Locale",

    "Template Type",

    "OutputType",

    "DataFileSize",

    "Report Output Size",

    "Report Start Time",

    "Report End Time",

/*EXTRACT(DAY FROM "Total Report Execution Time") * 86400 + EXTRACT(HOUR FROM "Total Report Execution Time") * 3600 +  EXTRACT(MINUTE FROM "Total Report Execution Time")* 60 + EXTRACT(SECOND FROM "Total Report Execution Time") * 1000 as "Total Report Time",*/

((EXTRACT(DAY FROM "Total Report Execution Time") * 86400000 + EXTRACT(HOUR FROM "Total Report Execution Time") * 3600000 + EXTRACT(MINUTE FROM "Total Report Execution Time")* 60000 + EXTRACT(SECOND FROM "Total Report Execution Time") * 1000)) as "Total Report Time",

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