API PA_PROJECT_ASSETS_PUB.DELETE_PROJECT_ASSET is encountering "External product code required"
API PA_PROJECT_ASSETS_PUB.DELETE_PROJECT_ASSET is encountering the error "External product code required." when the project asset was created within EBS. The PM_PRODUCT_CODE field is null since the project asset was created directly in EBS.
We are removing 300+ Project asset so we are trying to use the API.
Below is the script that we are trying to execute
DECLARE
l_api_version_number NUMBER;
l_commit VARCHAR2(100);
l_init_msg_list VARCHAR2(100);
l_msg_count NUMBER;
l_msg_data VARCHAR2(100);
l_return_status VARCHAR2(100);
l_pm_product_code VARCHAR2(100);
l_pm_project_reference VARCHAR2(100);
l_pa_project_id NUMBER;