Reporting and Analytics for Sales

Get Involved. Join the Conversation.


    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 
    73 Views, 1 Comment
    Customizing a Seeded BI Publisher U.S. 1099 Payments Report - Editing the Data Model - not working
    Unable to modify Seeded BI Publisher Data Models

    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.

    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



    • 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.