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
Viewing 1 reply thread
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:
Viewing 1 reply thread
- You must be logged in to reply to this post.
Login with:
Popular Posts
Blog Archive
2026
March (2)
February (2)
2025
June (1)
March (1)
February (2)
January (1)
2024
October (1)
September (1)
August (1)
2023
December (2)
September (1)
July (3)
April (2)
2022
2021
December (2)
November (1)
October (1)
April (1)
2020
- EBS SQL to Excel reporting with Blitz Report for non-developers 1205
- Getting all horizontal with ASCP planning 3904
- How to use EBS audit functionality to speed up operations 4070
- Accessing external data sources with Blitz Report™ 2197
- Does Oracle Discoverer 11g work with Oracle Database 19c? 4207
- Blitz Report™ Champion – quarterly awards announcement 1668
- Can data governance be free? 3450
- EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6444
- Ungarbling Oracle EBS Financial Accounting 3694
- Discover the secret of perfectly formatted Oracle EBS Excel report creation in under 10 minutes 4232
- A simpler way to work with Automatic Workload Repository (AWR) 3525
- Blitz Report Champion – absence visualization in Oracle EBS 1826
- Oracle E-Business Suite – concurrent request monitoring and alert reporting 6230
- Oracle Enterprise Command Center Framework upgrade to V4 3700
- How to quickly create or modify Oracle E-Business Suite BI Publisher based reports 5615
- How to replace Oracle ASCP exceptions with Blitz Report 2921
- How to add Blitz Report™ to your favorite form 3172
- How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ 3780
- Oracle E-Business Suite Inventory period-end optimization / close 4069
- Oracle Supply Chain Hub that takes simplicity to another level 5767
- How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123741
- How to put the Advanced functions into Oracle EBS Supply Chain Planning (ASCP) 4241
- How to optimize Order Management form exports in Oracle EBS 3747
December (2)
October (4)
September (2)
July (8)
June (3)
April (8)
March (7)
2019
October (1)
August (2)
June (2)
May (1)
2018
November (2)
January (1)
2017
November (1)
September (1)
Recent Events
2026
June (3)
March (1)
February (1)
2025
- High Performance, Low Cost: Optimizing E-Business Suite in the Cloud
- Beat the Heat! Lightning Fast E-Business Suite Report Generation and Data Loading (Customer Case Study)
- From XML Publisher to Nicely-Formatted Reports–How LiDestri Automated Oracle E-Business Suite Reporting (Customer Case Study)
- From Data Overhead to Data Overdrive. Supercharging E-Business Suite Processes at Ultradent (Customer Case Study)
- OBUG – AppsConnected25
- Ascend 2025
July (2)
November (4)
May (3)
June (6)
April (7)
March (8)
February (3)
January (3)
October (1)
2024
November (6)
October (7)
September (2)
April (5)
May (2)
February (1)
January (1)
2023
October (7)
November (7)
September (1)
June (3)
2022
November (2)
October (2)
May (3)
April (1)
September (1)
2021
- Blitz Report – Rel 3.2 – New features, improved workflow – EM
- Blitz Report – Rel 3.2 – New features, improved workflow – CT
- Blitz Report – Rel 3.2 – New features, improved workflow – PT
- Blitz Report – Release 3.2 – Customer Review – pd
- Blitz Report – Release 3.2 – Customer Review – ct
- Blitz Report – Release 3.2 – Customer Review – em
- DOUG: How to deliver EBS data directly to an Excel pivot table
- SROATUG: Worlds fastest EBS reporting introduces templates, pivots and drill-downs
- DOUG: Upgrading to 12.2? – How to use Enterprise Command Center Data WITHOUT a separate ECC Server
- MOUS: Two (2) Blitz Report™ talks – Dates/Times inside
- NYOUG: Running Oracle EBS on Cloud? Beware of this overlooked performance metric
- AUSOUG: Running EBS on Cloud? Be aware of this overlooked performance metric!
- Blitz Report transforms Oracle EBS reporting with 3 new features – pt
- Blitz Report transforms Oracle EBS reporting with 3 new features – ct
- Blitz Report transforms Oracle EBS reporting with 3 new features-em
- Blitz Report™ – 10 Ways to improve EBS Reporting
- On-Site Meet Up Space Reservations
- On-Site Meet Up Space Reservations
- EBS financial analysis with pivot tables – Reporting that won’t break the bank – pd
- EBS Financial analysis with Pivot tables – Reporting that won’t break the bank – cd
- EBS financial analysis with pivot tables – Reporting that won’t break the bank – em
- Ascend 2021 – Oracle Users Conference
- AUSOUG: Blitz Report™ – What’s new with the World’s fastest EBS reporting solution?
- Find your happiness – Blitz Report, the world’s fastest reporting for Oracle EBS
- Find your happiness – Blitz Report, the world’s fastest reporting for Oracle EBS – eu
- Webinar: Reconcile your inventory to G/L balances with ease, from 1-1,000 inventory organizations
- OATUG: Reconcile your inventory to G/L Balances with ease, from 1-1,000 inventory organizations
December (2)
November (4)
October (10)
September (5)
August (7)
June (5)
May (5)
April (5)
March (3)
2020
- Excel based ASCP Planner Workbench – A faster, easier approach
- Oracle EBS Enterprise Command Center – Reporting Toolkit – powered by Blitz Report
- Blitz Report Project Toolkit – Improve performance and get results
- EBS Reporting Solutions – Review before you Renew
- Review before you Renew – EBS Reporting Solutions
- DOUG Training Day 2020
- NCOATUG – EBS Project Toolkit for Implementation Consultants
- NCOATUG Talk: Blitz Report™ Data Migration Toolkit – A “must have” when starting a new Oracle EBS upgrade or implementation project
- EBS FORUM@2pm: Enterprise Command Centers (ECC) in Oracle 12.4 and up
- EBS FORUM@10am: Supply Chain Hub
- DCOUG Webinar – New Supply Chain Hub
- Webinar – Introducing Supply Chain Hub – 2020-05-21 PDT
- Webinar – Introducing Supply Chain Hub – 2020-05-19 GMT
- Webinar – Introducing Supply Chain Hub – 2020-05-18 EDT
- Webinar – Blitz Report Seamless Integration with Oracle EBS – 2020-05-22 EDT
- Webinar – Blitz Report Seamless Integration with Oracle EBS – 2020-05-20 GMT
- Webinar – Blitz Report Seamless Integration with Oracle EBS – 2020-05-19 CDT
December (4)
November (3)
October (8)
September (2)
August (2)
July (4)
June (5)
May (9)
January (1)
2019
- Gateway OATUG Kansas City Event
- TXLAOATUG Training Day, Houston
- GITEX Technology Week, Dubai
- UKOUG Partner of the Year Awards
- AUSOUG Connect 2019, Perth
- AUSOUG Connect 2019, Melbourne
- NWOAUG Portland OR
- BCOAUG – Fall Meeting
- UKOUG Analytics Modernisation Summit
- MOUS Michigan Oracle User Summit
- ECO East coast oracle conference
- DCOAUG Fall Meeting
- MAOAUG, Atlanta
- MEOUG Majils conference, Dubai
- HOUAG / HOUG – Quarterly Meeting
- Life is short, work fast! Blitz Report™ – the fastest & easiest way to export Oracle EBS data into Excel
- Discoverer Replacement for EBS – Don’t throw the baby out with the bathwater!
- Speed up Your EBS: Simple and Effective Performance Tuning using Excel
- OUG Ireland 2019, Dublin
- San Antonio, TX Collaborate 2019
- Dallas DOUG Dinner Meeting – Performance Tuning – to improve EBS User Experience – Dallas, TX
- Rocky Mountain (RMOUAG) Training Days, Denver, CO
- EBS Performance Tuning Simplified – Tips,Tricks and a free toolkit!
- SROAUG 2019 Spring Conference, Los Angeles
- Ohio Valley (OVOAUG) Winter Meeting – Louisville, KY
- Pittsburgh OAUG Chapter Meeting – Pittsburgh, PA