My Oracle Support Banner

BI9.2: BILDAR01 Error ORA-01400: cannot insert NULL into ("SYSADM"."PS_PENDING_DST"."ACCOUNT") (Doc ID 2728466.1)

Last updated on NOVEMBER 27, 2020

Applies to:

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

Symptoms

When running BILDAR01, the following error occurs:


SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("SYSADM"."PS_PENDING_DST"."ACCOUNT").



Replication Steps:
1. Set up Up Financials/Supply Chain / Common Definitions / Design ChartFields / ChartField Inheritance / ChartField Inheritance / Receivables and Billing Always Inherit for Operating Unit
2. Create new lease
3. Activate the lease
4. Run the Manage Transaction Generator Process
5. Run Manage Interfaces to AP/Billing
6. Run BILDAR01

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.