Error while running AP Invoices and Lines
Error while running AP Invoices and Lines:
———————————————————————
ERROR parsing SQL
—————————————————————–
Error at line 6:
from
ORA-00936: missing expression
ORA-06512: at “SYS.DBMS_SQL”, line 1269
———————————————————————
ERROR executing pivot SQL
———————————————————
Error at line 6:
from
ORA-00936: missing expression
ORA-06512: at “SYS.DBMS_SQL”, line 1269
2 replies
This error is due to an incomplete template definition, which contains a pivot filter without columns or values.
The error message unfortunately is not meaningful or explaining this and I added this to our enhancement list to provide a better message in such cases.
Please add columns to the rows or values fields, which should resolve the issue.
Attachments:
The problem could be related to the template. Can you please send me an XML export of your report definition including the templates (setup window > Tools > Export) and the complete log file of the concurrent request?
And please also send a screenshot from your current code version (setup window > Tools > License Key) so that we know the exact code version date.
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.