EBI9.0+: BIIVC000 Pre-process And Finalization Process Abends When Processing Multi-line Bills (Doc ID 1583090.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Goal

On : 9 version, Billing Finalization/Proforma

Billing Error 936 BIIVC000 Pre-process and Finalization

I have a problem with Billing - BIIVC000 Pre-process & Finalization is abending when it tries to process multi-line Bills.
 
 Here's the message log -

-- 17.08.23 ....(BIPILNUM.SELBILLS.BUILDSQL) (Call Section BIPILNUM.ASGIVCL2)

-- 17.08.23 .....(BIPILNUM.ASGIVCL2.IVCLINE2) (Do Select)
%SelectInit(LINE_SEQ_NUM, ADJ_LINE_TYPE) SELECT A.LINE_SEQ_NUM,
A.ADJ_LINE_TYPE FROM PS_BI_FLINE_TAO4 A WHERE A.BUSINESS_UNIT = 'FASBU' AND
A.INVOICE = 'KRN-21048' ORDER BY
/
-- 17.08.23 Process 1603918 ABENDED at Step BIPILNUM.ASGIVCL2.IVCLINE2 (Action Do Select) -- RC = 936
ROLLBACK
/
-- 17.08.23 SQL Error: ORA-00936: missing expression

Solution

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