Human Capital Management - EBS (MOSC)

MOSC Banner

Position create through API (flex-value does not exist)

edited Sep 11, 2013 10:59PM in Human Capital Management - EBS (MOSC) 4 commentsAnswered
Hi All,

when upload  Position through API but face some thing.

Error generate:

ora-20001:flex-value does not exist:
ora-06512: at "apps.hr_position_api"line 2978
ora-06512:at line 19
Line:---

API

DECLARE
x_emp_num VARCHAR2(200) := Null;--'90909090' ;
--x_business_group_id INTEGER;
--x_person_type_id INTEGER;
x_validate_mode BOOLEAN := FALSE; 
x_POSITION_ID number;
x_EFFECTIVE_START_DATE date;
x_EFFECTIVE_END_DATE date;
x_POSITION_DEFINITION_ID number;
x_NAME varchar2(1000);
x_OBJECT_VERSION_NUMBE number;

BEGIN
For csr_position in (select * from A_position A WHERE A.DISTRICT = 'Badin' AND A.DDO_CODE = 'BN4206' AND A.POST_CODE = 'SP02004') loop 
Tagged:

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