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