EBI9.1+: BIPRELD Fails At BIPRELD.DELSTG.DELHDRC (SQL) for MS SQL Database (Doc ID 1914907.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

Statement of the issue:
------------------------------
Bug 17439520 delivered in SCM 9.1 Bundle 29 has added three new SQL`s
BIPRELD.DELSTG.DELHDRC(SQL)
BIPRELD.DELSTG.DELLNC(SQL)
BIPRELD.DELSTG.DELLNC2(SQL)

BIPRELD fails at BIPRELD.DELSTG.DELHDRC(SQL)
This is the specific error being given:
SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near ','.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37

Expected Behavior:
-----------------------
BIPRELD should not fail at BIPRELD.DELSTG.DELHDRC(SQL).

Steps to Replicate:
--------------------

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