My Oracle Support Banner

EBI9.2: BILARDR01 - Cannot Insert NULL into ("SYSADM"."PS_PENDING_ITEM"."AR_INBOUND_IPAC") (Doc ID 2119398.1)

Last updated on AUGUST 24, 2018

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, Direct Invoicing

BILARDR01 - bildar01.sqr: BILDAR01 - SQL Statement =
SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("SYSADM"."PS_PENDING_ITEM"."AR_INBOUND_IPAC")
Error on line 71:
  (SQR 3301) Program stopped by user request.

The issue can be reproduced at will with the following steps:
1. Create an invoice in Billing
2. Generate the bill
3. Run BILDAR01.sqr

The issue has the following business impact:
Due to this issue, users cannot process bills.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.