ODPM-00074: Invalid Date Error -When Integration Interface Run on Sunday (Doc ID 1577585.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.0 and later
Information in this document applies to any platform.

Goal

Customer has a weekly time bucket with Monday as the first day of the week

1. Customer has an inbound integration interface to collect lead time. This is loaded at an item org level. They load the BIIO table through a custom process. Then they run the process through a workflow for the transfer step.

2. When they run this on a weekday (not a Sunday), it loads fine.

3. However when they run this on Sunday(with the SDATE columns having the Sunday date like 08/04/2013 10:21:42) it fails with an Invalid Date error . For the same data set if run on another day it completes fine with the SDATE having a date like say 08/07/2013 10:21:42

It is reproduce able in any instance and it only happens when they run the job on a Sunday.

Collaboration logs show the following

Collaborator log

2013-08-04 10:22:16,726 CDT WFProcess_5 INFO appserver.integration: Import Data.
2013-08-04 10:22:16,726 CDT WFProcess_5 INFO appserver.integration: ODPM-20044: Run Start Time: 08-04-2013 10:22:16
2013-08-04 10:22:16,726 CDT WFProcess_5 INFO appserver.integration: ODPM-20045: Interface Name: XXDEM 4668 LEAD TIME
2013-08-04 10:22:16,830 CDT WFProcess_5 INFO appserver.integration: ODPM-20046: Profile Name: XXDEM_4668_BIIO_LT
2013-08-04 10:22:16,830 CDT WFProcess_5 INFO appserver.integration: ODPM-20052: Owner: sop
2013-08-04 10:22:16,830 CDT WFProcess_5 INFO appserver.integration: ODPM-20053: Profile From Date: 07-30-2012
2013-08-04 10:22:16,830 CDT WFProcess_5 INFO appserver.integration: ODPM-20054: Profile Until Date: 07-27-2015
2013-08-04 10:22:20,959 CDT WFProcess_5 ERROR appserver.integration: ODPM-00077: Query Validator of Profile 'XXDEM_4668_BIIO_LT' Encountered 42295 Errors.
atch Error Table 'XXDEM_4668_BIIO_LT_ERR' For More Information.
2013-08-04 10:22:24,137 CDT WFProcess_5 INFO appserver.integration: ODPM-20064: Rows processed: 0.
2013-08-04 10:22:27,038 CDT WFProcess_5 INFO appserver.integration: ODPM-20048: Run End Time: 08-04-2013 10:22:27
2013-08-04 10:22:27,039 CDT WFProcess_5 INFO appserver.integration: ODPM-20049: Run Duration Time (hh:mm:ss:msec):0:0:10.400
2013-08-05 17:56:33,481 CDT WFProcess_6 INFO appserver.integration:

The BIIO_err table shows the following error

[ODPM-00074: Invalid Date]

This is reproducible on all instances
 

Solution

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