- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 67 Insurance
- 536.8K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
WFR reporting not working
I have installed WFR 188.8.131.52.0. I have enabled reporting in .ini file. As a prerequisite, reporting script to created the DB objects for WFR reporting was executed on WFR schema.
However, when an invoice is processed in WFR, I found error in H_*.log with respect to reporting and no data is getting populated in reporting tables like OFRDOCUMENT, OFRFIELDS, etc.
Below is the error:
Reporting: [Oracle][ODBC][Ora]ORA-00904: "GETDATE": invalid identifier
I tried searching for GETDATE object in DB and also in WFR_AP_Reporting_Create_Oracle.sql script but couldn't find any.
Can anyone help here?