ORA-1483 INVALID LENGTH FOR DATE OR NUMBERUpon further investigation it was noted that they were using 10.1.0.4 version of the database and that the database was installed onto a HP-UX(PA-RSIC) 64 bit server.
According to Oracle there is a known bug, number 3668164 entitled "SAVING A WORKBOOK USING DISCOVERER 10G GIVES - ORA-1483", within the 10.1.0.4 database that will prevent Discoverer from being able to save to the database. Upon further investigation it turns out that the operating system is a red herring and that this issue can in fact arise on any operating system!
The solution is to patch the database to 10.1.0.5 or higher. Apparently there is a one-off patch for 3668164, unless your database is running on a Windows server. In this case you will have to apply the full 10.1.0.5 database upgrade. So after that the client upgraded their database to 10.1.0.5 anyway, as many other bugs were fixed in this release.
After they upgraded their database the issue went away.
Note on this bug: bug 3668164 is not available for public viewing. This is most frustrating because Oracle has a lot of cross references to it on MetaLink.
Posted on behalf of:
Srinu Katreddi | Oracle Applications Consultant
Solution Beacon, LLC is a leading provider of expert-level resources for the most widely used Enterprise Management Systems and Technologies. We specialize in the Oracle Applications marketplace, providing leading expertise in Oracle’s all-in-one enterprise software, 
2 comments:
I’m impressed, I need to say. Really not often do I encounter a blog that’s each educative and entertaining, and let me inform you, you have got hit the nail on the head. Your concept is outstanding; the difficulty is one thing that not sufficient people are speaking intelligently about. I'm very blissful that I stumbled throughout this in my seek for something regarding this.
Istanbul hotels
To get an exceptional deciding item, the exposition ought to be amended carefully. Expression click here and style are essential parts of an article and are to be given exceptional consideration.
Post a Comment