Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Date format error - OAMP2OPY:GYYEWLWG
In my dashboard I have a prompt to change the date of my query.
After migrating to Oracle 12.2.1.2.0, in my dashboard, when I change the date or I click to 'Applica' I have this error
Codici di errore: OAMP2OPY:GYYEWLWG
Previsto un valore di data. Ricevuto "13/04/2017".
Have you some ideas to investigate?
Best regards.
Sergio
Answers
-
Hi @3520535,
I guess these two dates are setting up presentation variables that you use in your analysis. In that case the PVs will be string and while OBIEE can sometimes convert it to date, it's always a good practice to do an explicit conversion. That way even if the user changes his/her date formatting, it will still work.
OBIEE 12c is actually a bit more picky about the format for implicit conversion with the default settings.
In your analysis, change the prompt so it is something like
"Dim Date"."Date ID" Between TO_DATETIME('@{PV_StartDate}{01/01/2017}', 'dd/mm/yyyy') and TO_DATETIME('@{PV_EndDate}{31/12/2017}', 'dd/mm/yyyy')
Best Regards,
JeromeFr
[Edit] Syntax correction, thanks to @Gianni Ceresa for pointing it out.
0 -
Hi Jerome, thank you for the answer.
I'm having some problems with the explicit conversion.
When I change with 'formula' I lose the calendar.
Sergio
0 -
Yes in the prompt the field has to be a DATE or DATETIME to display the calendar. My suggestion was to edit the filter in the analysis, not the prompt.
However I see there is actually a patch that you could apply. It would spare you from editing all your dashboards. Have a look for patch 23211224 on My Oracle Support.
0 -
Thank you Jerome. Tomorrow I will try the patch and I will let you know.
Sergio
0 -
Sorry for my late reply. Probably the patch is for the cloud. I'm looking for editing the filter.
Sergio
0 -
Hello Sergio,
Could you please check the column formula where this value getting used. Try it in the below format.
Date '@{PV_DATESM}{2017-01-30}'
Not in your prompt, but in the report.
0 -
Hi ASIM. The statement is correct but I have a problem with the 'Apply' after date selection from calendar.
I found that there was a bug ( BUG 9280334 ).
0 -
Hello Sergio,
did you solve the issue?
We faced the same problem upgrading the system to the 12c version.
We applied the patch 23211224 but it didn't solve the issue.
The problem appear only if we use the italian language, if we log in english it did not happen.
It seems the problem is when apply the selection from the italian calendar (format dd/mm/yyyy), the system accept it in the english format (mm/dd/yyyy) and for day higher than 12 the error appear.
Please let we know if you find the solution.
Thank you.
Valeria
0 -
Hi Valeria. Thank you for the post. I run an application on Linux and on Windows.
On Linux is correct but oracle bi change the format, on windows it doesn't.
Unfortunately, my visitors use windows in italian version.
I'm investigating ...
Experience is the name every one gives to their mistakes.Oscar Wilde
0 -
Hi Sergio,
we are using a Linux server and we applied the patch 23211224 but it doesn't work.
We have a customer with Windows server where the same patch works.
So our situation seems opposite of yours.
Keep me posted on your investigation....
Regards,
Valeria
0
