The PA_PROJECT_PUB.UPDATE_PROJECT API Is Failing With Error PA_INVLD_PROJ_RATE_TYPE (Doc ID 2741627.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

Using a script to update the existing project currency rate types (Project Currency Rate Type and Project Functional Currency Rate Type). Using public API PA_PROJECT_PUB.UPDATE_PROJECT API to populat the fields P_PROJECT_IN.project_rate_type and P_PROJECT_IN.projfunc_cost_rate_type with CONVERSION_TYPE from gl_conversion_types with valid value. The GL conversion type is user defined and the CONVERSION_TYPE is a system generated value and is different from USER_CONVERSION_TYPE.

The UPDATE_PROJECT API is failing with error PA_INVLD_PROJ_RATE_TYPE due to following:

1) The API has a validation to check whether the conversion type is valid. The following is a piece of code from the API.

Passing the CONVERSION_TYPE and it is being validated with User Conversion Type and is failing with mentioned error.

2) The parameter value was changed to the User Conversion Type, the API went thru fine. However, the columns PROJECT_RATE_TYPE and PROJFUNC_COST_RATE_TYPE columns in PA_PROJECTS_ALL is populated with user conversion type and when trying to query the currency rate type from front end, BLANK values are being seen.

Cause

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