You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Customizing a Seeded BI Publisher U.S. 1099 Payments Report - Editing the Data Model - not working

Received Response
edited May 29, 2019 12:03PM in Reporting & Analytics for Sales 1 comment


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!