Synchronize Instrument Program Fails with 'ORA-01843: Not a Valid Month' on Insert into Dimension Table
Last updated on APRIL 25, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 to 8.0.0 [Release 7 to 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA), when you run the Synchronize Instrument program, fn_Synchronize_Instrmts, you get an error on a dimension table in FSI_MESSAGE_LOG. For example:
Starting Synchronize Instrument
Error Occured while inserting into dimension base table:DIM_CUSTOMER_B ORA-01843: not a valid month
If you un-comment the dbms_output statements in the related procedure, SYNCHRONIZE_INSTRUMENT, to get the insert statement, they get the following error:
INSERT INTO DIM_CUSTOMER_B(CUSTOMER_ID,CUSTOMER_DISPLAY_CODE,LEAF_ONLY_FLAG,ENABLED_FLAG,DEFINITION_LANGUAGE,CREATED_BY,CREATION_DATE,LAST_MODIFIED_BY,LAST_MODIFIED_DATE) VALUES (9200428,9200428,'Y','Y','US','SYSADMN',08.12.2014,'SYSADMN',08.12.2014)
Error Occured while inserting into dimension base table:DIM_CUSTOMER_B ORA-00917: missing comma
The error prevents values from the dimension column in the instrument tables from getting created in Dimension Management.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms