Hi Team,

Date format not recognized issue when the DATE_FORMAT is set to MM/DD/YYYY.

We are setting date format as below for the below item.

P0_DATE_FORMAT := 'MM/DD/YYYY'

In report column attribute for start_date we are using number / Date format as &P0_DATE_FORMAT.

The below errors we are getting from different pages.

  1. A system error occurred during processing contact administrator

  2. ORA-01821: date format not recognized.

It is not working on our instance and It is working fine in foex instance.

Please do needful at the earliest.

alt text

Thank You Rajasekhara

asked 22 Mar, 10:18

Sreenithi's gravatar image

Sreenithi
130112
accept rate: 1%

edited 28 Sep, 08:25

FOEX-SUPPORT's gravatar image

FOEX-SUPPORT
4.8k15

Can you please point us to your test case on our APEX 4.2 environment -> demo.tryfoexnow.com.

Can you also please put the page in debug mode and send the html source to support@tryfoexnow.com as well as a page export.

Thank you

(22 Mar, 10:46) FOEX-SUPPORT FOEX-SUPPORT's gravatar image

Hi Team,

Any update on this issue, as we shared the page in debug mode and html source in mail.

Thank You Rajasekhara

(05 Jun, 06:41) Rebecca Rebecca's gravatar image

We have gone through our email history and cannot find an email for this issue that has the debug output. Can you please resend?

(05 Jun, 07:01) FOEX-SUPPORT FOEX-SUPPORT's gravatar image

Hi Team,

We have sent you html source in debug mode and page export for your reference.

Mail Subject : "Dateformat issue page source and page export"

Thank You Rajasekhara

(16 Aug, 08:51) Rebecca Rebecca's gravatar image

Hi Team,

Any update on this issue, as we shared the required details in mail.

Thank You Rajasekhara

(11 Sep, 05:12) Rebecca Rebecca's gravatar image

Can you please make sure that P1112_DATE_FORMAT is set in session state by a process i.e. "Before Header".

You cannot rely on a default value for the item, since we will do substitutions during page render and if the format mask is null then the default application date format will be used.

link

answered 11 Sep, 08:36

FOEX-SUPPORT's gravatar image

FOEX-SUPPORT
4.8k15
accept rate: 32%

Hi Team,

We have tried as mentioned in the above, but still its not working.

Sent you the latest html source in debug mode and page export for your reference.

Issue replicated in foex instance as well.

Application : 700 and Page No : 1112

Please do needful at the earliest.

Thank You Rajasekhara

(27 Sep, 02:44) Rebecca Rebecca's gravatar image

We have identified the issue which is caused by escaping in the replacement of substitutions e.g.

DD/MM/YYYY

We will be providing a fix for this in the next hot fix release for v2.2.1 and v3.0.1.

As a workaround you could use a hyphen instead e.g. DD-MM-YYYY or DD.MM.YYYY

link

answered 28 Sep, 08:20

FOEX-SUPPORT's gravatar image

FOEX-SUPPORT
4.8k15
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×21
×17
×12

Asked: 22 Mar, 10:18

Seen: 484 times

Last updated: 28 Sep, 08:25

FOEX Links