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 MARCH 06, 2023

Applies to:

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

Cause

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