My Oracle Support Banner

Creating Geography Hierarchy In Portugese Language Gives Error ORA-01861: Literal Does Not Match Format String (Doc ID 822114.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.


Attempting to create State and City values in the Portuguese language and receive the following error:

ORA-01861: Literal Does Not Match Format String.

The error does not occur for the English language.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.