My Oracle Support Banner

Salary Proposal Error - ORA-20001: HR_51265_INVAL_PRO_REASON (Doc ID 2467404.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Human Resources - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to use hr_maintain_proposal_api.cre_or_upd_salary_proposal - API , the following error occurs:

ERROR
-----------------------
HR_51265_INVAL_PRO_REASON


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
US HRMS Manager > People > Enter and Maintain > Assignment > change salary basis >

Changes

nls_language parameter value in sqlplus  must have the same language as the one returned by below query:
select language from FND_LOOKUP_VALUES where lookup_type='PROPOSAL_REASON' and lookup_code = 'GSP'

Cause

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
Symptoms
Changes
Cause
Solution
References


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