My Oracle Support Banner

Connected Query OM_SRCH_CUSTOMER_CQ MSSQL Error (Doc ID 2739425.1)

Last updated on DECEMBER 23, 2020

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Connected query n EP_OM_CUSTOMER failing to build. Connected Query OM_SRCH_CUSTOMER_CQ receiving SQL error on MSSQLServer

Steps to Reproduce Issue:

1.  Navigate to Reporting Tools, Connected Query, Connected Query Manager in MSSQL Environment
2.  Search for OM_SRCH_CUSTOMER_CQ
3.  Click Preview XML
4.  Enter date in format 01/01/1900 0.0.0
5.  Click OK gives Error

Changes

Not applicable. 

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
Changes
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.