Workplan Enter Planned Effort ORA-01400: Cannot Insert NULL Into "PA"."PA_RESOURCE_ASGN_CURR"."EXPENDITURE_TYPE"

(Doc ID 2373442.1)

Last updated on MARCH 14, 2018

Applies to:

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

Goal

How to get rid of below error when try to enter planned effort data?

  1. Row 1 Error - ORA-01400: cannot insert NULL into ("PA"."PA_RESOURCE_ASGN_CURR"."EXPENDITURE_TYPE") in Package PA_RES_ASG_CURRENCY_PUB Procedure ROLLUP_AMOUNTS
  2. Row 1 Error - User-Defined Exception in Package PA_RES_ASG_CURRENCY_PUB Procedure MAINTAIN_DATA
  3. Row 1 Error - User-Defined Exception in Package PA_FP_CALC_PLAN_PKG Procedure calculate:1100
  4. Row 1 Error - User-Defined Exception in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure add_planning_transactions
  5. Row 1 Error - User-Defined Exception in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure check_and_create_task_rec_info
  6. Row 1 Error - User-Defined Exception in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure Update_Planning_Transactions
  7. Row 1 Error - pa_fp_planning_transaction_pub.update_planning_transactions:User-Defined Exception in Package PA_TASK_PUB1 Procedure update_task_det_sch_info
 

Solution

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