REP-0613: Value does not match mask 'DD MON RRRR'

[audinjm]

I am hoping someone here can help me. I have checked Metalink and found nothing of value.

I have created a clone of a delivered Oracle 6i Report (Receivables Customer Open Balance Letter). The delivered report is using the Value Set FND_STANDARD_DATE for the As_of_date parameter. The input mask set up for this parameter is YYYY/MM/DD HH24:MI:SS.

My cloned report uses the same Value Set and has the same input mask defined in the report. However, when I run my version of the report, I get this error:


REP-0613: Value does not match mask 'DD MON RRRR'.
ORA-01858: a non-numeric character was found where a numeric was expected

REP-0091: Invalid value for parameter 'P_AS_OF_DATE'.


I am at a loss as to where the DD MON RRRR format is coming from in my cloned report. This is not happening in the delivered report.

Does anyone have any suggestions on where I might find this incorrect format mask? I am a developer and have no sys admin responsibility. I would welcome any advice at all on this as I have exhausted all of my resources here. Thanks.

Jodi

 

[nagornyi]

What is FND_STANDARD_DATE?
What is in the property inspector for the P_AS_OF_DATE parameter?

 

[audinjm]

FND_STANDARD_DATE is a seeded value set that was also delivered by Oracle. It has a Format Type of Standard Date.

In the report builder, the input mask on the property palette is YYYY/MM/DD HH24:MI:SS.

I have no idea where it is picking up the DD MON YYYY format.