My Oracle Support Banner

AddProjectMembersPG : Error While Adding New Employee as Project Manager : Row 1 Error - ORA-01400: Cannot Insert NULL Into ("APPLSYS"."FND_GRANTS"."GRANTEE_KEY") in Package PA_PROJECT_PARTIES_PUB Procedure PA_RESOURCE_UTILS.check_res_exists (Doc ID 2944911.1)

Last updated on JANUARY 05, 2024

Applies to:

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


Encountering error when adding a new employee to a project as the Project Manager:

Row 1 Error - ORA-01400: cannot insert NULL into ("APPLSYS"."FND_GRANTS"."GRANTEE_KEY") in Package PA_PROJECT_PARTIES_PUB Procedure PA_RESOURCE_UTILS.check_res_exists

Steps to reproduce:


  1. From a project super user responsibility, navigate to Projects: Delivery > Search Projects
  2. Open the project
  3. Navigate to Project > Setup > Team members
  4. Press Add Team Members button
  5. Enter details of new employee and press save, receive the error.


 New Employee added


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

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