BI Publisher (MOSC)

MOSC Banner

How to debug invalid character in Data Template?

in BI Publisher (MOSC) 9 commentsAnswered ✓
Getting the following error. The sql in the template works in Toad, but somehow when copied to Notepad, it introduced some invalid character(s). I had encountered the error before, but it was always due to apostrophes. Any other characters might cause the error?

CP main executing runProgram for oracle.apps.xdo.oa.cp.JCP4XDODataEngine
XDO Data Engine Version No: 5.6.3
Resp: 21540
Org ID : 84
Request ID: 34423929
All Parameters: 
Data Template Code: XXSEESHRAUDIT
Data Template Application Short Name: XXSEES
Debug Flag: N
{}
Calling XDO Data Engine...
--SQLException
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center