Transactions Print Data Model Error - oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00933:SQL command not properly ended (Doc ID 2064215.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Reports

Transactions Print Data Model error

When try to run view data using "Transactions Print Data Model" data model under Receivables, the error occurs

Error Message: "oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00933:SQL command not properly ended"

The requirement to do this is to upload a custom invoice template that is based on this data model "Transactions Print Data Model". While uploading the template, the pop-up message appears "Error: Data Model does not contain sample data. Please edit Data Model and save with sample data."

ERROR
-----------------------
1) Data model error: "oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00933:SQL command not properly ended"


2) Template error: Error: Data Model does not contain sample data. Please edit Data Model and save with sample data.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Report and Analytics >> Shared Folders >> Financials >> Receivables >> Bill Presentment >> Invoice Print Template
2. Edit the template
3. Update the data model
4. On Data tab provide parameters and Press view
5. Error message pops up

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update invoice print template.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms