Reporting and Analytics for Engagement Cloud

Get Involved. Join the Conversation.

Topic

    premanayagam velayudan
    Customizing a Seeded BI Publisher U.S. 1099 Payments Report...
    Topic posted May 29, 2019 by premanayagam velayudan, tagged BI Publisher, Reporting and Analytics 
    29 Views, 1 Comment
    Title:
    Customizing a Seeded BI Publisher U.S. 1099 Payments Report - Editing the Data Model - not working
    Summary:
    Unable to modify Seeded BI Publisher Data Models
    Content:

    Hi Team,

    While we are trying to extend existing U.S. 1099 BI Publisher Data Model, unable to modify the SQl due to Bind Global temporary Tables.

    Error while modifying Data model SQL: ORA-00907: missing right parenthesis

    Due to Parameters: &C_DYNAMIC_SQL ,&LP_QUERY_DRIVER unable to edit data model, Please advice on how to modify seeded BI Publisher reports.

    PS:
    Seeded Data Model Path: /Shared Folders/Financials/Payables/Income Tax and Withholding/Data Models/U.S. 1099 Data Model
    Seeded Report Path: /Shared Folders/Financials/Payables/Income Tax and Withholding/U.S. 1099 Payments Report

     
     

    ORA-00907: missing right parenthesis

    Comment

     

    • Sudhakara Rao Kovuru

      Hi Velayudan,

      I had similar issue with AR report and I created SR with Oracle support and they provided the right file so please create service request with oracle support then they will be able to give the right data model to customize.

      Thanks,

      -Sudha.