Oracle Application Express (MOSC)

MOSC Banner

Work Date does not match format DD-MON-RR.

edited Dec 17, 2019 1:21PM in Oracle Application Express (MOSC) 2 commentsAnswered ✓

I am receiving this when I am using an editable interactive grid. I am trying to insert a record, it is giving this issue on an item that is of type

Date Picker

Source is Database Column

Database column name is Work_Date

Data Type = Date.

I want the user to be able to type in the format as 12/11/2019 and it write that format to the database as type Date.

I also tried to just use a Text Field and type the 12/11/2019 in but then I get

Ajax call returned server error ORA-20987: APEX - ORA-01843: not a valid month - Contact your application administrator. Details about this incident are available via debug id "1391". for .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center