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:
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 |