EBI 9.2: App Engine BI_IVCEXT ( Billing Extract) Failing On SQL Server At BI_IVCEXT.POPESHPT.STEP01 (Doc ID 2400729.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

Symptoms

On : 9.2 PUM 27 version, Billing Finalization/Proforma

When attempting to run Billing extract BI_IVCEXT on SQL server the following error occurs.

ERROR
-----------------------
File: e:\pt85606b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 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]Incorrect syntax near ','.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHE
Failed SQL stmt: UPDATE PS_BI_EHDR_TAO4 H SET H.SHIP_TO_CUST_ID = ( SELECT DISTINCT L.SHIP_TO_CUST_ID FROM PS_BI_LINE L WHERE L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.INVOICE = H.INVOICE AND L.SHIP_TO_CUST_ID <> ' '), H.SHIP_TO_ADDR_NUM = ( SELECT DISTINCT L1.SHIP_TO_ADDR_NUM FROM PS_BI_LINE L1 WHERE L1.BUSINESS_UNIT = H.BUSINESS_UNIT AND L1.INVOICE = H.INVOICE AND L1.SHIP_TO_ADDR_NUM <> 0) WHERE H.PROCESS_INSTANCE = 150243 AND H.BI_BU_TAX_IND = '2' AND H.SHIP_TO_CUST_ID = ' ' AND EXISTS ( SELECT 'X' FROM PS_BI_LINE LIN WHERE H.PROCESS_INSTANCE = 150243 AND H.BI_BU_TAX_IND = '2' AND LIN.BUSINESS_UNIT = H.BUSINESS_UNIT AND LIN.INVOICE = H.INVOICE AND LIN.SHIP_TO_CUST_ID <> ' ')

Process 150243 ABENDED at Step BI_IVCEXT.POPESHPT.Step01 (SQL) -- RC = 8601 (108,524)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Finalization and print on sqlserver PUM 27 job BIJOB01
2. BI_IVCEXT will fail.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot print the bills.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.