Hello, I wanted to pass along an error that we received when using the API Invoice Upload report for the first time in our Production environment. The request log files are included with this message along with the Excel file that was actually uploaded.
The request log states the following:
Error at line 840:
aia.amount_applicable_to_discount,
ORA-01790: expression must have same datatype as corresponding expression
ORA-06512: at “SYS.DBMS_SQL”, line 1721
We are actually not trying to load anything into that amount_applicable_to_discount field, so I’m not sure where the issue lies. I tried loading the same exact set of data into our Test environment via the same upload report, and it completed successfully without any issues.
The strange thing is the invoices did actually load into our Production environment–even though the report completed in error. I will say we are on a slightly more recent version of Blitz in our Test environment.
Please let me know if you need any additional information in order to help diagnose the issue.
Thanks,
Viewing 0 reply threads
Viewing 0 reply threads
- 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 1228
- Getting all horizontal with ASCP planning 3944
- How to use EBS audit functionality to speed up operations 4113
- Accessing external data sources with Blitz Report™ 2219
- Does Oracle Discoverer 11g work with Oracle Database 19c? 4247
- Blitz Report™ Champion – quarterly awards announcement 1689
- Can data governance be free? 3489
- EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6486
- Ungarbling Oracle EBS Financial Accounting 3735
- Discover the secret of perfectly formatted Oracle EBS Excel report creation in under 10 minutes 4286
- A simpler way to work with Automatic Workload Repository (AWR) 3558
- Blitz Report Champion – absence visualization in Oracle EBS 1845
- Oracle E-Business Suite – concurrent request monitoring and alert reporting 6282
- Oracle Enterprise Command Center Framework upgrade to V4 3746
- How to quickly create or modify Oracle E-Business Suite BI Publisher based reports 5665
- How to replace Oracle ASCP exceptions with Blitz Report 2946
- How to add Blitz Report™ to your favorite form 3198
- How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ 3820
- Oracle E-Business Suite Inventory period-end optimization / close 4112
- Oracle Supply Chain Hub that takes simplicity to another level 5824
- How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123802
- How to put the Advanced functions into Oracle EBS Supply Chain Planning (ASCP) 4292
- How to optimize Order Management form exports in Oracle EBS 3792
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