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 AUGUST 21, 2017

Applies to:

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

Symptoms

 On : 9.2 version, Load GL Acctng Entries

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

ERROR
-----------------------
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.

STEPS
-----------------------
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.

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

Cause

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