My Oracle Support Banner

PRC: Generate Intercompany Invoices For A Single Project Errors with cursor=25 code=-1400: ORA-01400: cannot insert NULL into ("PA"."PA_DRAFT_INVOICE_DETAILS_ALL) (Doc ID 1553690.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PAICGEN_SINGLE module: PRC: Generate Intercompany Invoices for a Single Project completes with the following error in the log file:

ORACLE error during DRAFT INVOICE GENERATION (cursor=25 code=-1400: ORA-01400: cannot insert NULL into ("PA"."PA_DRAFT_INVOICE_DETAILS_ALL)
PAI_ORACLE_ERROR
ERROR
cursor=25 code=-1400: ORA-01400: cannot insert NULL into ("PA"."PA_DRAFT_INVOICE_DETAILS_ALL
Unable to complete Invoice detail process.
ORA-01400: cannot insert NULL into ("PA"."PA_DRAFT_INVOICE_DETAILS_ALL"."DENOM_BILL_AMOUNT")
ORA-06512: at "APPS.PA_INVOICE_DETAIL_PROCESS", line 2487
ORA-06512: at line 1
  

Leaving paicexp()Error during Draft Invoice Generation. Module paicexp returned failure
PA_IGEN_ERROR
MODULE
paicexp
Error during Draft Invoice Generation. Module paicgop returned failure
PA_IGEN_ERROR
MODULE
paicgop

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
Cause
Solution


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.