EBI9.2:SQL Error While Running BILDGL01 Process
(Doc ID 2560326.1)
Last updated on SEPTEMBER 03, 2024
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 |