BIP Publisher in Fuision Financials - data model problem - so OBIA version 11.1.1.9 as my issue is entirely in the cloud.
I am trying to work around a prebuilt data model which uses a package to populate its data, so there is a lot that I cannot touch / change.
I need to use an existing prompt with LOV to apply an extra date condition on the data model.
The date is not held as a date in the LOV, it is a period selector in the format 'Nov-2008' - so text.
I have read that to reference the existing parameter I just need to use the syntax &MyPeriodSelector - I know I need to convert my text into a date to allow meaningful comparison
The problem I have is when I try this and put in the value Nov-2008 it errors saying the below; -
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00904: "NOV": invalid identifier
and prd.calendar_period_open_date <= to_date(&MyPeriodSelector,'Mon-YYYY')
Can anyone tell me the right syntax to use for this please, I have experimented for some time, but each time I just get a subtly different kind of error.
I also tried with ' ' around the parameter name but then it just treats it as a literal.
thank you,
Teresa X.