My Oracle Support Banner

EBI 9.2: The Billing Preload Process Abends at Step BIPRELD.UPDSEQ.Step01 With Error Message Stating 'Numeric Value out of Range' (Doc ID 3034059.1)

Last updated on DECEMBER 12, 2024

Applies to:

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

Symptoms

While running the BIJOB03 PSJob, the Billing Pre-Load process (BIPRELD AE Program) abends at Step BIPRELD.UPDSEQ.Step01, stating that a numeric value of the transaction may be out of range.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a Billing User.
    2.- Navigate to: Billing > Generate Invoices > Non-Consolidated > Pre-Load Process
    3.- Create a new Run Control ID, and define the needed values for the below fields:
           - Business Unit = XXXXX
           - Range Selection = Invoice
           - From Invoice = XXXXXXXXXX
           - To Invoice = XXXXXXXXXX
    4.- Click on RUN button.
    5.- Navigate to: PeopleTools > Process Scheduler > Process Monitor
    6.- PROBLEM: Confirm that the BIPRELD AE Program has abended with an Error Message.

ERROR MESSAGE:

    " 10:02:39.354 ....(BIPRELD.UPDSEQ.Step01) (Do Fetch)

      File: C:\PT860P05C_2304031456-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1851  Error Position: 0  Return: 8635 - [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range

      [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range

      Failed SQL stmt: SELECT LINE_SEQ_NUM   ,(CONVERT(CHAR(10),ACCOUNTING_DT,121))   ,ACCT_ENTRY_TYPE   ,DISC_SUR_LVL   ,DISC_SUR_ID   ,LINE_DST_SEQ_NUM   ,TAX_AUTHORITY_CD   FROM PS_BI_ACCT_LN_STG   WHERE BUSINESS_UNIT = :1   AND INVOICE = :2   AND PROCESS_INSTANCE = :3

      2023-12-01-10.02.38.000632  GetNextStateRecord [68] Exception logged: RC=3.

      Process 1763854 ABENDED at Step BIPRELD.UPDSEQ.Step01 (Do Select) -- RC = 8635 (108,524) "


The Billing Pre-Load process (BIPRELD AE Program) should be able to handle all Invoice transactions without such an abend, so that the Invoice transactions get further processed into the FIN Billing module, and interfaced into FIN Accounts Receivable as needed.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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