Fusion BI Publisher - Error When Running Report :"error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0"
(Doc ID 2535524.1)
Last updated on NOVEMBER 22, 2023
Applies to:
Oracle Fusion Financials Common Module - Version 11.12.1.0.0 and laterOracle Fusion Application Toolkit Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
Symptoms
You created a BI Publisher Data Model using SQL Query and created a parameter value named LAST_PO_DATE.
In the data set the criteria is setup to: transaction_date <='LAST_PO_DATE'
When trying to view data bellow error is displayed:
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |