My Oracle Support Banner

Duplicate Assignments Are Creating through PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENTS API (Doc ID 2601095.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Project Resource Management - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Setup

API " PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENTS" is creating double the assignments of No. of Copies select.

Example if NUMBER_OF_REQUIREMENTS when selected 1, it is creating 2 assignments.
  and if NUMBER_OF_REQUIREMENTS: when selected 2, it is creates 4 assignments.

The issue can be reproduced at will with the following steps:
1. Connect to SQL developer or Toad
2. Create an Anonymous block and run the API PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENTS, by providing input (no of copies=1)
3. There are 2 assignments getting created


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.