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