EBI9.2: BI_LOCEXT Process Abends At STEP BI_LOCEXT.MARKHDR.STEP01(SQL) (Doc ID 2091268.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms


Statement of the issue:
-----------------------------
BI_LOCEXT proccess fails at step BI_LOCEXT.INSRTSEL.Step03 (SQL)

Error Message:
----------------------
File: e:\pt85306c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'H'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt: UPDATE PS_BI_HDR H SET H.PROCESS_INSTANCE = 8414315 WHERE H.BILL_STATUS IN ('TMP', 'TMR', 'NEW', 'HLD', 'PND', 'RDY') AND H.LOC_DOC_ID <> ' ' AND H.PC_DISTRIB_STATUS <> 'I' AND H.CONSOL_HDR = 'N' AND H.PROCESS_INSTANCE = 0

Process 8414315 ABENDED at Step BI_LOCEXT.INSRTSEL.Step03 (SQL) -- RC = 8601 (108,524)

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