My Oracle Support Banner

EBI9.2:SQL Error While Running BILDGL01 Process (Doc ID 2560326.1)

Last updated on JULY 01, 2019

Applies to:

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

Symptoms

On : People Tools version 8.55, Application version Financial 9.2, Load AR Pending Items

When attempting to run BILDGL01 process, the following error occurs.

Error
------
"SQL Status = 515, SQL Error = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'END_INVOICE', table 'FIN92PRD.dbo.PS_BI_LOADGL_PROC'; column does not allow nulls. INSERT fails."

Steps To Replicate
-------------------

1. Create some invoices and change it to RDY status.
2. Finalize the invoice.
3. Run the job BIJOB06 or BIJOB05
4. Check the error in BILDGL01 process.

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.