Continuous Collections Errors With ORA-01849: Hour Must Be Between 1 And 12

(Doc ID 2329194.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Data Collections

Continuous collections errors with ORA-01849 & ORA-14098

we were able to get past the earlier error but now are having the new error.

The Continuous Collections request only fails after 1pm (13:00). This is the only request that fails in the request set. All other child requests complete without any error.


ERROR
-----------------------
25-SEP 13:14:40 : Collections method: Continuous
25-SEP 13:14:40 : after calling REFRESH_SNAPSHOT
25-SEP 13:14:40 : v_process_org_present: 2
25-SEP 13:14:40 : Error while deciding the collection type for Entity ITEM
25-SEP 13:14:40 : Assumed incremental collection for following MVs
25-SEP 13:14:40 : ORA-01849: hour must be between 1 and 12
25-SEP 13:14:40 : Error while deciding the collection type for Entity BOM
25-SEP 13:14:40 : Assumed incremental collection for following MVs
25-SEP 13:14:40 : ORA-01849: hour must be between 1 and 12
25-SEP 13:14:40 : Error while deciding the collection type for Entity OH
25-SEP 13:14:40 : Assumed incremental collection for following MVs
25-SEP 13:14:40 : ORA-01849: hour must be between 1 and 12
25-SEP 13:14:40 : Error while deciding the collection type for Entity USUD
25-SEP 13:14:40 : Assumed incremental collection for following MVs
25-SEP 13:14:40 : ORA-01849: hour must be between 1 and 12
25-SEP 13:14:45 : Error while deciding the collection type for Entity WIP
25-SEP 13:14:45 : Assumed incremental collection for following MVs
25-SEP 13:14:45 : ORA-01849: hour must be between 1 and 12
25-SEP 13:14:47 : Error while deciding the collection type for Entity MRP
25-SEP 13:14:47 : Assumed incremental collection for following MVs
25-SEP 13:14:47 : ORA-01849: hour must be between 1 and 12

..............

25-SEP 13:18:10 : Profile value of MSC_REGEN_STATS: 1
25-SEP 13:18:11 : Alter table: ALTER TABLE MSC.SYSTEM_ITEMS_VSL LOGGING
25-SEP 13:18:11 : exchange part:-ALTER TABLE MSC_SYSTEM_ITEMS EXCHANGE PARTITION SYSTEM_ITEMS__21 WITH TABLE SYSTEM_ITEMS_VSL INCLUDING INDEXES WITHOUT VALIDATION
25-SEP 13:18:11 : ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
25-SEP 13:18:12 : Calling Linking of Sales Order for 11i source ...
25-SEP 13:18:12 : Procedure MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT started.
25-SEP 13:18:13 : .. In procedure GET_START_END_OP ..
25-SEP 13:18:13 : pST_STATUS= MSC_UTIL.G_ST_READY



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Continuous Collections


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