My Oracle Support Banner

EBI 9.2: BILDGL01 Sqr Going To Error "[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'END_INVOICE" (Doc ID 2234568.1)

Last updated on JUNE 08, 2018

Applies to:

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


 On : 9.2 version, Load GL Acctng Entries

When attempting to run PSJob BIJOB06K which includes the SQR BILDG01.SQR,
the following error occurs.

d:\fscm\fin92tst\sqr\bildgl01.sqr: BILDGL01 - SQL Statement =
SQL Status = 515, SQL Error = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'END_INVOICE', table 'FIN92TST.dbo.PS_BI_LOADGL_PROC'; column does not allow nulls. INSERT fails.
Error on line 71:
(SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.
File contains SQR log showing the same error.

The issue can be reproduced at will with the following steps:
1. Create invoices for testing
2. Navigate to Main Menu> Billing> Generate Invoices> Consolidated> Create Accounting Entries
3. Select Run button.
4. Wait for process.
5. Click on PSJob Name
6. Select BICURCNV link to view Message Log
7. Click Message Log.
8. Click Return
9. Click BIPRELD to view Message Log.
10. Click Message Log.
11. Click Return.
12. Click BILDGL01 to view Message Log.
13. Click Message Log.

The issue has the following business impact:
Due to this issue, users cannot send accounting entries to GL.


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

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