Projects - EBS (MOSC)

MOSC Banner

API PA_PROJECT_ASSETS_PUB.DELETE_PROJECT_ASSET is encountering "External product code required"

edited Aug 27, 2019 5:00AM in Projects - EBS (MOSC) 2 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center