"ORA-01843: not a valid month" Exception Running Package: pkg_integration_util.insert_transmission (Doc ID 1676272.1)

Last updated on APRIL 01, 2017

Applies to:

Oracle Transportation Management - Version 6.0 to 6.3.5 [Release 6 to 6.3]
Information in this document applies to any platform.

Symptoms

When performing pkg_integration_util.insert_transmission for the internal integration, it returns error.

-- Error Message:
ORA-01843: not a valid month.
ORA-06512: at "glogowner.partit", line 685
ORA-06512: at "glogowner.chk_biu_q_integration_in", line 7
ORA-04088: error during execution of trigger "glogowner.chk_biu_q_integration_in"
ORA-06512: at "glogowner.pkg_integration_util", line 180
ORA-06512: at line 6

Cause

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