Position create through API (flex-value does not exist)
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
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:
0