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
13011
accept rate: 1%

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.4k15
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: 314 times

Last updated: 11 Sep, 08:36

FOEX Links