My Oracle Support Banner

OBIEE 11g: Date Write Back does not Work as the Date Format Changes to YYYY-DD-MM (Doc ID 1622711.1)

Last updated on JANUARY 10, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

You have a write back report that has two date type columns. You display the date in MM/DD/YYYY format.

When you update both date columns the report is able to update successfully. But when you update only one date column, OBIEE changes the date format to YYYY-MM-DD when trying to write the data, so the write back process is not completed, and OBIEE errors out.

Here is the error message from the NQServer.log file:

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: <ECID>,0:1:4] [tid: 1f2c] [nQSError: 17011] SQL statement execution failed. [[
[nQSError: 17001] Oracle Error code: 1843, message: ORA-01843: not a valid month
 at OCI call OCIStmtExecute:
   <Writeback Template Here>

[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 43113] Message returned from OBIS.

 

Cause

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
Symptoms
Cause
Solution
References


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