My Oracle Support Banner

R12 PRC: Update Project Summary Amounts Fails With ORA-01400 On EXPENDITURE_ITEM_DATE (Doc ID 1290089.1)

Last updated on SEPTEMBER 04, 2018

Applies to:

Oracle Project Planning and Control - Version 12.1.2 and later
Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


The PRC: Update Project Summary Amounts request fails with the following error:

  MSG-00001: Calling Maintain Project Accumulation at 12-JAN-2011 15:58:21
  MSG-00001: Concurrent request id is 21949705
  MSG-00001: ORA-01400: cannot insert NULL into 
    ("PA"."PA_COMMITMENT_TXNS"."EXPENDITURE_ITEM_DATE")
  MSG-00001: Exception was generated by Accumulation API
  REP-1419: 'beforereport': PL/SQL program aborted.
  REP-0069: Internal error
  REP-57054: In-process job terminated:Terminated with error:
  REP-1419: MSG-00001: Calling Maintain Project Accumulation at 12-JAN-2011 15:58:21
  MSG-00001: Concurrent request id is 21949705
  MSG-00001: ORA-01400: cannot insert NULL into
    ("PA"."PA_COMMITMENT_TXNS"."EXPENDITURE_ITEM_DATE")
  MSG-00001: Exception was generated by Accumulation API
  REP-1419: 'beforereport': PL/SQL program aborted.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.