EBI9.2:BILDAR01 Is Showing Error Cannot Insert NULL into ("SYSADM"."PS_PENDING_ITEM"."GROUP_BU") (Doc ID 2233932.1)

Last updated on FEBRUARY 15, 2017

Applies to:

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

Symptoms

On : 9.2 version, Billing Interface

When attempting to run BIDAR01,
the following error occurs.

ERROR
-----------------------
d:\mcfv92\sqr\bildar01.sqr: BILDAR01 - SQL Statement =
SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("SYSADM"."PS_PENDING_ITEM"."GROUP_BU")
Error on line 71:
(SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.



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

  1. Create a new Bill from Express Billing.
  2. Change the Status to Ready.
  3. Run Single Action Job BIJOB03.
  4. Check the process BILDAR01.

 

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