My Oracle Support Banner

Projects Application Program Interface (API) PA_PROJECT_PUB.CREATE_PROJECT is Not Updating User Defined Attributes (UDA) / Extensible Attributes (Doc ID 2932818.1)

Last updated on JANUARY 19, 2024

Applies to:

Oracle Project Foundation - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

The Projects Application Program Interface (API) PA_PROJECT_PUB.CREATE_PROJECT is not updating the User Defined Attributes (UDA) / Extensible Attributes that are passed to the project being created.
The UDA values are passed through package procedure parameter, p_ext_attr_tbl_in, in the API call.
The project gets created successfully, but the UDA values are not populated.
And, there is no data associated to the project in UDA base table pa_projects_erp_ext_b.

Reference Doc ID 749794.1 and Doc ID 784362.1 for details on usage and storage of UDA values.

Steps:

  1. Connect to SQL Plus
  2. Execute the customized PA_PROJECT_PUB.CREATE_PROJECT API
  3. Review the newly created project extensible attributes

 

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.